Difference between revisions of "ITrack/IDispatch error 31837 - Failed to open the connection"

From ISoft Wiki
Jump to navigationJump to search
 
(One intermediate revision by the same user not shown)
Line 9: Line 9:
# Click the '''Configure...''' button on the right
# Click the '''Configure...''' button on the right
# Make sure that everything is set up correctly
# Make sure that everything is set up correctly
#* This includes ensuring that '''the name of the ODBC connection matches the name of the database you're currently connecting to'''.  If you connect to `itrackpro_testing`, you need an ODBC connection named 'itrackpro_testing'.
#* This includes ensuring that '''the ODBC datasource name matches the name of the database ITrack is currently connecting to'''.  If you connect to `itrackpro_testing`, you need an ODBC connection named 'itrackpro_testing'.


[[Category:ITrack/Printing Error Messages]]
[[Category:ITrack/Printing Error Messages]]


[[Category:ITrack/Support]]
[[Category:ITrack/Support]]

Latest revision as of 10:52, 13 March 2012

Idispatch31837.PNG

Cause

This error occurs because the ODBC connection is not set up correctly.

Solution

  1. Go into Control Panel > Administrative Tools > Data Sources (ODBC)
  2. Go to the System DSN tab. Make sure to set it up as a System DSN and NOT a User DSN. (Learn about the differences)
  3. Click the Configure... button on the right
  4. Make sure that everything is set up correctly
    • This includes ensuring that the ODBC datasource name matches the name of the database ITrack is currently connecting to. If you connect to `itrackpro_testing`, you need an ODBC connection named 'itrackpro_testing'.