May 12, 2008 at 11:59 am
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?
May 12, 2008 at 1:36 pm
Did you have a chance to read the article below?
May it help.
May 12, 2008 at 1:40 pm
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.
May 12, 2008 at 2:43 pm
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
Consultant - Straight Path Solutions
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
November 4, 2014 at 4:17 pm
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy