error message: ODBC error 1

[JonBartels]

When I attempt to refresh my data I get the dialog box:
ODBC error: Canada][PVX OBDC Driver]Expected lexical element not found: <identifier>
I have re-installed Crystal Reports (ver. 7) and downloaded the latest Microsoft Data Access Components for OBDC.
Any ideas? Thanks.

 

[kgomotso]

Normally an ODBC error refers to your database connections. Checl from the control panel--> ODBC setup and make sure that your ODBC drivers are looking at the correct database

 

[JonBartels]

all: here's a follow-up
this crash was caused as a result of using &quot;Seagate Analysis&quot; (free download from Seagate) as a front end to Crystal Reports. Maybe it works well with the Stand-alone version of Crystal, but I certainly don't recommend using it with MAS OBDC drivers. Does anyone have a positive experience with Seagate Analysis?

 

[FowlerConsulting]

Try to use the CR ODBC drivers.
They are a FREE version of the Intersolve drivers, and are MUCH better then even some of the vendors can drivers.
Steven Fowler
steven_m_fowler@yahoo.com

http://www.fowlerconsulting.com

 

[JonBartels]

Steve - thanks for your suggestion. The version of Crystal Reports that I am using came bundled with &quot;MAS 90&quot;, the accounting software here. The OBDC drivers to hook CR with MAS 90 are not part of &quot;Standard&quot; CR, and are supplied by MAS 90.

mailto:jonathan.bartels@broadbeam.com

 

[JonBartels]

it turns out that this crash is a &quot;feature&quot; of the ODBC driver(!)

http://support.seagatesoftware.com/library/kbase/articles/c2007867.asp