Difference between revisions of "ITrack/Crystal Reports Failed to open a connection"

From ISoft Wiki
Jump to navigationJump to search
 
(13 intermediate revisions by 4 users not shown)
Line 1: Line 1:
==Cause==
==Cause==
[[Crystal Reports]] will give this error message when it is unable to find an ODBC connection of the name it was given.
[[Image:Odbc.png|thumb|MySQL ODBC Connection Dialog]]
[[Crystal Reports]] will give this error message when it is unable to find an [[ITrack\ODBC|ODBC]] connection of the name it was given.


ITrack (all versions, currently) tells Crystal to use the ODBC connection that shares a name with the database that ITrack is currently connected to.
ITrack (all versions, currently) tells Crystal to use the ODBC connection that shares a name with the database that ITrack is currently connected to.
The MySQL Connector/ODBC Data Source driver requires a data source name(database name) and a username to be entered.  Regardless of what is entered, ITrack will pass in the correct username and password to the ODBC driver.
Currently, most ITrack Pro installations use version 3.51 while most ITrack Enterprise installations use version 5.1.


==Solution==
==Solution==
[[Image:ODBCdialog.PNG|thumb|MySQL ODBC Connection Dialog]]Make sure that a valid ODBC connection exists with the same name as the database ITrack is connected to.
Make sure that a [[ITrack\ODBC#Installation|valid ODBC connection exists]] with the same name as the database ITrack is connected to.


[[Category:Printing Error Messages (ITrack)]]
[[Category:ITrack/Problems/Crystal Reports]]

Latest revision as of 14:07, 5 January 2010

Cause

MySQL ODBC Connection Dialog

Crystal Reports will give this error message when it is unable to find an ODBC connection of the name it was given.

ITrack (all versions, currently) tells Crystal to use the ODBC connection that shares a name with the database that ITrack is currently connected to.

The MySQL Connector/ODBC Data Source driver requires a data source name(database name) and a username to be entered. Regardless of what is entered, ITrack will pass in the correct username and password to the ODBC driver.

Currently, most ITrack Pro installations use version 3.51 while most ITrack Enterprise installations use version 5.1.

Solution

Make sure that a valid ODBC connection exists with the same name as the database ITrack is connected to.