I have configured an ODBC connection to my domino database with ODBC Administrator using NotesSQL. I’m using this ODBC connection in my website which is running on apache. When I’m loading my page, all is correct. But when I’m trying to connect more than 1 client on the same page at the same moment, the NotesSQL driver is crashing ! I have a windows error on the server "NotesSQL Executable : nsqle32.exe - Application error Click OK to terminate."When I look at the list of process in Process Explorer, there are 2 instance of nsqle32.exe which have Apache.exe as parent. I think this is the problem. I have set Connection pooling to Enable for my Notessql driver in the odbc manager. That’s why I don’t understand why there are 2 instance of nsql32.exe which are loaded… What is the problem ?
Subject: NotesSQL and Apache
I don’t know why it’s crashing, but there will be 1 instance of nsqle32.exe per connection. So, that’s not a problem, it’s normal. The reason for this is because Notes does not allow multiple user contexts per session, so each nsqle32.exe loads a different Notes session so that it can support multiple user authentication.
Does your DSN have a server listed or are does that field say local? If you have multiple people connecting to the same database, you will have problems if the database is local, make sure to choose or type in the name of the server in the server field.
Ron
Subject: RE: NotesSQL and Apache
It’s a DSN with a server listed. Many people can access this database in Notes Client. For authentification, in my DSN configuration, I’m using a unique User with his password. Is is that which is my problem ? One user can be authentificated one time at the same moment ? If nsqle32.exe create 1 instance per connection, I will have 1 authentification per connection and of course with my DSN configuration, the authentification uses the same user/pass. How can I do otherwise if it’s not possible ?Thanks Ron.
Subject: RE: NotesSQL and Apache
There will be 1 nsql32e.exe per connection, it shouldn’t matter that it’s the same user name each time, that shouldn’t cause an issue. Can you turn on SQL Tracing in the same place that you set up the DSNs, it will output a .log file. When you have that .log file, let me know.
Thanks,
Ron
Subject: RE: NotesSQL and Apache
Ron,
Here’s a part of my log file :
2a0-684 ENTER SQLFetch
HSTMT 00AA3490
2a0-684 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 00AA3490
2a0-684 ENTER SQLFreeStmt
HSTMT 00AA3490
UWORD 1 <SQL_DROP>
2a0-684 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00AA3490
UWORD 1 <SQL_DROP>
2a0-684 ENTER SQLDisconnect
HDBC 00AA29D0
2a0-67c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 00AA2C90
HWND 00000000
WCHAR * 0x1F7F8B88 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7F8B88
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM005] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed (0)
2a0-67c ENTER SQLErrorW
HENV 00AA4EC0
HDBC 00AA2C90
HSTMT 00000000
WCHAR * 0x04C0F080 (NYI)
SDWORD * 0x04C0F0C8
WCHAR * 0x04C0EC80
SWORD 511
SWORD * 0x04C0F0C6
2a0-67c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00AA4EC0
HDBC 00AA2C90
HSTMT 00000000
WCHAR * 0x04C0F080 (NYI)
SDWORD * 0x04C0F0C8 (0)
WCHAR * 0x04C0EC80 [ 81] "[Microsoft][ODBC Driver Manager] Driver'"
SWORD 511
SWORD * 0x04C0F0C6 (81)
2a0-67c ENTER SQLFreeConnect
HDBC 00AA2C90
2a0-67c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 00AA2C90
2a0-684 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 00AA29D0
2a0-684 ENTER SQLFreeConnect
HDBC 00AA29D0
2a0-684 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 00AA29D0
2a0-684 ENTER SQLFreeEnv
HENV 00AA2890
2a0-684 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 00AA2890
2a0-67c ENTER SQLAllocEnv
HENV * 05225E68
2a0-67c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x05225E68 ( 0x00aa2890)
2a0-67c ENTER SQLAllocConnect
HENV 00AA2890
HDBC * 05225E6C
2a0-67c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00AA2890
HDBC * 0x05225E6C ( 0x00aa2c90)
2a0-67c ENTER SQLDriverConnectW
HDBC 00AA2C90
HWND 00000000
WCHAR * 0x1F7F8B88 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7F8B88
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
2a0-67c EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
HDBC 00AA2C90
HWND 00000000
WCHAR * 0x1F7F8B88 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7F8B88
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
I hope it will be clear for you :S
Subject: Resolution here…
Just wanted to point people reading this thread to the thread that has the resolution in case they are experiencing the same issue…
Ron