DB@ Linked Server - Cannot initialize the data source object of OLE DB provider "IBMDASQL"

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » DB@ Linked Server - Cannot initialize the...

DB@ Linked Server - Cannot initialize the data source object of OLE DB provider "IBMDASQL"

Rate Topic

Display Mode

Topic Options

Author

Message

ChrisMoix-87856

Posted Monday, May 12, 2008 11:59 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 8:23 AM
Points: 966, Visits: 927

I'm trying to set up an OLE DB based Linked Server on a SQL Server 2005 machine (SQL Server 2005 64-bit running on Windows Server 2003 64-bit). to access DB@ on an AS400 via the IBM Client Access drivers (V5R4). I can't get the Linked Server to work, and I can't find any good information on the error anywhere online.

I can get an ODBC based Linked Server to work, but I get the following error with the Managed (.Net) providers:

Cannot initialize the data source object of OLE DB provider "IBMDASQL" for linked server "DB2400"

As you can see form the error, I am trying to get the IBMDASQL data provider to connect, but I keep getting the error.

Does anyone know how to get this to work?

Post #499010

SQL ORACLE

Posted Monday, May 12, 2008 1:36 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

Did you have a chance to read the article below?
http://www.mcpressonline.com/database/db2/db2-integration-with-sql-server-2005-part-i-linked-server-enhancements.html
May it help.

Post #499084

ChrisMoix-87856

Posted Monday, May 12, 2008 1:40 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 8:23 AM
Points: 966, Visits: 927

Yep, I read that article, and a lot of the comments on the site by people having the same problem as me.

it seems like Microsoft didn;t think through the Linked Servers and 64-bit stuff when they rolled out SQL Server 2005, from all of the problems that I've read about.

Post #499087

Jack Corbett

Posted Monday, May 12, 2008 2:43 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Sounds like there is not a 64 bit IBMDASQL driver. I know that I had problems with SQL 2000 and IBMDASQL linked servers and preferred using the ODBC driver as it worke dmore consistently.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #499137

« Prev Topic | Next Topic »

Permissions