Skip to Content

Crystal Reports 2013 ODBC issue

Our analysts upgraded from Crystal Reports 2008 to Crystal Reports 2013 SP2.  After the upgrade the previous ODBC connections do not work (see errors below).  I am using the correct credentials and all the ODBC tests for the connection show successful.  The ODBC connection is a System DSN connecting to a SQL Server 2008 database.  I am unable to connect either with existing reports that connected without issue in CR 2008 or in trying to create a new report in CR 2013.  The drivers tried and errors are below.  

Microsoft SQL Driver (this was the driver previously used with no issues):

Logon Failed.  Database Connector Error: 'IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnctorAttr failed[Database Vendor Code 18]. Database Connector Error: '01000:[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open (SECCreateCredentials()). [Database Vendor Code 18].

Microsoft SQL Server Native Client 10.0:

Logon failed. Details: IM004:[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Any help is appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 19, 2015 at 09:06 PM

    Hi Wendy,

    What version of SQL Server are you using?

    Did you update the DSN to use the SQL Native 10 client dll?

    Once updated did you do a Verify database in CRD?

    Did you install the 32 bit SQL Server Client?

    Are you using the 32 bit ODBC Administrator from \windows\syswow64 folder?

    Don

    Add comment
    10|10000 characters needed characters exceeded