IMHO - I would use ADO over the MyODBC layer to retrieve disconnected recordsets representing your report data from MySQL, then pass said adors to Crystal Report's viewer.
To learn more about this approach, search seagate.com for ado disconn. rs, which utilizes "ttx" files (tab delimited text files) to create the report in design view. hth Chris mcdba mcse www.mydba2000.com >From: yue cheng <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: VB/MySql/CrystalReport Problem? >Date: Thu, 14 Mar 2002 08:09:57 -0800 (PST) > >Dear folks, > >Now i try to migrate my Visual Basic Application from >MS SQL Server to My SQL, I met problem when my crystal >report connect ot My SQL, Below is my code: > >CrystalReport1.connect = "DSN=testDB;uid=amy;pwd=test" > >CrystalReport1.Destination = 0 > >CrystalReport1.ReportFileName = >"c:\localfolder\test.rpt" > >sql = "select * from score" > >CrystalReport1.SQLQuery = sql > >CrystalReport1.Action = 1 > >when execute the last line, Following error message >come up: > >Run-time error: '20534': Error detected by database >dll. But when i connect to > >MS SQL Server, everything work fine. > >Anybody give me a hand ? > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Sports - live college hoops coverage >http://sports.yahoo.com/ > >--------------------------------------------------------------------- >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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
