I need expert advice regarding Linked server from SQL Server to Lotus Domino Server.
I have installed NotesSQL, Created ODBC DSN, from the excel I could connect the Domino database and retrieve the data. Meaning the NotesSQL setup & ODBC connectivity is just working fine.
Then I created a Linked server from SQL Server 2005, Selected "Microsoft OLE DB provider for ODBC driver"
I could successfully create the linked server but when I run the openquery it is giving the below error message.
OLE DB provider "MSDASQL" for linked server "LOTUS" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed". Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LOTUS".
I googled, nothing useful.