Linked Server Error IBM iSeries AS400 cannot initialize the Data Source object of the OLE DB Provider MSDASQL

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 23, 2012 at 10:23 am

  #391635

  I get the following error when I expand the tables node on an AS400 Linked Server.

  At fist I realize that I did not install the iSeries Client Access Components.

  So I install and remove the Linked Servers.

  I reran the script to Create the Linked Servers but I get the Same Error.

  Any help would be greatly appreciated.

  I create these Linked Server on another Server a few weeks ago and I had no problems.

  Thanks.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 23, 2012 at 10:46 am

  #1451018

  I saw a blog on the Web that updating to IBM iAccess for Windows version (V7R1 - SI44594) or later.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 23, 2012 at 11:47 am

  #1451064

  I can't find the base install for the IBM iAccess for Windows version (V7R1 - SI44594).

  I can only find the SP for V7R1.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 24, 2012 at 6:15 am

  #1451350

  You have to have an account with IBM so you just can't go out and get it on the net.

  Someone placed the install files on a server but the name they gave me is not a valid server name.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/