-----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-----