Thread: FW: ODBC connection problems

I have PSQL 6.3.2 installed and have set the following items:
    /etc/rc.d/init.d/postgresql
added -I to the startup line

    in the
/var/lib/pgsql
added host all 10.0.0.2 255.255.255.0 trust
I then added the user gary to the db
Logged in as gary and created a db
Created 1 table foo
Tested it and can view it.

and then rebooted and tested again, on the client side, I added the odbc
driver and set it up as a system dsn.  I then used for the username gary, my
std login password and the ip address.  It seems to work fine.  When I load
up access 97 I link to the odbc for psql and then click ok for the default
and it does nothing.  When I specify a database it gives me the error
unsupported frontend protocol (#210).


Any ideas,

Gary Smith

"Gary Smith" <theo@primeexalia.com> writes:
> I have PSQL 6.3.2 installed and have set the following items:
> [snip]
> When I specify a database it gives me the error
> unsupported frontend protocol (#210).

You're probably trying to run a 6.4 client.  Won't work with a 6.3
server; you need to update the server.  (A 6.4 server will still
speak to 6.3 clients, but not vice versa.)

            regards, tom lane