Difference between revisions of "Create ODBC source"
From IMSMA Wiki
| Line 12: | Line 12: | ||
[[Image:ODBC Source2.png|400px|center]] | [[Image:ODBC Source2.png|400px|center]] | ||
<div align="center"> | <div align="center"> | ||
| − | '' Select PostgreSQL Unicode driver and click on Finish button'' | + | '' Select PostgreSQL '''Unicode''' driver and click on Finish button'' |
</div> | </div> | ||
Revision as of 19:00, 18 March 2015
 |
In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from here and installation instructions may be found here. |
Start the ODBC manager
- On a computer with 32 bits operating system, go to Control Panel, Administrative Tools and Data Sources (ODBC).
- On a computer with 64 bits operating system, start C:\Windows\SysWOW64\odbcad32.exe
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
