Issue in Linked server (sql server 2008 r2 to sybase)

• amarnath.sahadevan

  SSC-Addicted

  Points: 420

  More actions

  May 7, 2014 at 6:50 pm

  #286478

  Hello All,

  I have a problem in linked server, prompting below mentioned error when trying to create linked server between SQL server 2008 r2 to Sybase server. Tried many solution from many forums, so far no luck.

  Below is the SQL version and Sybase driver version for your perusal, any help would be greatly appreciated.

  Driver name: Adaptive server enterprise

  Driver Version: 15.7.0.401

  Driver ODBC Version: 13.51

  SQL Version: SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

  OS: Win Server 2008 r2 Ent, SP1, build 7601

  Error:

  The OLE DB provider "ASEOLEDB" for linked server "UATSPIN" reported an error. The provider did not give any information about the error.

  Cannot initialize the data source object of OLE DB provider "ASEOLEDB" for linked server "UATSPIN". (Microsoft SQL Server, Error: 7399)

  Thanks/Regards,

  Amar

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  May 8, 2014 at 2:47 am

  #1711780

  Many ways to troubleshoot a Linked Server can be found in this article: http://www.sqlservercentral.com/articles/Linked+Servers/73794/

  -- Gianluca Sartori

• amarnath.sahadevan

  SSC-Addicted

  Points: 420

  More actions

  May 8, 2014 at 2:09 pm

  #1712015

  Thanks for the link, I will try all the steps and see whether the issue get resolved or not.