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 =
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
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
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
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
