POSTGRESQL ODBC DRIVER 32 BIT HOW TO
POSTGRESQL ODBC DRIVER 32 BIT INSTALL
POSTGRESQL ODBC DRIVER 32 BIT PASSWORD
POSTGRESQL ODBC DRIVER 32 BIT LICENSE

button in the Data Source URL field to pop up the list of databases to select:. Set the Name option (default is Data source 1) to CSGSRV.Ĭlick on the. Select ODBC from the dropdown list in the Database type selection window. This will open the Data Source Administration Window:. Start up Open Office on the computer this should provide you with the following window:-įrom the menu bar select the Tools->Data Sources option. If you have reached this point then your installation was sucessful. If you click on the testtable icon you should then see the information contained in this table You should now see the available tables in this database. This will show a selection of icons for Forms, Reports, Queries and Tables. Click on the OK button to complete the user input. You should now select the ODBC tab to input the User name and Password. You should see the window as shown below:. Select ODBC Test Database (PostgreSQL) and click on the OK button to complete the selection. Select ODBC from the drop down list in the Database type selection window.Ĭlick on the Browse button to get a selection for the Data source. Select the Type tab to display the Database type and Data source options. Click on the Database Icon to select a database. Start up Star Office on the computer this should provide you with the following window:-Įxpand the sidebar to allow selection of the database. The ODBC configuration should now be complete. Now edit the odbcinst.ini file ensuring the correct location of the library files :-ĭescription = PostgreSQL driver for Linux and Win32

POSTGRESQL ODBC DRIVER 32 BIT PASSWORD

Password = REMEMBER to SET the database password Here!! On the Sun or Linux machine edit the odbc.ini file and add the following:.

POSTGRESQL ODBC DRIVER 32 BIT INSTALL

Then install all 3 downloaded components by executing the 2 exe files and unzipping the psqlodbc zip file.Ĭheck using the component checker (ComCheck.exe) that PostgreSQL is available. Installed from the psqlodbc-07_02_0001.zip file. The number zzzz is the release number of psqlodbc. This release includes updated snapshots for MDAC 2.6 SP2 and MDAC 2.7 Refresh releases (filename cc.exe)ĭownload the latest version of psqlodbc-xx_yy_zzzz.zip where xx and yy are the same as the version of PostgreSQL Secondly also download the recently updated Component Checker tool from this page. Same version of the MDAC components that are installed by Windows XP. MDAC 2.7 RTM Refresh (.0) is the version which I downloaded from this site. You can also find several release manifests.Īlso please look at the information about installing MDAC. MDAC 2.7, two of MDAC 2.6, three of MDAC 2.5, and two of MDAC 2.1. Eight releases of MDAC are available here:

POSTGRESQL ODBC DRIVER 32 BIT LICENSE

To the End User License Agreements posted with each release.

These downloads are redistributable according Here you will find free downloads for all of the MDAC releases. To install ODBC on Microsoft Windows three components are required to access the PostgreSQL Database server.įirstly you require the Microsoft Data Access Components (MDAC).

rw-r-r- 1 root root 431 Nov 20 11:06 template.ini rw-r-r- 1 root root 317 Nov 20 10:45 odbcinst.ini Rpm installs libraries and configuration files either into /usr/lib and /etc or /usr/local/lib and /usr/local/etc.ĭrwxr-xr-x 2 root root 4096 Nov 20 15:16 ODBCDataSources You will require root access to install the libraries and configuration files The current unixODBC version installed is 2.0.7 and the rpm file is named unixODBC-2.0.įor the Linux install use the Red Hat Package manager from the command line or a suitable GUI like tkrpm. The rpm file for installing on Linux machines. Obtain either the unixODBC tar file for installation on Sun Machines using the Solaris Operating system or Word and Star Office to use the ODBC driver.

POSTGRESQL ODBC DRIVER 32 BIT HOW TO

It describes how to setup Open Office, Microsoft It assumes that a Postgres Database is installed and functional. This document describes how to install and configure the ODBC driver to access the PostgreSQL databases at ING. Using ODBC to access PostgreSQL databases at ING PSQL-ODBC-1 $Revision: 1.4 $ PSQL-ODBC-1: Using ODBC to access PostgreSQL databases at ING

Postgresql odbc driver 32 bit