Page 1 of 1

Error connecting to postgres 8.1

Posted: 04.07.2007, 11:45
by rnaujack
I'm trying to connect to a postgresql 8.1 without any ssl active. pgadmin works fine, but zeos can't connect.

With mysql the program works fine, but've like to test postgres instead.

thanks for help
Rudolf

Posted: 04.07.2007, 11:46
by rnaujack
rnaujack wrote:I'm trying to connect to a postgresql 8.1 without any ssl active. pgadmin works fine, but zeos can't connect.

With mysql the program works fine, but've like to test postgres instead.

thanks for help
Rudolf
i've forgotten the error-message:

SQL Error: received invalid response to SSL negotiation: 4.

Posted: 05.07.2007, 08:59
by btrewern
You'll need the following dlls in your path:

comerr32.dll
iconv.dll
krb5_32.dll
libeay32.dll
libiconv-2.dll
libintl-2.dll
libpq.dll
ssleay32.dll

You can find these in your pgAdmin III program folder.

Regards,

Ben

Posted: 05.07.2007, 10:35
by rnaujack
i've got all these dlls in my path; without them the program complains about missing dlls.
If i us protocol postgres or postgres-8, i get:
SQL Error: received invalid response to SSL negotiation: 4.

If i use protocol postgres-7, i get:
SQL Error: expected authentication request from server, but received 4.

Using perl with DBI::Pg / DBI::PgPP against this server, all works fine.

Against an postgres 8.2 server on windows:
instead of '4' there a '>' in the error-message