I just downloaded the latest ODBC driver for Lotus Notes - NotesSQL and tried to connect tto the server using this syntax:

lcCon = "Driver={Lotus NotesSQL Driver (*.nsf)};" + ;
"Server=myserver;" + ;
"Database=mynotesdatabase.nsf;" + ;
"Uid=;" + ;
"Pwd=mypassword"

lnCon = SQLSTRINGCONNECT( lcCon )

This is the error I get when I try it:

Connectivity error: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

Got any suggestions on how to connect?