Thread: Re: [INTERFACES] FW: ODBC connection problems

Re: [INTERFACES] FW: ODBC connection problems

From
"Israel Zavalza Bahena"
Date:
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

RE: [INTERFACES] FW: ODBC connection problems

From
"Gary Smith"
Date:
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