I’m trying to connect from the SQL 2008 Express edition to the NotesSQL data source. I have installed NotesSQL 8.5 ODBC driver and created a System DSN FORGUY. I can connect to this datasource from Excel. But all my attempts to create a linked server using this datasource are failing.
Here are my settings:
Linked server: FORGUY
Server type: Other data source
Provider: Microsoft OLE DB Provider for ODBC Drivers
Product name: FORGUY
Data source: FORGUY
Server options:
Data Access: True
RPC: True
RPC Out True
Here is the error message:
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 “FORGUY”.
OLE DB provider “MSDASQL” for linked server “FORGUY” returned message “[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed”. (Microsoft SQL Server, Error: 7303)
Googling brough no usable results. Please, help!