ODBC on Windows
PostgreSQL ODBC Driver on Windows XP
1. Download, extract, and run the MSI installer on the ListManager machine. At the time of this writing, this download was available at http://gborg.postgresql.org/project/psqlodbc/genpage.php?downloads.
2. To configure the driver, navigate to to Start->Settings->Control Panel->Administrative Tools, and then click on Data Sources (ODBC).
3. Under System DSN
1. Select Add
2. Find the PostgreSQL driver (should be near the bottom).
3. Fill in the required information (server, database, username, password, description, datasource name)
4. Make sure that you have the proper settings in the pg_hba.conf file to allow the ODBC machine to connect to the PostgreSQL database server host. Example:
host all all 56.232.32.171 255.255.255.255 password
5. To test the connection, create a Link Table in Microsoft Access:
1. Start Access.
2. Select "Blank Access Database".
3. Enter a filename for the database to use (e.g., db2.mdb).
4. Under Objects in the left hand panel, make sure the Tables button is selected.
5. Right click in the blank area under the "Create table by entering data" link, and select "Link Tables".
6. Go to the "Files of type" dropdown and select "ODBC Databases()".
7. In the "Select Data Source" window, click on the "Machine Data Source" tab, highlight your postgreSQL data source, and click "OK".
8. The tables in your PostgreSQL database should be available to you. Select the table you are interested in, and the primary key(s) for the table when prompted.
9. You should be able to double click on the new link (with the Earth icon) and see the contents of the table, or you can create a query in the Query section using the Query Wizard.
More
1. ODBC
1. ODBC on Unix
2. ODBC on Windows
3. Sample ODBC Connection Strings and Queries
|
|