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