pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [ADMIN] pgsql-interfaces ODBC???
5+ messages / 2 participants
[nested] [flat]
* Re: [ADMIN] pgsql-interfaces ODBC???
@ 1998-05-26 14:45 David Hartwig <daveh@insightdist.com>
2 siblings, 0 replies; 5+ messages in thread
From: David Hartwig @ 1998-05-26 14:45 UTC (permalink / raw)
To: duncanlo@m2.dj.net.tw; +Cc: pgsql-interfaces
Please send ODBC driver version. This can be retrieved from the "ODBC
Data Source Administrator" in the "ODBC Drivers" tab.
ªü$¡·
> I had install PostgreSQL 6.3.1 in Slackware Linux(kernel 2.0.33)
> Now I install PostgreSQL ODBC Driver in another PC.
> When I import/export data with ODBC Driver.
> It said "ODBC Error!" then print some message...
>
> Could not connect to the server.
> Could not connect to remote socket (#1)
>
> Where is my error? Thank you!
> --
> ·R ¬OµL«èµL®¬ªº¥I¥X
> ¦Ó¤£¬O¤£¾Ü¤â¬qªº¦û¦³
> ¥u¦³¯u¤ß¥I¥Xªº·R¤~¬OµL»ùªº
>
> ¦Ó§Ú ¤£½×¤Ñªø¦a¤[ ¤£½×¤Ñ²P®ü¨¤ °l´MµÛ¯u·R..
Attachments:
vcard.vcf (text/x-vcard, 201B) download
begin: vcard
fn: David Hartwig
n: Hartwig;David
email;internet: daveh@insightdist.com
x-mozilla-cpt: ;2
x-mozilla-html: TRUE
version: 2.1
end: vcard
* Re: [INTERFACES] pgsql-interfaces ODBC???
@ 1998-05-26 15:38 Hannu Krosing <hannu@trust.ee>
2 siblings, 0 replies; 5+ messages in thread
From: Hannu Krosing @ 1998-05-26 15:38 UTC (permalink / raw)
To: duncanlo@m2.dj.net.tw; +Cc: pgsql-interfaces; pgsql-admin@postgreSQL.org
ªü³¡·É / Duncan Lo wrote:
>
> I had install PostgreSQL 6.3.1 in Slackware Linux(kernel 2.0.33)
> Now I install PostgreSQL ODBC Driver in another PC.
> When I import/export data with ODBC Driver.
> It said "ODBC Error!" then print some message...
>
> Could not connect to the server.
> Could not connect to remote socket (#1)
>
> Where is my error? Thank you!
First things to check:
Did you start postmaster with the -i option to enable tcp connections ?
Is your pg_hba file set up correctly ?
Hannu
Attachments:
smime.p7s (application/x-pkcs7-signature, 2.0K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [ADMIN] pgsql-interfaces ODBC???
@ 1998-05-26 15:46 David Hartwig <daveh@insightdist.com>
2 siblings, 2 replies; 5+ messages in thread
From: David Hartwig @ 1998-05-26 15:46 UTC (permalink / raw)
To: duncanlo@m2.dj.net.tw; +Cc: pgsql-interfaces; pgsql-admin@postgreSQL.org
ODBC Connection Checklist
* ODBC Driver Data Source Checks
1. Valid and resolvable hostname
2. Valid port number. (default is 5432)
3. Valid and existing database name.
4. Valid user name.
5. Valid password for the specified user. (Required iff
pg_hba.config is set to password authenticate your client.)
* PostgreSQL Server Checks
1. Postmaster must be running.
2. Postmaster must run with the -i option to allow remote
connections.
3. The pg_hba.conf file in $PGPATH/data directory must be
configured to allow your remote host to connect.
ªü$¡·
> I had install PostgreSQL 6.3.1 in Slackware Linux(kernel 2.0.33)
> Now I install PostgreSQL ODBC Driver in another PC.
> When I import/export data with ODBC Driver.
> It said "ODBC Error!" then print some message...
>
> Could not connect to the server.
> Could not connect to remote socket (#1)
>
> Where is my error? Thank you!
> --
> ·R ¬OµL«èµL®¬ªº¥I¥X
> ¦Ó¤£¬O¤£¾Ü¤â¬qªº¦û¦³
> ¥u¦³¯u¤ß¥I¥Xªº·R¤~¬OµL»ùªº
>
> ¦Ó§Ú ¤£½×¤Ñªø¦a¤[ ¤£½×¤Ñ²P®ü¨¤ °l´MµÛ¯u·R..
Attachments:
vcard.vcf (text/x-vcard, 201B) download
begin: vcard
fn: David Hartwig
n: Hartwig;David
email;internet: daveh@insightdist.com
x-mozilla-cpt: ;2
x-mozilla-html: TRUE
version: 2.1
end: vcard
* Re: [ADMIN] pgsql-interfaces ODBC???
@ 1998-05-28 14:27 David Hartwig <daveh@insightdist.com>
parent: David Hartwig <daveh@insightdist.com>
1 sibling, 0 replies; 5+ messages in thread
From: David Hartwig @ 1998-05-28 14:27 UTC (permalink / raw)
To: pgsql-interfaces
Is the user name valid. If so, are you set up properly in pg_hba.conf file in
$PGPATH/data directory on the server. If so, did you specify password
authentication for your remote machine? If so, you MUST supply a correct
password. I don't think unpassworded accounts will work.
In the future, please post your questions to the list.
Thanks for checking us out.
ªü$¡·
> Thank you!
> I add -i option, then is ok. But now I have "User authentiction failed (#10)".
>
> Is this problem about pg_hba.conf?
>
> > 5. Valid password for the specified user. (Required iff
> > pg_hba.config is set to password authenticate your client.)
> > * PostgreSQL Server Checks
> > 2. Postmaster must run with the -i option to allow remote
> > connections.
> > 3. The pg_hba.conf file in $PGPATH/data directory must be
> > configured to allow your remote host to connect.
> > > I had install PostgreSQL 6.3.1 in Slackware Linux(kernel 2.0.33)
> > > Now I install PostgreSQL ODBC Driver in another PC.
> > > When I import/export data with ODBC Driver.
> > > It said "ODBC Error!" then print some message...
> > > Could not connect to the server.
> > > Could not connect to remote socket (#1)
> > > Where is my error? Thank you!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [ADMIN] pgsql-interfaces ODBC???
@ 1998-05-28 14:36 David Hartwig <daveh@insightdist.com>
parent: David Hartwig <daveh@insightdist.com>
1 sibling, 0 replies; 5+ messages in thread
From: David Hartwig @ 1998-05-28 14:36 UTC (permalink / raw)
To: pgsql-interfaces
I know there are lots of interfaces being worked on for PostgreSQL. I am not
familiar with mysql tools. So I don't know how to answer your question. But,
just guessing, MS Excel along with MS Query are fairly simple tools to access
PostgreSQL data.
ªü$¡·
> Is it right about my rc.local in Slackware Linux (kernle 2.0.33) to start
> postgresql?
>
> # PostgreSQL Server
> echo "Starting PostgreSQL Server..."
> su postgres -c "/usr/local/pgsql/bin/postmaster -i -S -D/usr/local/pgsql/data"
>
> And is postgres have some utilities (query tools like ms sql) in win32?
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1998-05-28 14:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-26 14:45 ` David Hartwig <daveh@insightdist.com>
1998-05-26 15:38 ` Hannu Krosing <hannu@trust.ee>
1998-05-26 15:46 ` David Hartwig <daveh@insightdist.com>
1998-05-28 14:27 ` David Hartwig <daveh@insightdist.com>
1998-05-28 14:36 ` David Hartwig <daveh@insightdist.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