Re: Testing System DSN's

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