Difference between revisions of "Installation ODBC driver"
From IMSMA Wiki
Line 1: | Line 1: | ||
{{Under construction| Images missing}} | {{Under construction| Images missing}} | ||
− | In order to be able to connect Access, Excel, etc. to the {{IMSMANG}} database or the staging area database | + | In order to be able to connect Access, Excel, etc. to the {{IMSMANG}} database or the staging area database PostgreSQL ODBC driver needs to be installed on the computer that will connect to the database(s). |
− | {{Note | The | + | {{Note | The PostgreSQL used with IMSMA is 32 bits version so it is the PostgreSQL ODBC driver that should be installed on 64 bits computer too }} |
# [[Downloads | Download]] the driver | # [[Downloads | Download]] the driver |
Revision as of 17:41, 18 October 2014
Images missing |
In order to be able to connect Access, Excel, etc. to the IMSMANG database or the staging area database PostgreSQL ODBC driver needs to be installed on the computer that will connect to the database(s).
The PostgreSQL used with IMSMA is 32 bits version so it is the PostgreSQL ODBC driver that should be installed on 64 bits computer too |
- Download the driver
- Unzip the installation package
- Start the installation with administrator permission
- Follow the instructions
Next step is to create an ODBC source to the IMSMANG database and/or the staging area database.