Difference between revisions of "ITrack/Crystal Reports Logon Failed"

From ISoft Wiki
Jump to navigationJump to search
(Added more details)
Line 1: Line 1:
This error occurs when printing a report.
==Cause==
==Cause==
This error probably means that your computer is trying and failing to log into the MYSQL server.
This error probably means that [[Crystal Reports]] is trying and failing to log into the MySQL server using an ODBC connection.


==Solution==
==Solution==
If your PC connects with the server over a VPN, make sure that the VPN software is running properly on both machines.  If that's not the problem, then it's usually a good idea to make sure the MYSQL service is actually running on the intended host and that there are no firewalls blocking any necessary ports.
The first thing to do is check the ODBC connection on the computer with the error, and make sure these settings are properly configured:
* Host
* Username
* Port
 
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.


[[Category:Error Messages (ITrack)]]
[[Category:Error Messages (ITrack)]]
[[Category:Printing Error Messages (ITrack)]]
[[Category:Printing Error Messages (ITrack)]]

Revision as of 11:09, 25 February 2009

This error occurs when printing a report.

Cause

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

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:

  • Host
  • Username
  • Port

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.