Install PostgreSQL ODBC Driver
- Download the latest PostgreSQL 32-bit ODBC Driver by choosing a mirror from http://wwwmaster.postgresql.org/download/mirrors-ftpand then navigating to the odbc/versions/msi/ folder. The current version is psqlodbc_08_03_0100.zip which was released Jan-22-2008.
- Unzip psqlodbc_08_03_0100.zip
- Run the psqlodbc.msi file
Setup PostgreSQL ODBC Driver
- Click Start, Control Panel, then switch the control panel to “Classical View”, if it's already not in classical view or select "System and Security" category.
- ODBC located inside Administrative Tools folder. Double click ODBC Data Sources. ODBC Data Source Administrator window displays.
- Select File DSN tab and click Add button, select “PostgreSQL Unicode” from the popup opened.
- Type in a name “pgCon” for "Create New Data Source” and Click Next
- Then Click Finish and fill in relevant server, db, username and password.
- Click the Connection button and uncheck Bools as char as shown in Manager Connection Page 1
- Click the Page 2 button and check True is -1, and uncheck updateable cursors as shown ODBC Manager Connection Pg 2 and then click OK
- A DSN (Data Source) with name “ pgCon ” is created and ready to use...
No comments:
Post a Comment