Re: Testing System DSN's

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