Installation ODBC driver

From IMSMA Wiki

Revision as of 12:10, 6 April 2016 by Alnaucler (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

In order to be able to connect Access, Excel, etc. to the IMSMA^NG database and/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 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.

Download the driver.
Unzip the installation package
Start the installation with administrator permission

Click Next

Accept and click Next

Click Next

Click Install

Click Finish

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

Technical Notes Portal

Technical Notes

FAQ

A - E	ArcEngine/Java issue · Combine several zip files · Create ODBC source · Data Dictionary · Difference MySQL PostgreSQL · Delete Non-functional Saved Search · Empty Reconciliation Tab · Environment variables used by IMSMA^NG · Error opening Data Entry Form Template · Exporting Part of Tree Structure from IMSMA^NG

F - P	Font and language problems · Install ODBC driver · Installation package NG is not working · Installation package SAG is not working · iReport does not start · Java automatic update · Java error during installation · Language issues · Manually create PGSQL service · Manually delete IMSMA Remote Entry service · Manually delete PGSQL service · Ports used by is IMSMA · Pre-defined Saved Searches

Q - Z	Renamed fields · Shutdown IMSMA Server · Start-up IMSMA Server · Switch Templates · Technical specifications for PC and tablets · Templates do not work in IMSMA Remote Entry · Two Terms Not to be Translated · Unapprove does not work · Unblock IMSMA Server · Which version of IMSMA^NG is installed? · Windows 8 and Windows 10 · XML Documentation