VB/MySql/CrystalReport Problem?
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
help: run-time error '20534' error detected by database dll
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
Load_File issue
Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql insert into blobtable (load_file(/P1.bmp)) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file(c:\P1.bmp), the blob field in table is NULL I also run insert into blobtable (load_file(/P1.bmp))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. _ 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
how to save image to MySQL ?
hi,forks, Now I try to save image to MySQL, I create a table with longblob field, i try two ways as follows but both did not work 1. use appendchunk, i succeed in saving image to MS SQL with this funtion. but i can't save image to MySQL with it. 2. using Load_File insert a bmp file (size is 102k) into database and use select into outfile to retrieve it, but the outfile size turned into 1k rather than 102k. Can anybody give me a hand? thank very much amy _ 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
how to save image to mySQL
hi forks, I try to save image to MySQL and I create table with longblob field. but i failed with following two ways: 1. use appendchunk and getchunk which are succeful in MS SQL but failed in MySQL 2 insert a bmp file(size is 54k) into table with load_file and get data from table using select into outfile, but the size of outfile turned into 1k. Can anybody give me a hand? Thanks in advance amy _ 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