Error Message with Crystal Reports, MySQL and ODBC

[lkerr]

Okay ... here's my problem. I have a user (okay, myself) using an ODBC connection to access the MySQL databases through Crystal Reports 9. (Windows XP SP2, all updates)

When I try to do this, I get the following error message:


Logon failed.
Details: 28000:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL server connection.


What's going on and how do I fix this? Any ideas would be appreciated. Thanks!!

 

[k5tm]

ODBC connection to access the MySQL databases through Crystal Reports 9

I think you hace the solution right here:

Logon failed.
Details: 28000:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL server connection.

Where did SQL Server enter the picture?

Tom Morrison

http://www.liant.com