Received: from nt4s0401.vampirerealm.net ([206.217.245.16])
	by hub.org (8.9.2/8.9.1) with ESMTP id BAA60571
	for <pgsql-interfaces@postgresql.org>;
	Mon, 12 Apr 1999 01:16:10 -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 H0LTJ7HT; Sun, 11 Apr 1999 22:16:37 -0700
From: "Gary Smith" <theo@primeexalia.com>
To: <pgsql-interfaces@postgresql.org>
Subject: FW: ODBC connection problems
Date: Sun, 11 Apr 1999 22:18:48 -0700
Message-ID: <000a01be84a3$f26b3340$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
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

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