PostgreSQL ODBC configuration


The purpose of this web page it to help you setup and ODBC data source on Windows 95/NT/2000 for PostgreSQL. This web site reflects that work for me and may not necessarily be best for you.


Open the Control Panel (in Settings)

Open "ODBC Data Sources (32 Bit)". Window2000 should look in "Administrative Tools" followed by "Data Sources (ODBC)

Click on the System DNS tab

You should see the following window:

 

Click on the "Add" button

 

 

Look for and double click on PostgreSQL and double click on it

 

 

Set "Database" = your_PostgreSQL_database

Set "Server" = your_PostgreSQL_server

Set "Description" = "your description"

Click on the "Driver" button

 

 

Click "Read Only" off. "CommLog" is optional and will create useful log files in your c:\ drive for debugging

Click on "OK"

 

 

Click on the "Data Source" button

 

Click Read Only off

Click "OK"

Click "OK"

Click "OK"