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