Error ODBC Lotus NotesSQL

HCL Domino Domino Forum
1

Hello,

I have a problem with Lotus NotesSql 8.5 on Windows Xp.

My explanation:

I have installed NotesSql 8.5 on Windows Server 2003 and it work, but when I install NotesSql 8.5 on windows XP, I receive this error message : “SQL Native error : [23370], SQL MESSAGE : [LOTUS][ODBC Lotus Notes][Driver not Capable]”. I don’t understand, because I copied the path of “notes.ini” and the directory of install of NotesSql in the environement variable $path. And it still doesn’t work.

Can somebody help me?

if you need more information, ask me.

Thanks

2

Subject: Nsql_ALM.exe

try to open the Nsql_ALM.exe in the notesSQL folder and add the location of the notes.ini

3

Subject: When do you get the error?

Do you get the error when you are attempting to install the NotesSQL driver or when you are attempting to use (perform a query with) the NotesSQL driver (say from Access or Excel)?

4

Subject: I have this problem in the use of NotesSql

I have this problem in the use of NotesSql, and i configured the notesSQL with “Nsql_ALM.exe”. i have added user to notes.ini in “Nsql_ALM.exe” and there are no problem at this step. the problem is after

thank for your reponse

5

Subject: Something related to the user id password

We had a similar problem not long ago. I do not remember the specifics but I recall it had something to do with the password of the user id trying to use the NotesSQL driver… I think the user changed their Notes password. The connection string (in Excel in our case) was hardcoded with the old password. Changing the user id back to the old password made it start working. I realize that this is not “the answer” you are looking for but it might be worth investigating. Good luck!

6

Subject: Might be related to auto commit

Are you trying to read or write to the Notes DB?I’ve seen this happen when trying to insert or update documents in Notes. NotesSQL driver does not support commit operations.

Can you provide some more details?

7

Subject: I use only reading the basic notes

Let me explain, I get only the information contained in this database.With Lotus 7.0 and NotesSQL 3.02, it worked very well.

But with Lotus 8.5 and 8.51 NotesSQL, it no longer works.

If you want more details, ask me

Thanks for you respons