From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Jeff Stout <jstout(at)cctus(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Testing System DSN's |
Date: | 2004-06-24 07:15:10 |
Message-ID: | 40DA7F7E.1000704@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Jeff Stout wrote:
> I have setup the postgresql-odbc driver everything looks good
>
> Is there a way to "test" the odbc connection. I have set
> up system dsn's in the past using MySQL-odbc and there was a
> "test data resource" button to ensure all the data I entered
> was correct. Is there a way to do this in postgres?
Hmm - other than connecting, I can't think of one.
> One more question, I noticed that the port # 5432 was used
> this is the same port that pgadmin uses. Do I have to
> allow a certain post on the DB to change this to something
> else?
There is a setting in the postgresql.conf file that lets you change the
port the server listens on. Of course the tcp-ip option needs to be
turned on for PG to listen at all.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-06-24 07:30:53 | Re: Testing System DSN's |
Previous Message | Jeff Stout | 2004-06-23 18:49:13 | Testing System DSN's |