Message-Id: <m10MNGN-000LJgC@wallace.ece.rice.edu>
From: reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom)
Subject: Re: [INTERFACES] pgaccess on Win95
In-Reply-To: <Pine.LNX.4.04.9903141716020.4823-100000@dragosani.lan2wan.com>
	from "Brett W. McCoy" at "Mar 14, 99 05:18:58 pm"
To: pgsql-interfaces@postgreSQL.org
Date: Sun, 14 Mar 1999 20:37:55 -0600 (CST)
Cc: pat@patoche.org
Reply-To: reedstrm@rice.edu
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> On Sun, 14 Mar 1999 pat@patoche.org wrote:
> 
> > i've just download pgaccess 0.96
> > it seems to be able to run on Windows and i'm very interested to use it that
> > way.
> > 
> > So i've installed Tcl/tk on Win95 I launch pgaccess, everything seems ok
> > but as soon as i connect to a database i have (translated from french) :
> > error postgresql : the fore-ground engine use an invalid protocol.
> > 
> > i've not installed dcom or odbc on the computer. should i ?

No, pgaccess uses the native postgres protocol on the wire, via the libpgtcl.dll
and libpq.dll libraries included in the distibution. I have colleagues working
with me using pgaccess from win32 on the same database where I use it from unix.
This allows us to share stored queries and such.

However, it sounds like you are getting a protocol mismatch - what version is
your postgresql backend? I think the current pgaccess version will only connect
properly to either v6.3 or v6.4. Also, make sure the postmaster has been started
with permissions to allow connection via network sockets, and that your IP number
has permission to connect (set up in the pg_hba.conf file)

HTH,
Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005