Connection problem Delphi 2009 - postgresql-8.4.1-1

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
yesod
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 07.10.2009, 17:10

Connection problem Delphi 2009 - postgresql-8.4.1-1

Post by yesod »

---------------------------
Debugger Exception Notification
---------------------------
Project prjGMCuisine.exe raised exception class EZSQLException with message 'SQL Error: unexpected response from server; first received character was "unexpected response from server; first received character was ""
lost synchronization with server: got message type "3", length 909391104'.
---------------------------
Break Continue Help
---------------------------

I get that exception randomly

and also this one

---------------------------
Debugger Exception Notification
---------------------------
Project prjGMCuisine.exe raised exception class EZSQLException with message 'SQL Error: lost synchronization with server: got message type "e", length 1668575090'.
---------------------------
Break Continue Help
---------------------------

thanks
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

This looks like a communication problem between client libs and server.
Is this database server version stabl enough already?

Mark
Image
yesod
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 07.10.2009, 17:10

Post by yesod »

It seems it's the latest stable version...
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Just checked the pg site. You might be right.

The only idea I have is your program might be using the wrong postgres client libs.

Somebody running Delphi 2009 and postgres 4?

Mark
Image
andresayang
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 13.01.2009, 09:20

Post by andresayang »

I have same problem restoring a db from postgres 8.3 to postgres 8.4.
Th 8.3 was window locale encoding and the 8.4 was UTF8 encoding.

I have to drop all "suspicious characters" to make it work.

Hope this help !
Locked