Thread: pgaccess on Win95

Hi

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 ?

what should i do/check ?

Patrick

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 ?

Yes, you need to have postgresql available either locally or via a
network.  I don't know if it can access via ODBC, however, as it needs to
know about the ODBC interface and I don't think pgAccess does.  You might
be better off using pgAdmin under Windows (which does use the ODBC
interface) and use pgAccess under whatever Unix-ish environment you use.

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
When I was in school, I cheated on my metaphysics exam: I looked into
the soul of the boy sitting next to me.
        -- Woody Allen

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------

> 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