Launching NotesSQL as a system service

HCL Domino Domino Forum
1

My server is running under Windows 2000 Pro. I have configured an ODBC connection with NotesSQL as a system DSN. My ODBC connection is used by my Php server (apache). But when I’m not logged on my server, Apache can’t access my ODBC connection. Is it possible to run my system DSN as a system service when Windows starts and not when I’m logging ?

2

Subject: Launching NotesSQL as a system service

Well, I think it’s a problem of rights on system directories or the NotesSQL directory. Apache seems not to have access to these directories when I’m not logged. What are the rights on what directories I must define ? WinNT ? WinNT\Temp ? NotesSQL ?Thanks.

3

Subject: RE: Launching NotesSQL as a system service

Look at the documentation in the Tips for using third-party applications topic. Specifically, look in the IIS section…http://www-12.lotus.com/ldd/doc/notessql/3.0.2f/notessql.nsf/66208c256b4136a2852563c000646f8c/7005c9ff90581a4385256dd7004d81f5?OpenDocument

4

Subject: RE: Launching NotesSQL as a system service

Thanks Ron.I have tried to set full control to all categories of all local users for Notes,NotesSQL,WinNT\Temp directories but the problem is the same…

[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed, SQL state IM005 in SQLConnect

It’s not an IIS server but an APACHE server…

5

Subject: RE: Launching NotesSQL as a system service

I understand it’s apache, but the same rules that IIS have apply to apache as well. Look in the NT Event viewer and see what errors NotesSQL is giving in the Application section.

Ron

6

Subject: RE: Launching NotesSQL as a system service

Well, you’re my god Ron !!!In the event viewer, it was written that NotesSQL could not located the user.id in notes.ini ! And why ? because the user.id was on a remote drive which is accessible only when I’m connected !!! Sorry it was so silly !

I’ve changed the path in the notes.ini and now it works perfect and also very faster !

Thanks Ron.

7

Subject: RE: Launching NotesSQL as a system service

Glad to be of service and even more glad it works and is faster =)

Ron