pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpgaccess on Win95
3+ messages / 3 participants
[nested] [flat]
* pgaccess on Win95
@ 1999-03-14 21:40 pat@patoche.org
0 siblings, 1 reply; 3+ messages in thread
From: pat@patoche.org @ 1999-03-14 21:40 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] pgaccess on Win95
@ 1999-03-14 22:18 Brett W. McCoy <bmccoy@lan2wan.com>
parent: pat@patoche.org
0 siblings, 1 reply; 3+ messages in thread
From: Brett W. McCoy @ 1999-03-14 22:18 UTC (permalink / raw)
To: pat@patoche.org; +Cc: pgsql-interfaces
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------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] pgaccess on Win95
@ 1999-03-15 02:37 Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
parent: Brett W. McCoy <bmccoy@lan2wan.com>
0 siblings, 0 replies; 3+ messages in thread
From: reedstrm@wallace.ece.rice.edu @ 1999-03-15 02:37 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: pat@patoche.org
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-03-15 02:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-14 21:40 pgaccess on Win95 pat@patoche.org
1999-03-14 22:18 ` Brett W. McCoy <bmccoy@lan2wan.com>
1999-03-15 02:37 ` Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
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