I've installed the Lotus NotesSQL 8.5.1 ODBC driver and set up the ODBC system DSN. But I'm having trouble getting the OPENROWSET command to work. Can anyone give some specific examples of using OPENROWSET with the Lotus NotesSQL 8.5.1 ODBC driver?
I can't give you the syntax of a Connection String for NotesSQL 8.5.1 since I don't have it installed. But if I did have it installed, I'd create a File DSN in **Administrative Tools->Data Sources(ODBC)** with a connection to your Notes DB and then have a look at that file for hints on how to create the OPENROWSET command.