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.
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.
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
OLEDB is "special" and the support is ended.You should think to use another type of driver ( ODBC or other )
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.