Difference between revisions of "Installation ODBC driver"

From IMSMA Wiki
Jump to: navigation, search
Line 1: Line 1:
 
In order to be able to connect Access, Excel, etc. to the {{IMSMANG}} database and/or the staging area database PostgreSQL ODBC driver needs to be installed on the computer that will connect to the database(s).
 
In order to be able to connect Access, Excel, etc. to the {{IMSMANG}} database and/or the staging area database PostgreSQL ODBC driver needs to be installed on the computer that will connect to the database(s).
  
{{Note | The PostgreSQL used with IMSMA is 32 bits version but it depends on '''Microsoft Office''' version if it is 32 bits PostgreSQL ODBC driver or 64 bits PostgreSQL ODBC driver that should be installed. <br/>
+
{{Note | Which ODBC driver you should install depends on your '''Microsoft Office''' type. <br/>
If you have '''32-bits''' Microsoft Office installed, you should install the '''32-bits''' driver and if you have '''64-bits''' Microsoft Office, you should install the '''64-bits''' driver.}}
+
If you have 32 bits '''Microsoft Office''' then you should use the 32-bits PostgreSQL ODBC driver. <br/>
 +
If you have 64 bits '''Microsoft Office''' then you should use the 32-bits PostgreSQL ODBC driver.}}
  
 
# Download the '''one''' of drivers from '''[[Downloads | here]]'''.  
 
# Download the '''one''' of drivers from '''[[Downloads | here]]'''.  

Revision as of 15:10, 30 March 2019

In order to be able to connect Access, Excel, etc. to the IMSMANG database and/or the staging area database PostgreSQL ODBC driver needs to be installed on the computer that will connect to the database(s).

Note.jpg Which ODBC driver you should install depends on your Microsoft Office type.

If you have 32 bits Microsoft Office then you should use the 32-bits PostgreSQL ODBC driver.
If you have 64 bits Microsoft Office then you should use the 32-bits PostgreSQL ODBC driver.

  1. Download the one of drivers from here.
  2. Unzip the installation package
  3. Start the installation with administrator permission
PG ODBC driver install1.png

Click Next

PG ODBC driver install2.png

Accept and click Next

PG ODBC driver install3.png

Click Next

PG ODBC driver install4.png

Click Install

PG ODBC driver install5.png

Click Finish

Next step is to create an ODBC source to the IMSMANG database and/or the staging area database.