Getting an error during creation of Link Server on SQL SERVER 2005 through RUMBA Driver

• dsachu

  SSCrazy

  Points: 2242

  More actions

  February 13, 2013 at 4:57 am

  #274123

  Hi,

  I am getting an error during creation of Link Server on SQL SERVER 2005.

  I have already created DSN (AS400JDE )

  like

  Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=*****;Data Source=as400jde;Mode=ReadWrite;Initial Catalog=****

  -------

  Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "FETCH".

  OLE DB provider "MSDASQL" for linked server "FETCH" returned message "[NetManage][RUMBA Data Access][AS400JDE]Communication link failure. APPC Primary RC = Comm_Subsystem_Not_Loaded; ".

  OLE DB provider "MSDASQL" for linked server "FETCH" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".

  OLE DB provider "MSDASQL" for linked server "FETCH" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".

  OLE DB provider "MSDASQL" for linked server "FETCH" returned message "[NetManage][RUMBA Data Access][AS400JDE]Driver not capable. SQLSetConnectOption". (.Net SqlClient Data Provider)

  -------

  Please help me.

  Regards,

• dsachu

  SSCrazy

  Points: 2242

  More actions

  February 13, 2013 at 10:13 pm

  #1587713

  Hi Gail,

  Would request you kindly look for the same.

  Regards,

  Sachin.

• dsachu

  SSCrazy

  Points: 2242

  More actions

  February 14, 2013 at 9:53 pm

  #1588186

  Hi,

  Can someone help please........this is urgent for me.

  Regards,

  Sachin.

  9891573054

• dsachu

  SSCrazy

  Points: 2242

  More actions

  February 19, 2013 at 11:07 pm

  #1589435

  Hi everyone,

  Would request, Please help or suggest me something on this issue. I will very thankful.

  Regards,

  Sachin.