Linked Server problem using MSDASQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Linked Server problem using MSDASQL

Linked Server problem using MSDASQL

Rate Topic

Display Mode

Topic Options

Author

Message

Chris W

Posted Monday, May 11, 2009 10:24 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, July 16, 2010 10:04 AM
Points: 25, Visits: 119

Hi,

We are running SS2K5, SP2 Standard Edition; Windows Server 2003 (SP2), 64bit.

I'm trying to create a linked server using the MSDASQL provider (the only one I have available) to an AIX box running DB2 V8. I receive an error when testing the linked server connection..."Cannot initialize the data source object of OLE DB provider MSDASQL....". I read somewhere that I need to have the 64-bit version of the MSDASQL provider installed. How can I determine which version of this provider we currently have installed and is anyone else oout there successfully connecting to DB2 through a linked server using the 64bit version of MSDASQL?

Thanks in advance!
Chris.

Post #714315

Gift Peddie

Posted Monday, May 11, 2009 10:49 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 3,419, Visits: 14,163

Assuming your AIX is X64 then you need to download and install the Win2003 x64 OLE DB driver in the link below. The reason I have not seen x86 AIX box since the early 2000.

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

Kind regards,
Gift Peddie

Post #714340

Chris W

Posted Wednesday, May 13, 2009 6:57 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, July 16, 2010 10:04 AM
Points: 25, Visits: 119

Thanks for the advice. We tried the download but still no luck. Will we also need a 64bit ODBC driver?

Post #715918

Gift Peddie

Posted Wednesday, May 13, 2009 7:34 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 3,419, Visits: 14,163

Win2003 x64 actually comes with two ODBC driver I found that you need need either a fix from IBM or IBM client access tool. If you are not running the standard there is Microsoft provided OLE DB driver for IBM if you can use it let me know.

Kind regards,
Gift Peddie

Post #715969

nekonecny

Posted Thursday, May 14, 2009 12:58 PM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, January 21, 2012 11:24 AM
Points: 26, Visits: 275

Try check "double hop" problem.

Post #717292

« Prev Topic | Next Topic »

Permissions