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

From ISoft Wiki
Jump to navigationJump to search
(Adding some spicy info about this error)
 
(6 intermediate revisions by 3 users not shown)
Line 3: Line 3:
Logon failed.
Logon failed.


== Problem ==
==Cause==
This error occurs because the login information in ODBC is incorrect.  
This error probably means that [[Crystal Reports]] is trying and failing to log into the MySQL server using an [[ITrack\ODBC|ODBC]] connection.


== Solution(s) ==
The error can also occur when a report is saved with an invalid (for the customer) database connection.
* Open up ODBC, enter the correct information, and hit "Test" to confirm that you have a connection.
* If an ODBC entry exists for ITrack in the 'User DSN' tab, you should delete that out. The ODBC connections should be set up in the 'System DSN' tab.
* Try navigating to the reports directory and printing again.


==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 driver, 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.
If you've eliminated ODBC errors as an issue:
* Open the report using Crystal Reports.
* Run the report.
* Where you're asked to put in your username/password, check the "database" field at the bottom of the window. Make sure it's pointed to 'itrackpro' or 'itrackenterprise' and not one of our testing databases.
* Save the report after you've put in the right database connection and run it. Then deploy it to the customer.
[[Category:ITrack/Problems/Crystal Reports]]
[[Category:ITrack/Printing Error Messages]]
[[Category:ITrack/Printing Error Messages]]
[[Category:ITrack/Support]]
[[Category:ITrack/Support]]

Latest revision as of 09:57, 24 May 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.

The error can also occur when a report is saved with an invalid (for the customer) database 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 driver, 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.

If you've eliminated ODBC errors as an issue:

  • Open the report using Crystal Reports.
  • Run the report.
  • Where you're asked to put in your username/password, check the "database" field at the bottom of the window. Make sure it's pointed to 'itrackpro' or 'itrackenterprise' and not one of our testing databases.
  • Save the report after you've put in the right database connection and run it. Then deploy it to the customer.
Retrieved from "https://wikido.isoftdata.com//index.php?title=ITrack/IDispatch_error_31816_-_Logon_failed&oldid=6889"