NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
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 Which ODBC driver you should install depends on your '''Microsoft Office''' type. <br/>If you have 32 bits version but it depends on '''Microsoft Office''' version if it is then you should use the 32 -bits PostgreSQL ODBC driver or . <br/>If you have 64 bits '''Microsoft Office''' then you should use the 64 -bits PostgreSQL ODBC driver that should be installed. }}
# Download the [[Media:PGSQL_ODBC.zip | '''driverone''' of drivers from '''[[Downloads | here]]'''.
# Unzip the installation package
# Start the installation with '''administrator''' permission
</div>
Next step is to create an '''[[Create ODBC source | ODBC source]] ''' to the {{IMSMANG}} database and/or the staging area database.
{{NavBox Technical Notes}}
[[Category:NAA]]