Received: from nt4s0401.vampirerealm.net ([206.217.245.16]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA39044 for ; Mon, 12 Apr 1999 11:05:34 -0400 (EDT) (envelope-from theo@primeexalia.com) Received: from gary (val-ca7-41.ix.netcom.com [207.223.166.105]) by nt4s0401.vampirerealm.net with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.1960.3) id H0LTJ7H7; Mon, 12 Apr 1999 08:05:47 -0700 From: "Gary Smith" To: Subject: RE: [INTERFACES] FW: ODBC connection problems Date: Mon, 12 Apr 1999 08:07:59 -0700 Message-ID: <000d01be84f6$40e31e00$0200000a@gary.primeexalia.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal In-Reply-To: <19990412132817.87487.qmail@hotmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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" >To: >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