I’m trying to read information, which is stored in the Mail db using Lotus NotesSql, through a Windows application in C# .NET.I have downloaded the version 8 of Lotus NotesSql.
When I try to create a connection to the Lotus DB, it returns this error:
ERROR [S1C00] [Lotus][ODBC Lotus Notes]Driver not capable
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
ERROR [S1000] [Lotus][ODBC Lotus Notes]Unable to validate userid
ERROR [28000] [Lotus][ODBC Lotus Notes]Invalid authorization specification
I have read in this page http://www-1.ibm.com/support/docview.wss?rs=460&context=SSKTK9&dc=DB520&uid=swg21169645&loc=en_US&cs=UTF-8&lang=en that the Lotus ODBC driver does not support .NET / c# (in version 3.02f). Is this still true?
Otherwise what is the problem?
Thanks
Francesca
Subject: get the content (e.g. body) of an email
The problem seams to be solved. In the Lotus Notes Setup form I did not set the info about the User Name in the section NotesSql Options. Now it does not return the exception anymore, even if it ask always the password (e.g. to test the connection).Browse the tables and views of the db .nsf, I noticed that I am able to see the list of emails and some information like the date they has been received/sent, the receivers or the sender but I can’t see the content of the body. It is possible to get it through NotesSql or is it possible only with COM?
Subject: [Lotus][ODBC Lotus Notes]Driver not capable
Francesca,
There’s a work around. Once your ID file is valid and you have permission to the database, go to your SQL manager and create a linked server (using the ODBC DSN that you’d created for the NotesSQL) to the database that you need to access. You can then query to the SQL view that results from the linked server.
I haven’t done this myself but a co-worker just did it and that’s his explanation. I know it works because I’ve seen it working.
Subject: RE: [Lotus][ODBC Lotus Notes]Driver not capable
Sam,thank for your answer.
But every time I try to use the ODBC DSN for NotesSQL, it returns the message error "Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed.
I’ve checked also in the Event Viewer and actually there is this error: “Cannot locate the ID file Nothing listed in the KeyFilename entry in the NOTES.INI (located at C:\WINDOWS\notes.ini). Please verify the ID listed in KeyFilename is correct before continuing.” I’ve copied the iD file in C:\Windows but it still doesn’t work.
It behaves strangely also when I create the ODBC DSN: sometimes it shows the list of the available servers, but in the most of cases it shows only “local” server.
Please, help me.
Francesca