[Zope] Zope/Interbase/ODBC resolution

Graham Chiu anon_emouse@hotmail.com
Sat, 1 Apr 2000 11:31:36 +1300


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

I previously posted that I was having problems with Zope and Interbase
losing the ODBC connection ( on Win32 ).  This would happen whenever I
entered the web management interface, and at other times when I could
not identify a cause.  I then had to shut Zope down and restart it.
Zope would not allow the ODBC connection to be made otherwise.

I was using the much older Visigenic driver because the Intersolv driver
truncated varchar fields (a known bug).

However, recently I joined the Interbase mailing list, and one of the
Interbase staffers suggested I retry the Intersolv driver and recast the
varchar field as char to work round the truncation

viz. select cast(myvarchar as char(n)) as myvarchar from foo;

I am pleased to report that this works well, and over the last few days
I have not observed a single disconnection.

Furthermore, I have noticed that the very first use of the OBDC
connection after Zope started always gave an error.  This problem has
also now disappeared.

For interest, my experimental server is using a PII 300 overclocked to
450, 128Mb ram, NT4 server, and an IDE hard drive served on an ADSL
connection.  There are about 20,000 items in the ecommerce database.  I
am also using Interbase to do Zope session management.

You can reach the server by using the url below ( a PHP script on my
static server redirects to the ADSL box).

I'll post an update if the situation changes.

In addition, Interbase Corp has expressed an interest in supporting Zope
by helping/writing native drivers for Linux and other platforms which
are supported by the new Open Source Interbase 6.0

- -------
Regards,        Graham Chiu
gchiu<at>compkarori.co.nz
http://www.compkarori.co.nz/x.php?/Shopping

-----BEGIN PGP SIGNATURE-----
Version: PGPsdk version 1.7.1

iQA/AwUBOOSMmbTRdIWzaLpMEQI2agCgwGVCB+/54azaocujM+ewVCq3RLIAoJtw
Lj3Ney3HRWunOqfwKh5ZB1FX
=5xb/
-----END PGP SIGNATURE-----