SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
ChrisMoix-87856
ChrisMoix-87856
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1394 Visits: 941
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?



SQL ORACLE
SQL ORACLE
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3371 Visits: 1314
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.
ChrisMoix-87856
ChrisMoix-87856
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1394 Visits: 941
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.



Jack Corbett
  Jack Corbett
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23834 Visits: 14905
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
macbolan75
macbolan75
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1
Not that this is your specific issue but after hours and hours of reading and reading and reading I found a lot of these issues come from a setting with the provider itself.

On sql server in server objects drill down to your specific provider and right click on it and select 'properties'. In your case the provider name is 'IMBDASQL'.

Once the properties are open make sure you check the box next to "Allow Inprocess" then select ok. Should work now
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search