List:General Discussion« Previous MessageNext Message »
From:Matt Brei Date:April 1 2003 3:14am
Subject:RE: Crystal Reports and MySQL
View as plain text  
Has anyone had any luck with the ODBC 2.5 drivers?

-----Original Message-----
From: Venu [mailto:venu@stripped] 
Sent: Monday, March 31, 2003 11:45 AM
To: Wynne Crisman
Cc: MySQL-List
Subject: RE: Crystal Reports and MySQL

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:ADouglas@stripped] 
> Sent: Monday, March 31, 2003 5:09 AM
> To: 'Brei, Matt'; mysql@stripped
> 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:mbrei@stripped]
> > Sent: Sunday, March 30, 2003 9:48 PM
> > To: mysql@stripped
> > 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/mysql?unsub=1
-- 
Regards, Venu
For technical support contracts, go to https://order.mysql.com
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <venu@stripped>
 / /|_/ / // /\ \/ /_/ / /__  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/mysql?unsub=1

Thread
Crystal Reports and MySQLMatt Brei31 Mar
RE: Crystal Reports and MySQLAdam Douglas31 Mar
  • RE: Crystal Reports and MySQLWynne Crisman31 Mar
    • RE: Crystal Reports and MySQLVenu31 Mar
Re: Crystal Reports and MySQLScott Pippin31 Mar
RE: Crystal Reports and MySQLMatt Brei1 Apr