Обсуждение: Testing System DSN's

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?

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?

Thank you in advance for your help.

Jeff
CCT

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

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jeff Stout
> Sent: 23 June 2004 19:49
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Testing System DSN's
>
> 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?

pgAdmin II (which is old now) has an ODBC test plugin. The ODBC driver
itself cannot do it though.

> 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?

Why? everything connects *to* PostgreSQL on 5432 by default (which will
work just fine), and pgAdmin and psqlODBC will pick a unused port to use
at their end.

Regards, Dave