On Mon, 2003-03-31 at 07:57, Wynne Crisman wrote: Hi !!
> 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. Crystal Decisions, the company behind Crystal Reports is currently working actively on why CR 9 is failing with MySQL, but it used to work fine with earlier versions like 8.x. Will let you know any status on this to myodbc list in a day or so. Thanks > > ~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] -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA <___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]