Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DB@ Linked Server - Cannot initialize the data source object of OLE DB provider "IBMDASQL" Expand / Collapse
Author
Message
Posted Monday, May 12, 2008 11:59 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 21, 2013 10:48 AM
Points: 966, Visits: 933
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
Posted Monday, May 12, 2008 1:36 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 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
Posted Monday, May 12, 2008 1:40 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 21, 2013 10:48 AM
Points: 966, Visits: 933
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
Posted Monday, May 12, 2008 2:43 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:31 PM
Points: 11,265, Visits: 13,027
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 »

Add to briefcase

Permissions Expand / Collapse