Crystal Reports

ok, i have managed to get Crystal Reports working (displaying all the data in a particular table) with SQL Server, however when i try to replicated the same proceedure with mySQL and run the application i get a login error "Server Error in /wsCrystal Application. logon failed"

Anyone got any suggestions??

Mike55
 
Hi all,

I finally thought of a solution to my problem with the crystal reports. Not the optimal solution, but still a solution...I selected the data that i wanted to display in the Crystal Report and moved it to its own table. I then transfered the data to a similar table in SQL Server and read the data from there into the Crystal Reports. O, not the optimal solution but still it works.

Would appreciate any comments on this approach i.e. "im crazy doing it that way" or "better options"

Mike55
 
ODBC driver

Try using the ODBC driver for mysql. It can be downloaded from myql.com.
Then set the datasource in ODBC and set Crystal Reports to look for ODBC datasources. Ive been succesful in creating reports from mysql this way.

Hope this helps




mike55 said:
ok, i have managed to get Crystal Reports working (displaying all the data in a particular table) with SQL Server, however when i try to replicated the same proceedure with mySQL and run the application i get a login error "Server Error in /wsCrystal Application. logon failed"

Anyone got any suggestions??

Mike55
Click to expand...
 
hi. I have the same problem. I installed the mysql ODBC for VB.NET, the connection works well, but in the CR data sources I cant see anything about mysql. Why?

thanks
 
done....silly me.. :)

I haved the problem with "cant open raw set" ..or something like that, and I spend a couple of minutes to see where the problem was. That was a verry weird thing.
 
Back
Top