now i try to migrate database from MS SQL server to My SQL, I use Visual Basic and Crystal Report to generate some reports, when i connect to MS SQL 2000, no problem, but when i connect to MySQL , the crystal report can't be previewed and get following message : run-time error '20534' error detected by database dll afteri run following code: sql = "select * from mycase" CrystalReport.SQLQuery = sql CrystalReport.Action = 1
_________________________________________________________ Do You Yahoo!? 到世界杯主题公园玩一玩,赢取世界杯门票乐一乐。 http://cn.worldcup.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 --------------------------------------------------------------------- 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