|
durumdara
durumdara at gmail.com
Tue Jan 23 09:44:43 EST 2007
Hi!
My problem is that:
I need to use DBISAM databases.
There is no native Python driver for DBISAM, but DBISAM have ODBC driver.
I build two sites with DBISAM local database, and with ODBC drived by
pywin32 odbc module.
Everything is worked good (it seems to be) if I drop my cursors on every
request.
But now I needed to change ODBC to remote mode (to read remote database).
Yesterday I simple changed the settings of the driver, and next I found
me in the hell... :-(((
In every 2.-3. request the httpd.exe is crashed. No error msg. generated
(logs), only Windows create some dumps about it.
In the event log I see that ntdll.dll and sometimes the odbc.pyd is the
source of the error.
Interesting thing, that my sites are working good with odbc.pyd and
DBISAM when they are not used remote databases.
I tried everything: I set MaxReqPChild to 1 (to cleanup), close
cursors/databases on finishing of scripts, etc.
When I try to do same thing with normal python interpreter, I cannot do
it. I can open many-many connections, and they are cleaned up normally...
Next I downloaded mxODBC, and tried it. It is working good, but it's
prices are not good for me.
Today I download the pyodbc package, but it is possible not thread-safe.
Or possible it is not working good later, I don't know.
I have not experienced with this.
BUT IF WILL NOT WORKING, I WILL NEED SOME CHANGING.
So:
I need some information to prepare to change if needed.
There is two way to working with dbisam + odbc under apache.
First: I need to write a database server (socketserver) that communicate
beetween my apache processes and ODBC database. It is payful.
Second: I need to change to cgi mode to avoid these problems.
Please help me: what you offer me when I want to use cgi? The modpy
library can supports this working mode? Or what I need to do for it?
Please offer me some library, and example to prepare if the problems
appearing!
Thanks for your help:
dd
|