I am trying to pull data from a Sybase database using OpenQuery in SQL 2005. I had this setup before, but that server died and I need to set it up again.
The Sybase driver is installed on the Sybase database server. I created a linked server on the SQL server (I had the create script documented before the orginal server went down). Both servers are 32-bit. Everything looks the same to me,
but for some reason I keep receiving the error message below.
OLE DB provider "MSDASQL" for linked server "HORIZON" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 5
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "HORIZON".