Yup, that did it. I simply overlooked the client version 6.4 6.3 6.2 ->
order. Quick glance I thought it went 6.2 6.3 6.4 and defaulted to 6.2.
Thanks
-----Original Message-----
From: Israel Zavalza Bahena [mailto:izavalza@hotmail.com]
Sent: Monday, April 12, 1999 6:28 AM
To: theo@primeexalia.com; pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] FW: ODBC connection problems
Change the protocol version to 6.2
>From: "Gary Smith" <theo@primeexalia.com>
>To: <pgsql-interfaces@postgreSQL.org>
>Subject: [INTERFACES] FW: ODBC connection problems
>Date: Sun, 11 Apr 1999 22:18:48 -0700
>
>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
>
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com