Difference between revisions of "Installation ODBC driver"

From IMSMA Wiki
Jump to: navigation, search
Line 4: Line 4:
 
{{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 }}
 
{{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 }}
  
−
# [[Media:PGSQL_ODBC.zip | Download]] the driver
+
# [[Media:PGSQL_ODBC.zip | '''Download''']] the driver
 
# Unzip the installation package
 
# Unzip the installation package
−
# Start the installation with administrator permission
+
# Start the installation with '''administrator''' permission
−
# Follow the instructions
+
[[Image:PG ODBC driver install1.png|300px|center]]
 +
<div align="center">
 +
''Click Next''
 +
</div>
 +
[[Image:PG ODBC driver install2.png|300px|center]]
 +
<div align="center">
 +
''Accept and click Next''
 +
</div>
 +
[[Image:PG ODBC driver install3.png|300px|center]]
 +
<div align="center">
 +
''Click Next''
 +
</div>
 +
[[Image:PG ODBC driver install4.png|300px|center]]
 +
<div align="center">
 +
''Click Install''
 +
</div>
 +
[[Image:PG ODBC driver install5.png|300px|center]]
 +
<div align="center">
 +
''Click Finish''
 +
</div>
  
 
Next step is to create an [[Create ODBC source | ODBC source]] to the {{IMSMANG}} database and/or the staging area database.  
 
Next step is to create an [[Create ODBC source | ODBC source]] to the {{IMSMANG}} database and/or the staging area database.  

Revision as of 15:37, 20 October 2014

Ambox warning blue construction.png 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).

Note.jpg 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
  1. Download the driver
  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.

Technical Notes
FAQ
A - E
F - P
Q - Z
Known issues
Workarounds
Misc
Languages
Countries
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Installation_ODBC_driver&oldid=17273"