Home » Windows OSRSS

Cannot initialize the data source object of OLE DB provider "MSDASQL"

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".

 

3 Answers Found

 

Answer 1

You mentioned that the Sybase ODBC driver is installed on the Sybase server, but you need the Sybase driver installed and properly configured on the server where SQL Server is installed, as well.
 

Answer 2

Sorry, Sybase driver is installed and configured on the SQL Server.
 

Answer 3

Is Sybase ODBC driver 32 bit as well?

Try the following steps:

Create a DSN entry via DSN wizard and check if Sybase driver can connect to the remote server (HORIZON in your case I presume). Create OLE DB data  source via UDL that calls into Sybase ODBC driver and see if this combination works.

 

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter