Difference between revisions of "ITrack/IDispatch error 31816 - Logon failed"

From ISoft Wiki
Jump to navigationJump to search
Line 7: Line 7:


==Solution==
==Solution==
The first thing to do is check the ODBC connection on the computer with the error, and make sure these settings are properly configured:
In the ODBC configuration, make sure these settings are properly configured:
* Host
* Host
* Username
* Port
* Port
If the computer is running 64bit Windows, make sure you configure the 32bit version of the ODBC drive, which is '''NOT''' found in Control Panel and is instead located at: %systemdrive%\Windows\SysWoW64\Odbcad32.exe


If ITrack can connect, but Crystal Reports (through the ODBC connection) can not, the problem almost always has to do with the settings for the ODBC connection.
If ITrack can connect, but Crystal Reports (through the ODBC connection) can not, the problem almost always has to do with the settings for the ODBC connection.

Revision as of 15:21, 3 January 2013

IDispatchError31816.png

Logon failed.

Cause

This error probably means that Crystal Reports is trying and failing to log into the MySQL server using an ODBC connection.

Solution

In the ODBC configuration, make sure these settings are properly configured:

  • Host
  • Port

If the computer is running 64bit Windows, make sure you configure the 32bit version of the ODBC drive, which is NOT found in Control Panel and is instead located at: %systemdrive%\Windows\SysWoW64\Odbcad32.exe

If ITrack can connect, but Crystal Reports (through the ODBC connection) can not, the problem almost always has to do with the settings for the ODBC connection.

It is also possible that some sort of software firewall could be blocking ODBC, but not ITrack itself.