[QODBC-ALL] Troubleshooting - Getting error when trying to configure QODBC in SQL Server
Posted by Jack - QODBC Support on 03 October 2017 11:34 AM
Troubleshooting - Getting error when trying to configure QODBC in SQL Server
I'm trying to install the QODBC on our SQL Server, and I followed all steps in your documentation How to create Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote.
But when I try to save my Linked server in SQL Studio, I have an error message:
The linked server has been created but failed a connection test. Do you want to keep the linked server?
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "QREMOTE".
OLE DB provider "MSDASQL" for linked server "QREMOTE" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)
Can you help me with that?
Please make sure that you are creating Linked Server on SQL Server machine where QODBC is installed. If you are creating the linked server from other machine where SQL Server Management Studio is installed but QODBC is not installed, then you may face this error.
You can verify it by closing SQL Server Management Studio (SSMS) & reopen it and at time of connecting to SQL Server option. Please remove server name & insert "." (i.e. dot) & try to connect.
If you are able to connect, then SQL Server is on local machine otherwise SQL Server is on other machine.