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.