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
