Difference between revisions of "Create ODBC source"

From IMSMA Wiki
Jump to: navigation, search
Line 1: Line 1:
 
{{Under construction| Images missing}}  
 
{{Under construction| Images missing}}  
−
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 [[Installation ODBC driver | here]].
+
In order to create an ODBC source the PostGreSQL driver has to be installed. The driver may be downloaded from [[Media:PGSQL_ODBC.zip | here]] and installation instructions may be found [[Installation ODBC driver | here]].
  
 
{{Note | 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)}}
 
{{Note | 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)}}

Revision as of 16:26, 20 October 2014

Ambox warning blue construction.png Images missing

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.

Note.jpg 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

Technical Notes
FAQ
A - E
F - P
Q - Z
Known issues
Workarounds
Misc
Languages
Countries
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Create_ODBC_source&oldid=17266"