Bug #5585 Crystal report on Client of MySQL 4.1
Submitted: 15 Sep 2004 3:34 Modified: 6 Oct 2004 19:56
Reporter: Yogesh Deshpande Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51 OS:Windows (windows 98)
Assigned to: Matthew Lord CPU Architecture:Any

[15 Sep 2004 3:34] Yogesh Deshpande
Description:
I have developed a client server application using VB 6.0 , MyODBC 3.51 and MySQL 4.1 and crystal report 7.0. When I run report on server It works fine but on client location same report is not showing inner join fields or given some error.

Is this problem with ODBC or problem of MySQL not supporting to crystal report on client side.

What exactly problem is ? How should I overcome this problem.

Please give me solution for this. 

It's urgent for implementing my project.

Thanks.

With regards.

Yogesh

(ydeshpande@samsonite.co.in)

How to repeat:
I have developed a client server application using VB 6.0 , MyODBC 3.51 and MySQL 4.1 and crystal report 7.0. When I run report on server It works fine but on client location same report is not showing inner join fields or given some error.

Is this problem with ODBC or problem of MySQL not supporting to crystal report on client side.

What exactly problem is ? How should I overcome this problem.

Please give me solution for this.
[6 Oct 2004 19:56] Matthew Lord
Hi,

For bugs we need a repeatable test case.  I understand your situation but we cannot be of much 
help through this channel.  If you do not have a support contract you can use the mailings lists
and the IRC rooms.  Both channels will provide help from the community as well as employees of 
MySQL.
lists.mysql.com
mysql.com/IRC

Best Regards
[28 Aug 2010 2:38] ym lau
hi, Yogesh
i using vb6, crystal report7 and mysql. the problem now is when i try to view my report is prompt the error message said...
"ODBC error:[Mysql][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]unknow column 'qry_insurance1.insurancecode' in 'field list'"
here is my coding for calling the crystal report and connect through ODBC
        With CryRpt
            .ReportFileName = App.Path & "\REPORTS\Report1.rpt"
            .SQLQuery = "Select * From qry_insurance"
            .DiscardSavedData = True
            .WindowState = crptMaximized
            .Destination = crptToWindow
            .Action = 1
        End With

can anybody help me??
is it my coding wrong??

thanks...