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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Getting an error during creation of Link...

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

Rate Topic

Display Mode

Topic Options

Author

Message

dsachu

Posted Wednesday, February 13, 2013 4:57 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:45 AM
Points: 90, Visits: 335

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,

Post #1419405

dsachu

Posted Wednesday, February 13, 2013 10:13 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:45 AM
Points: 90, Visits: 335

Hi Gail,

Would request you kindly look for the same.

Regards,
Sachin.

Post #1419812

dsachu

Posted Thursday, February 14, 2013 9:53 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:45 AM
Points: 90, Visits: 335

Hi,

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

Regards,
Sachin.
9891573054

Post #1420375

dsachu

Posted Tuesday, February 19, 2013 11:07 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:45 AM
Points: 90, Visits: 335

Hi everyone,

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

Regards,
Sachin.

Post #1421931

« Prev Topic | Next Topic »

Permissions