Changes

Create ODBC source

497 bytes added, 13:57, 5 August 2016

no edit summary

{{Under constructionNote | Images missing}} In order to create an ODBC source the PostGreSQL driver has to be installed. The driver drivers may be downloaded from '''[[Media:PGSQL_ODBC.zip Downloads | here]] ''' and installation instructions may be found '''[[Installation ODBC driver | here]]'''.}}

{{Note | The driver used is of Start the ODBC manager:* On a computer with 32 bits version and therefore operating system where you installed the 32 -bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC manager on ):* On a computer with '''64 ''' bits computers should be used (operating system where you installed the '''32-bits driver''', start ''C:\Windows\'''SysWOW64'''\odbcad32.exe'':* On a computer with 64 bits operating system where you installed the 64-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC)}}.# Start the [[Image:ODBC managerSource1.png|400px|center]]<div align="center"># '' Go to the System DSN tab# Click and click on Add''</div> [[Image:ODBC Source2.png|400px|center]]# <div align="center">'' Select PostgreSQL '''Unicode''' driver XXX in the list# Click and click on Finish button''</div> [[Image:ODBC Source3.png|400px|center]]

# Give the ODBC data source a good descriptive name

# Database = ''imsma '' OR ''staging''# Server is ''localhost '' if the database is on your computer# Port = is normally 5432# User name = ''imsma''# Password = ''password'' # Test the connection# Click on Save

{{NavBox Technical Notes}}

[[Category:NAA]]

• ← Older edit

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits