Difference between revisions of "Create ODBC source"
From IMSMA Wiki
| Line 1: | Line 1: | ||
| − | {{Note | In order to create an ODBC source the PostGreSQL driver has to be installed. The drivers may be downloaded from '''[[ | + | {{Note | In order to create an ODBC source the PostGreSQL driver has to be installed. The drivers may be downloaded from '''[[Downloads | here]]''' and installation instructions may be found '''[[Installation ODBC driver | here]]'''.}} |
Start the ODBC manager | Start the ODBC manager | ||
Revision as of 12:20, 6 April 2016
 |
In order to create an ODBC source the PostGreSQL driver has to be installed. The drivers may be downloaded from here and installation instructions may be found here. |
Start the ODBC manager
- On a computer with 32 bits operating system where you installed the 32-bits driver, go to Control Panel, Administrative Tools and Data Sources (ODBC)
- On a computer with 64 bits 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).
Go to System DSN tab and click on Add
Select PostgreSQL Unicode driver and click on Finish button
- 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
