Re: MyODBC 3.51 & Crystal Reports

I have been developing a database using VB and Crystal Reports connecting to
a MySQL 3.23.53 database.

I have had a problem using the 3.51 ODBC connection, which seems to result
in two errors being thrown up.

1. When building the report in CR Designer, the join syntax produces an
error and needs to be manually edited to remove 'oj{' and '}' from the
beginning and end of the 'WHERE' clause.

2. When trying to call the report from within VB either using the
CrystalReport1.Action = 1 or the CrsystalReport1.PrintReport methods an
error is produced 'Unable to Open Server'

I have reverted to the 2.50 Version of MyODBC which does not seem to exhibit
the same behaviour.

If you require any further details, please do not hesitate to contact me.

How-To-Repeat:

1. Create a report against any MySQL database using a 3.51 ODBC connection
and CR v7 which contains atleast one join.
2. Inspect the SQL query generated by CR paying particular attention to the
join clause/s
3. Attempt to call the report from VB using either the Crystalreport1.action
= 1 or the Crystalreport1.PrintReport methods

Versions:
Client: Win98 SE
Server: NT4 SP6a
VB5 SP3
Crystal Reports 7
MySQL 3.23.53 nt
MyODBC 3.51 & 2.50



Alan F. Brown
IT Manager
Stafford House
19 New Dover Road
Canterbury, Kent, CT1 3AH UK
Tel: +44 (0)1227 453237 ext: 217
Fax: +44 (0)1227 451685
Mobile: +44 (0)7968 814528



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12845@lists.mysql.com
To unsubscribe, e-mail

RE: MyODBC 3.51 & Crystal Reports

I dont get that error.. but I use Crystal 8.5...
you might conside upgrading. Also the running total problem is fixed in
this version.

-----Original Message-----
From: I T Manager [mailto:support@staffordhouse.com]
Sent: Thursday, October 24, 2002 5:21 AM
To: bugs@lists.mysql.com
Subject: Re: MyODBC 3.51 & Crystal Reports


I have been developing a database using VB and Crystal Reports connecting to
a MySQL 3.23.53 database.

I have had a problem using the 3.51 ODBC connection, which seems to result
in two errors being thrown up.

1. When building the report in CR Designer, the join syntax produces an
error and needs to be manually edited to remove 'oj{' and '}' from the
beginning and end of the 'WHERE' clause.

2. When trying to call the report from within VB either using the
CrystalReport1.Action = 1 or the CrsystalReport1.PrintReport methods an
error is produced 'Unable to Open Server'

I have reverted to the 2.50 Version of MyODBC which does not seem to exhibit
the same behaviour.

If you require any further details, please do not hesitate to contact me.

How-To-Repeat:

1. Create a report against any MySQL database using a 3.51 ODBC connection
and CR v7 which contains atleast one join.
2. Inspect the SQL query generated by CR paying particular attention to the
join clause/s
3. Attempt to call the report from VB using either the Crystalreport1.action
= 1 or the Crystalreport1.PrintReport methods

Versions:
Client: Win98 SE
Server: NT4 SP6a
VB5 SP3
Crystal Reports 7
MySQL 3.23.53 nt
MyODBC 3.51 & 2.50



Alan F. Brown
IT Manager
Stafford House
19 New Dover Road
Canterbury, Kent, CT1 3AH UK
Tel: +44 (0)1227 453237 ext: 217
Fax: +44 (0)1227 451685
Mobile: +44 (0)7968 814528



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12845@lists.mysql.com
To unsubscribe, e-mail


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12851@lists.mysql.com
To unsubscribe, e-mail

Re: MyODBC 3.51 & Crystal Reports

Hi!

>>>>> "I" == I T Manager writes:

I> I have been developing a database using VB and Crystal Reports connecting to
I> a MySQL 3.23.53 database.

I> I have had a problem using the 3.51 ODBC connection, which seems to result
I> in two errors being thrown up.

I> 1. When building the report in CR Designer, the join syntax produces an
I> error and needs to be manually edited to remove 'oj{' and '}' from the
I> beginning and end of the 'WHERE' clause.

Do you mean oj{..} or {oj ...}

MySQL should accept (and ignore) the later syntax.

Here is an example for this:

mysql> create temporary table t1 (a int not null);
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1 where {oj a=0};
Empty set (0.00 sec)

Can you please post an example of the syntax for which MySQL gives an error?

I> 2. When trying to call the report from within VB either using the
I> CrystalReport1.Action = 1 or the CrsystalReport1.PrintReport methods an
I> error is produced 'Unable to Open Server'

Sorry, but I don't know the answer to this question :(

Regards,
Monty

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12964@lists.mysql.com
To unsubscribe, e-mail