From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Jeff Stout" <jstout(at)cctus(dot)com>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Testing System DSN's |
Date: | 2004-06-24 07:30:53 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40C36CB@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jeff Stout
> Sent: 23 June 2004 19:49
> To: pgsql-odbc(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David P. Lurie | 2004-06-25 06:02:46 | dropped columns and ms access |
Previous Message | Richard Huxton | 2004-06-24 07:15:10 | Re: Testing System DSN's |