I would like to show data from my lotus notes base documents to my php website. I think I must use NotesSql to do this but I have a problem : I have configured my ODBC sources and choosen the .nsf file in the list. My .nsf file is located on a distant server. When I select my server in the ODBC source manager, I have the list of all my nsf file and there is no problem.
However, when I’m trying to connect to the ODBC source from my php website, I have this error : [lotus][odbc lotus notes]Path access to server not found, SQL state S1000
Someone knows what is the problem ? When I configure the ODBC source, it seems to have the right path…
Firstly, did you create a System DSN or a User DSN, you should be creating System DSN.
Other things to try:
Next, look in your WinNT Event Viewer to see if NotesSQL gave any reason why it failed to load. If it does, follow the directions in the error.
Lastly, is your PHP server running as a service or running under different credentials than when you set up your DSN? If so, you must make sure the user that’s logging into that service has the correct rights to the NotesSQL directory, the Notes and subfolders directory, the Temp directory (which, for services may be \windows\temp or \winnt\temp), make sure that user also has rights to the registry tree HKEY_LOCAL_MACHINE\Software\ODBC as well as the HKEY_LOCAL_MACHINE\Software\Lotus (search this forum for more info on checking rights in the registry).
Thanks for your answer Ron.I have created a System DSN but the result is the same. I don’t see anything related to NotesSQL in the event viewer.
I have tested to connect to my System DSN with the software Query Tool (using ODBC) but the error is the same. I think it’s a question of rights. My database is not on my computer, i just can see in my computer the database using lotus notes. I have just the rights to see the base but not modify. I have my userid in my machine and it is with this userid, i have configured my System DSN without any problem. That’s why at the beginning i didn’t see any relation with my error and permissions.