Linked Server problem using MSDASQL

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

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.worthington

Posted Monday, May 11, 2009 10:24 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 02, 2010 12:47 PM
Points: 17, Visits: 82

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

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 2,981, Visits: 12,075

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.worthington

Posted Wednesday, May 13, 2009 6:57 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 02, 2010 12:47 PM
Points: 17, Visits: 82

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

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 2,981, Visits: 12,075

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

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 01, 2010 6:40 AM
Points: 3, Visits: 63

Try check "double hop" problem.

Post #717292

« Prev Topic | Next Topic »

Permissions