Difference between revisions of "Create ODBC source"

Revision as of 15:12, 17 October 2014

In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [Downloads | here]] and installation instructions may be found here.

The driver used is of 32 bits version and therefore the 32 bits ODBC manager on 64 bits computers should be used (C:\Windows\SysWOW64\odbcad32.exe)

1. Start the ODBC manager
2. Go to the System DSN tab
3. Click on Add
4. Select PostgreSQL driver XXX in the list
5. Click on Finish button
6. Give the ODBC data source a good descriptive name
7. Database = imsma OR staging
8. Server is localhost if the database is on your computer
9. Port = 5432
10. User name = imsma
11. Password = password

Test the connection