Linked Server ODBC error - help needed

Last Post 17 Nov 2009 02:09 PM by jakbklyn. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
jakbklyn
New Member
New Member

--
17 Nov 2009 02:09 PM
I'm working with an application that uses a proprietary database. I've created a unique System DSN which I want to use to query the proprietary db from within SQL 2005 Management Studio. The ODBC driver for the db is 32bit. When I use the Start>Run %windir%\SysWOW64\odbcad32.exe I can administer the ODBC driver and settings successfully but when I try to launch the Linked Server connection and query the database I see the following error message which I'm guessing is due to SQL not being able to make the connection to the 32 bit driver. Any help or suggestions would be appreciated.

TITLE: Microsoft SQL Server Management Studio
------------------------------

"The test connection to the linked server failed."

------------------------------
ADDITIONAL INFORMATION:

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 "BINGO".
OLE DB provider "MSDASQL" for linked server "BINGO" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)

For help, click: http://go.microsoft.com/fwlink?Prod...nkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Acceptable Use Policy
---