Thread: Changing Port number in a File DSN
I am unable to change the port number from 5432 to the correct port number for my PostgreSQL database when I create a File DSN. I am need to migrate data from Microsoft Access to PostgresQL and a File DSN connecting to my PostgreSQL database is required. Any help is greatly appreciated.
Thanks,
Sandra Arnold
Sr. Database Admintrator
DOE/OSTI
Oak Ridge, TN
The version that I am using is the latest version that is there to download, 8.03.04.
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Arnold, Sandra
Sent: Tuesday, March 24, 2009 11:41 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Changing Port number in a File DSN
I am unable to change the port number from 5432 to the correct port number for my PostgreSQL database when I create a File DSN. I am need to migrate data from Microsoft Access to PostgresQL and a File DSN connecting to my PostgreSQL database is required. Any help is greatly appreciated.
Thanks,
Sandra Arnold
Sr. Database Admintrator
DOE/OSTI
Oak Ridge, TN
Arnold, Sandra wrote: > I am unable to change the port number from 5432 to the correct port > number for my PostgreSQL database when I create a File DSN. I am need > to migrate data from Microsoft Access to PostgresQL and a File DSN > connecting to my PostgreSQL database is required. Any help is greatly > appreciated. Either re-create the file DSN, or open the DSN file in a text editor and manually alter the port number. I seem to remember that the latter worked for me. -- Craig Ringer
I found a paper on "Using MS Access with PostgreSQL". It did mention that there was a bug that would not allow you to change the port number when creating a file DSN that you had to edit the file. Figured out how to do that and I am now able to connect. Thanks, Sandra -----Original Message----- From: Craig Ringer [mailto:craig@postnewspapers.com.au] Sent: Tuesday, March 24, 2009 10:43 PM To: Arnold, Sandra Cc: pgsql-odbc@postgresql.org Subject: Re: [ODBC] Changing Port number in a File DSN Arnold, Sandra wrote: > I am unable to change the port number from 5432 to the correct port > number for my PostgreSQL database when I create a File DSN. I am need > to migrate data from Microsoft Access to PostgresQL and a File DSN > connecting to my PostgreSQL database is required. Any help is greatly > appreciated. Either re-create the file DSN, or open the DSN file in a text editor and manually alter the port number. I seem to remember that the latter worked for me. -- Craig Ringer