... |
h1. Microsoft Windows |
# Download the ODBC 8.4 driver from [PostgreSQL download site|http://wwwmaster.postgresql.org/download/mirrors-\ftp/odbc/versions/msi/psqlodbc_08_04_0200.zip]. site|http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_08_04_0200.zip]. If you are looking for 64\-bit Windows driver download the driver from [here|http://code.google.com/p/visionmap/wiki/psqlODBC]. Later versions of the driver may be used, but are not considered fully supported. |
# Extract the contents of the ZIP file into a temporary location on your system. For example: "c:\temp\pgodbc" # Double click on "psqlodbc.msi" file or \(.exe file in the case of 64 bit) to start installation of the driver. |
... |
A PostgreSQL ODBC driver needed to make the ODBC connection to Teiid is not bundled with the Teiid distribution. The appropriate driver needs be downloaded directly from the PostgreSQL web site. We have tested with 8.04.200 version of the ODBC driver.
For all other platforms other than Microsoft Windows, the ODBC driver needs built from the source files provided. Download the ODBC driver source files from the PostgreSQL download site. Untar the files to a temporary location. For example: "~/tmp/pgodbc". Build and install the driver by running the commands below.
You should use super user account or use "sudo" command for running the "make install" command. |
% tar -zxvf psqlodbc-xx.xx.xxxx.tar.gz % cd psqlodbc-xx.xx.xxxx % ./configure % make % make install
Some *nix distributions may already provide binary forms of the appropriate driver, which can be used as an alternative to building from source.