pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedFW: ODBC connection problems
5+ messages / 3 participants
[nested] [flat]
* FW: ODBC connection problems
@ 1999-04-12 05:18 Gary Smith <theo@primeexalia.com>
0 siblings, 1 reply; 5+ messages in thread
From: Gary Smith @ 1999-04-12 05:18 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] FW: ODBC connection problems
@ 1999-04-12 06:28 Israel Zavalza Bahena <izavalza@hotmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Israel Zavalza Bahena @ 1999-04-12 06:28 UTC (permalink / raw)
To: theo@primeexalia.com; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] FW: ODBC connection problems
@ 1999-04-12 09:19 Israel Zavalza Bahena <izavalza@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Israel Zavalza Bahena @ 1999-04-12 09:19 UTC (permalink / raw)
To: theo@primeexalia.com; pgsql-interfaces
You are welcome ! :)
>From: "Gary Smith" <theo@primeexalia.com>
>To: <pgsql-interfaces@postgreSQL.org>
>Subject: RE: [INTERFACES] FW: ODBC connection problems
>Date: Mon, 12 Apr 1999 08:07:59 -0700
>
>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
>
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] FW: ODBC connection problems
@ 1999-04-12 14:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Gary Smith <theo@primeexalia.com>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 1999-04-12 14:42 UTC (permalink / raw)
To: Gary Smith <theo@primeexalia.com>; +Cc: pgsql-interfaces
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] FW: ODBC connection problems
@ 1999-04-12 15:07 Gary Smith <theo@primeexalia.com>
parent: Israel Zavalza Bahena <izavalza@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Gary Smith @ 1999-04-12 15:07 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-04-12 15:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-12 05:18 FW: ODBC connection problems Gary Smith <theo@primeexalia.com>
1999-04-12 14:42 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-04-12 06:28 Re: [INTERFACES] FW: ODBC connection problems Israel Zavalza Bahena <izavalza@hotmail.com>
1999-04-12 15:07 ` Gary Smith <theo@primeexalia.com>
1999-04-12 09:19 RE: [INTERFACES] FW: ODBC connection problems Israel Zavalza Bahena <izavalza@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox