Pervasive with PHP

[SPIT53]

Hi everybody,

I'm new in this forum and quite novice with Pervasive SQL. I'm french, so sorry for grammar ;-)
My configuration is : Pervasive SQL 2000i SP3 on a netware 5.1 server, Apache server/PHP on NT4 server (SP3).

I have a problem with PHP : my script open an ODBC connection, execute queries and close the connection. If a user stop the process in his browser (by hitting the cancel button), the connection is not closed and if I unload the NWODBCEI.NLM module on my netware server, I can't reload my PHP script, the connection cannot be opened (but no error message on the server).

Any ideas?

 

[Vancouverite]

"If a user stop the process in his browser (by hitting the cancel button), the connection is not closed"

This is common to most internet DB accesses. Eventually, the ODBC connection will time out on the server, freeing the connection.

You can speed this up by changing the IP timeout on the server (this is a communications protocol setting, not a Pervasive setting). By default, the IP timeout on MS Windows is a couple hours. Decreasing the IP timeout settings on the server will cause the P.SQL communications manager to detect a client time out sooner.

"if I unload the NWODBCEI.NLM module on my netware server, I can't reload my PHP script, the connection cannot be opened (but no error message on the server)."

NWODBCEI.NLM is the ODBC interface to Pervasive. If you unload it, no ODBC connections will connect.

I recommend cutting down on the O/S's IP timeout.

 

[SPIT53]

Vancouverite,

When I start my NW5.1 server, the NWODBCEI.NLM is not loaded. When a page with a php script that call the database is open, the netware server loads the module NWODBCEI.NLM and when the same page is finished to load, the nw server immediatly unloads the NWODBCEI.NLM.
But if a user hit the cancel button before the end of the php script, the nw server don't unload the NWODBCEI.NLM. And if we unload it manually on the server, we can't access another php page without rebooting the nw51 server.

Is it normal? If it is, I must stop developping php applications :-(