pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRemote access ODBC/MS-Access
4+ messages / 3 participants
[nested] [flat]
* Remote access ODBC/MS-Access
@ 1998-08-21 06:58 Roeland M.J. Meyer <rmeyer@mhsc.com>
0 siblings, 2 replies; 4+ messages in thread
From: Roeland M.J. Meyer @ 1998-08-21 06:58 UTC (permalink / raw)
To: LIST - PGSQL Interface <pgsql-interfaces@hub.org>
This is probably a newbie question, or one that's already been seen before.
However, I'm new to PostgreSQL. I've been researching the dox since
Wednesday, to no avail. I have already called MS and they were as helpful
as they could be. Decent help on MS-Access and they have me on ODBC Manager
v3.5. I am reasonably confident that the System DSN is correctly done.
Client-side:
WinNT40SP3
Version of MS-Access is from MS-Office97 SR1
ODBC Manager v3.5.
Server-side:
I have the following installed on a heavily modified Caldera OpenLinux
(standard) box. Kernel is at v2.0.33.
Postgres version is "postgresql-6.3.2"
PostODBC version is "PsqlODBC-6.30.0249.exe"
LAN is 100baseTX (switched) on /28
PROBLEM:
I can not seem to access the data server. I did a parallel install, on a
similar server on the same sub-net. I set PGHOST and PGPORT as advertised
and I get the following error;
>postgres@condor:/rdbms$> psql customerdb
>Connection to database 'customerdb' failed.
>connectDB() failed: Is the postmaster running at 'raven.mhsc.com' on port
'5432'?
Note: customerdb exists with only one table, the "bar" from the Admin Manual.
I get similar dialog boxen from the NT machines.
My "pg_hba.conf" looks like this (unitl I get this working):
>host all 199.108.175.0 255.255.255.0 trust
>local all trust
>host all 127.0.0.1 255.255.255.255 trust
Please respond via regular e-mail, as well as to the list.
PS. This is definitely NOT Oracle <grin>
_________________________________________________
Morgan Hill Software Company, Inc.
Colorado Springs, CO - Livermore, CA - Morgan Hill,
CA
Domain Administrator
MHSC2-DOM and MHSC3-DOM
Administrative and Technical contact
____________________________________________
InterNIC Id: MHSC hostmaster (HM239-ORG)
e-mail: <mailto:hostmaster@mhsc.com>mailto:hostmaster@mhsc.com
web -pages: <http://www.mhsc.com/>http://www.mhsc.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Remote access ODBC/MS-Access
@ 1998-08-21 12:57 David Hartwig <daveh@insightdist.com>
parent: Roeland M.J. Meyer <rmeyer@mhsc.com>
1 sibling, 0 replies; 4+ messages in thread
From: David Hartwig @ 1998-08-21 12:57 UTC (permalink / raw)
To: Roeland M.J. Meyer <rmeyer@mhsc.com>; +Cc: LIST - PGSQL Interface <pgsql-interfaces@hub.org>
There is a checklist on http://www.insightdist.com/psqlodbc/psqlodbc_faq.html.
Off the top of my head: Did you start postmaster with the -i option?
Roeland M.J. Meyer wrote:
> This is probably a newbie question, or one that's already been seen before.
> However, I'm new to PostgreSQL. I've been researching the dox since
> Wednesday, to no avail. I have already called MS and they were as helpful
> as they could be. Decent help on MS-Access and they have me on ODBC Manager
> v3.5. I am reasonably confident that the System DSN is correctly done.
>
> Client-side:
> WinNT40SP3
> Version of MS-Access is from MS-Office97 SR1
> ODBC Manager v3.5.
>
> Server-side:
> I have the following installed on a heavily modified Caldera OpenLinux
> (standard) box. Kernel is at v2.0.33.
>
> Postgres version is "postgresql-6.3.2"
> PostODBC version is "PsqlODBC-6.30.0249.exe"
>
> LAN is 100baseTX (switched) on /28
>
> PROBLEM:
>
> I can not seem to access the data server. I did a parallel install, on a
> similar server on the same sub-net. I set PGHOST and PGPORT as advertised
> and I get the following error;
>
> >postgres@condor:/rdbms$> psql customerdb
> >Connection to database 'customerdb' failed.
> >connectDB() failed: Is the postmaster running at 'raven.mhsc.com' on port
> '5432'?
>
> Note: customerdb exists with only one table, the "bar" from the Admin Manual.
>
> I get similar dialog boxen from the NT machines.
>
> My "pg_hba.conf" looks like this (unitl I get this working):
>
> >host all 199.108.175.0 255.255.255.0 trust
> >local all trust
> >host all 127.0.0.1 255.255.255.255 trust
>
> Please respond via regular e-mail, as well as to the list.
>
> PS. This is definitely NOT Oracle <grin>
>
> _________________________________________________
> Morgan Hill Software Company, Inc.
> Colorado Springs, CO - Livermore, CA - Morgan Hill,
> CA
> Domain Administrator
> MHSC2-DOM and MHSC3-DOM
> Administrative and Technical contact
> ____________________________________________
> InterNIC Id: MHSC hostmaster (HM239-ORG)
> e-mail: <mailto:hostmaster@mhsc.com>mailto:hostmaster@mhsc.com
> web -pages: <http://www.mhsc.com/>http://www.mhsc.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Remote access ODBC/MS-Access
@ 1998-08-21 13:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Roeland M.J. Meyer <rmeyer@mhsc.com>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 1998-08-21 13:59 UTC (permalink / raw)
To: Roeland M.J. Meyer <rmeyer@mhsc.com>; +Cc: pgsql-interfaces@hub.org
"Roeland M.J. Meyer" <rmeyer@mhsc.com> writes:
>> postgres@condor:/rdbms$> psql customerdb
>> Connection to database 'customerdb' failed.
>> connectDB() failed: Is the postmaster running at 'raven.mhsc.com' on port
> '5432'?
If you look at the code in src/interfaces/libpq/fe-connect.c, you'll
find this message is generated if the connect() system call fails,
which means you don't have connectivity to the postmaster.
You need not worry about whether the database exists or whether
hba.conf allows you to connect, because none of those conditions
can be checked until the postmaster receives the startup request
packet from the client --- and your client is not even getting
as far as sending that packet.
A quick-and-dirty point is did you start the postmaster with -i
on its command line? If not it won't be listening for TCP
connections, only unix-socket connections.
Otherwise it seems like you must have an addressing or physical
connectivity problem of some kind...
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Remote access ODBC/MS-Access
@ 1998-08-21 15:13 Roeland M.J. Meyer <rmeyer@mhsc.com>
0 siblings, 0 replies; 4+ messages in thread
From: Roeland M.J. Meyer @ 1998-08-21 15:13 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; David Hartwig <daveh@insightdist.com>; +Cc: pgsql-interfaces@hub.org
At 09:59 AM 8/21/98 -0400, Tom Lane wrote:
>"Roeland M.J. Meyer" <rmeyer@mhsc.com> writes:
>>> postgres@condor:/rdbms$> psql customerdb
>>> Connection to database 'customerdb' failed.
>>> connectDB() failed: Is the postmaster running at 'raven.mhsc.com' on port
>> '5432'?
>
>If you look at the code in src/interfaces/libpq/fe-connect.c, you'll
>find this message is generated if the connect() system call fails,
>which means you don't have connectivity to the postmaster.
>
>You need not worry about whether the database exists or whether
>hba.conf allows you to connect, because none of those conditions
>can be checked until the postmaster receives the startup request
>packet from the client --- and your client is not even getting
>as far as sending that packet.
>
>A quick-and-dirty point is did you start the postmaster with -i
>on its command line? If not it won't be listening for TCP
>connections, only unix-socket connections.
Nope. BTW, the man-pages do not mention a -i switch. Are there any parameters?
>Otherwise it seems like you must have an addressing or physical
>connectivity problem of some kind...
Samba works, as well as, BIND, SSH, Apache-SSL, rlogin, etc... raven has
been on-line since Dec97.
___________________________________________________
Roeland M.J. Meyer, ISOC (InterNIC RM993)
e-mail: <mailto:rmeyer@mhsc.com>rmeyer@mhsc.com
Internet phone: hawk.mhsc.com
Personal web pages: <http://www.mhsc.com/~rmeyer>www.mhsc.com/~rmeyer
Company web-site: <http://www.mhsc.com/>www.mhsc.com/
___________________________________________
SecureMail from MHSC.NET is coming soon!
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1998-08-21 15:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-21 06:58 Remote access ODBC/MS-Access Roeland M.J. Meyer <rmeyer@mhsc.com>
1998-08-21 12:57 ` David Hartwig <daveh@insightdist.com>
1998-08-21 13:59 ` Tom Lane <tgl@sss.pgh.pa.us>
1998-08-21 15:13 Re: [INTERFACES] Remote access ODBC/MS-Access Roeland M.J. Meyer <rmeyer@mhsc.com>
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