Knowledgebase: ODBC > Connection
ODBC Driver Faulty After Collect! Upgrade
Posted by Linda, Last modified by on 30 March 2012 11:47 AM
We have recently upgraded Collect to version 11.4 Build 3.7 and it seems that the ODBC driver was also upgraded with the Collect upgrade as we are no longer able to use the Collect linked server in MS SQL Server 2008.
We are connecting to the ODBC driver via a linked server with MDASQL as the provider, using SQL Server Management Studio

1. Uninstall the ODBC driver RDS using instodbc -r as in instructions found at http://www.collect.org/cv11/Help/removeanodbcdatasource.html
2. Reinstall the ODBC driver RDS making sure you select the current ODBC driver shipped with your upgraded Collect! as in instructions found at http://www.collect.org/cv11/Help/addanodbcdatasource.html.
3. Since you are connecting to the ODBC driver via a linked server, you will need to recreate the linked server on SQL Server Management Studio.
(0 vote(s))
Helpful
Not helpful

Comments (0)