Connecting through a linked server from SQL Server 2012 to Intersystems Cashe

Question

We are trying to create a linked server in SQL Server 2012 to connect though ODBC to Intersystems cashe.  We have installed intersystems odbc driver on Sql server and it is able to connect to the cashe database. The problem is trying to create a linked server.  In the new linked server window I have used the following information.

Product name: InterSystems ODBC

Data source: FACS-DEF

Provider string: Dsn=FACS-DEF;Driver={InterSystems ODBC}

I have set up the security as "Be made using this security context" and have put in the correct username and password for the romote login.

However, I am getting the following message.

TITLE: Microsoft SQL Server Management Studio
------------------------------

The linked server has been created but failed a connection test. Do you want to keep the linked server?

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "TESTLINKED".
OLE DB provider "MSDASQL" for linked server "TESTLINKED" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)

The datasource name I have used is the Datasource name configured in the driver.

Any help on this problem would be great!

Answer 1

Hello,

I would suggest you to have a look at http://www.intersystems.com/support/index.html

There are also pages about communities which could help you , but we have to be registered and connected ( i have not tried to connect or register ). It is possible that the InterSystem ODBC driver has features specific for the use of linked server to SQL Server.

OLEDB is "special" and the support is ended.You should think to use another type of driver ( ODBC or other )

I think that you know these both links :

http://technet.microsoft.com/en-us/library/ms191462(v=SQL.105).aspx

http://blogs.msdn.com/b/selvar/archive/2007/11/10/msdasql-oledb-provider-for-odbc-drivers.aspx

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.