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 so it is '''Microsoft Office''' then you should use the 32-bits PostgreSQL ODBC driver that . <br/>If you have 64 bits '''Microsoft Office''' then you should be installed on use the 64 -bits computer too PostgreSQL ODBC driver.}}
# Download the [[Media:PGSQL_ODBC.zip | '''driverone''' of drivers from ''']]. In case you have Microsoft Office 2013 64 bit and Windows 64 bit you should also download this [[Media:Psqlodbc 09 03 0300-x64-1.zipDownloads |here]]'''driver''']].
# 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]]