I too have had problems with Crystal Reports and MySQL using the ODBC drivers provided by MySQL. The problem is not that you can't make Crystal Reports work with MySQL, but that when you connect to the database Crystal Reports is unable to display the tables that are in the database.
This makes interacting with MySQL more difficult since the queries have to be written by hand. For complex reports requiring multiple queries it makes CR very inefficient (because it won't modify hand written queries, it just runs the query once for each drill down). I have not yet figured out how to get around this. Some one page reports take 10 seconds to complete and involve dozens of queries when only 3 should be necessary. Obviously this won't scale well for larger reports involving thousands of records. I am using the root login and testing under win2k/XP with the latest compiled version of MySQL, latest (3.51) ODBC driver, and CR 9.0 with the latest patches. ~Wynne -----Original Message----- From: Adam Douglas [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 5:09 AM To: 'Brei, Matt'; [EMAIL PROTECTED] Subject: RE: Crystal Reports and MySQL Sounds to me that you have some permission problems. I use Crystal Reports against MySQL and many other databases and it works fine. All you have to do is setup a ODBC DSN (user or system DSN) with a username and password. Make sure this user exists in MySQL so the user can get in. I would check your MySQL log files and system log files to see if you are getting denied access. > -----Original Message----- > From: Brei, Matt [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 30, 2003 9:48 PM > To: [EMAIL PROTECTED] > Subject: Crystal Reports and MySQL > > > I am looking for any type of documentation on using Crystal > Reports with > MySQL. I have connected to mysqld from CR but when it shows the > selected database, there are no tables listed. Is there something I > have to configure in the MyODBC driver? Please help me out with any > advice you may have. > > Matt > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
