Dear Sir,
I intend to use PostgreSQL and DataSnap (Delphi) for my newest project, so I start to develop some testing applications to evaluate the PostgreSQL and DataSnap. While I test the PostgreSQL with DataSnap, I find a funny phenomenon as follows: Initially the application seems function normally, however as I keep trying to query or update the database (issue serveral SQL query commands consecutively), 'catastrophic failure' is reported by Delphi and the testing application crashed. Because of the error, I transfer the same database to Microsoft SQL Server and MySQL, the miserably 'catastrophic failure' is eliminated. Therefore, It should be something wrong on the PostgreSQL ODBC driver. Since I am not an expert for ODBC driver, so I write you this mail to see any help or suggestion you could provided.
Configuration details of the database server
--------------------------------------------------------------
O/S: Rad Hat Linux 7.3 (Kernel 2.4.18-5)
PostgreSQL: Version 7.2.1
Front-end details
------------------------
O/S: Windows 2000 Advanced Server (SP3)
ODBC of PostgreSQL: Version 07.02.0001
Accessing: An application server (middle tier) access the database use ODBC Provider of ADO
Client: Connect the application server via TCP socket
Development tool: Delphi 6 Enterprise Edition
Any further information inquery is welcome.
Thanks you very much in advance.
Athens Yan
MedicalSys Co.