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