Hi brother,
I use ReadBinaryFromFile & SaveBinaryToFile to save and get image in Blob field of MySQL,but the picture can not be display,after comparision,I found the binary data is changed.The code is below,could you give some good advise? thank you !
‘ save …..
pRs.AddNew
pRs.Fields(”id”) = “14″
pRs.Fields(”img”) = pRs.ReadBinaryFromFile(App.Path & “\source.jpg”)
pRs.Update
‘read….
b = pRs.SaveBinaryToFile(pRs.Fields(”img”).Value, App.Path & “\tmp.jpg”)
Hi brother,
I use ReadBinaryFromFile & SaveBinaryToFile to save and get image in Blob field of MySQL,but the picture can not be display,after comparision,I found the binary data is changed.The code is below,could you give some good advise? thank you !
‘ save …..
pRs.AddNew
pRs.Fields(”id”) = “14″
pRs.Fields(”img”) = pRs.ReadBinaryFromFile(App.Path & “\source.jpg”)
pRs.Update
‘read….
b = pRs.SaveBinaryToFile(pRs.Fields(”img”).Value, App.Path & “\tmp.jpg”)
mysql error : 40004
when i add small photos it is ok. but when i add 1 MB (10 inchx 10 inch) photo. error show
I’m having problem on connecting visual studio 2005 using vb.net to sql server 2005. Please assist me the steps that i need to follow and the codes as well.
I’m having a problem when i try to use the vbmysqldirect 1.0 library to access a mysql 5.0 database. I get a “Client does not support authentication protocol” Error, but only in my Vb6 Console, when i compile it and run it (directly from the .exe file), it runs ok. Do you have any idea of why this could be happening? Im having no problems accessing a 4.0 database.
I’ve tried adding the –old-passwords to the my.cnf on the 5.0 server, but i get no results…
I’m running a W2000 workstation using VB6 with all the latest patches.
Update libmysql.dll in System32 to the latest adequate version. I guess you may get it from an installation of Mysql Administrator downloaded from mysql.com
Hey, regarding my problem, it was because i migrated from mysql 4 to mysql 5 and the user table in the mysql server changed.
(kinda late, but hey, someone else could pick up the same problem on google)
I want to know if it is safe to use this library in a comercial development.
Actually i´m using My ODBC driver with some issues, that leads me here to be honest.
I tried to use a datagrid to display the data in a table and for update that data but when i change a value my program explodes, Dr. watson comes to rescue and that´s the situation.
Thanks in advance.
Great project, thanks
any idea how to use it with hebrew character ? I’ve got unexpected error when trying to run sql with hebrew characters.
the same sql line with english characters works fine.
November 19th, 2006 at 6:25 am
[…] See http://www.vbmysql.com/projects/vbmysqldirect/ […]
January 7th, 2007 at 8:33 am
…
January 18th, 2007 at 9:51 am
Please send to me article mysql
May 1st, 2007 at 3:35 am
Ok for vbmysqldirect
May 3rd, 2007 at 9:42 pm
Great dev!!! waiting for more tutorials and updates.
May 4th, 2007 at 3:45 am
Hi brother,
I use ReadBinaryFromFile & SaveBinaryToFile to save and get image in Blob field of MySQL,but the picture can not be display,after comparision,I found the binary data is changed.The code is below,could you give some good advise? thank you !
‘ save …..
pRs.AddNew
pRs.Fields(”id”) = “14″
pRs.Fields(”img”) = pRs.ReadBinaryFromFile(App.Path & “\source.jpg”)
pRs.Update
‘read….
b = pRs.SaveBinaryToFile(pRs.Fields(”img”).Value, App.Path & “\tmp.jpg”)
May 23rd, 2007 at 1:18 am
sir, I want to join your forum.
Help me further
Thank you
renga
June 17th, 2007 at 5:36 am
Hi brother,
I use ReadBinaryFromFile & SaveBinaryToFile to save and get image in Blob field of MySQL,but the picture can not be display,after comparision,I found the binary data is changed.The code is below,could you give some good advise? thank you !
‘ save …..
pRs.AddNew
pRs.Fields(”id”) = “14″
pRs.Fields(”img”) = pRs.ReadBinaryFromFile(App.Path & “\source.jpg”)
pRs.Update
‘read….
b = pRs.SaveBinaryToFile(pRs.Fields(”img”).Value, App.Path & “\tmp.jpg”)
mysql error : 40004
when i add small photos it is ok. but when i add 1 MB (10 inchx 10 inch) photo. error show
please reply
June 27th, 2007 at 5:41 pm
To raja:
Revise your mysql parameters…
August 2nd, 2007 at 3:14 am
Dear Sir;
I’m having problem on connecting visual studio 2005 using vb.net to sql server 2005. Please assist me the steps that i need to follow and the codes as well.
Thank you.
September 22nd, 2007 at 2:31 pm
nice work. any more development?
September 26th, 2007 at 6:18 am
i found this site very useful for my mysql database system… keep up the good work bro. we are waiting for more development.
October 13th, 2007 at 11:13 am
hi,,,,, can i ask about connecting the mysql to visual basic 6.0??? thank you
January 23rd, 2008 at 6:14 pm
I’m having a problem when i try to use the vbmysqldirect 1.0 library to access a mysql 5.0 database. I get a “Client does not support authentication protocol” Error, but only in my Vb6 Console, when i compile it and run it (directly from the .exe file), it runs ok. Do you have any idea of why this could be happening? Im having no problems accessing a 4.0 database.
I’ve tried adding the –old-passwords to the my.cnf on the 5.0 server, but i get no results…
I’m running a W2000 workstation using VB6 with all the latest patches.
Thanks!
February 21st, 2008 at 6:45 pm
Update libmysql.dll in System32 to the latest adequate version. I guess you may get it from an installation of Mysql Administrator downloaded from mysql.com
April 29th, 2008 at 6:12 am
how can i join sir?
April 29th, 2008 at 3:11 pm
Hey, regarding my problem, it was because i migrated from mysql 4 to mysql 5 and the user table in the mysql server changed.
(kinda late, but hey, someone else could pick up the same problem on google)
Cheers.
May 9th, 2008 at 2:34 am
I want to know if it is safe to use this library in a comercial development.
Actually i´m using My ODBC driver with some issues, that leads me here to be honest.
I tried to use a datagrid to display the data in a table and for update that data but when i change a value my program explodes, Dr. watson comes to rescue and that´s the situation.
Thanks in advance.
May 9th, 2008 at 2:50 am
Martin, as far as I know and in my own experience… its safe and easy to use. I’m using it in both VB6 and VB.NET (2005 & 2008).
May 12th, 2008 at 7:48 am
Great project, thanks
any idea how to use it with hebrew character ? I’ve got unexpected error when trying to run sql with hebrew characters.
the same sql line with english characters works fine.
Shamir
June 17th, 2008 at 6:54 pm
this project is very very super. i like that………. thkx for the publisher bye……… SaRu
June 17th, 2008 at 7:01 pm
bad
July 12th, 2008 at 11:05 am
Hi,
How do i join?
August 6th, 2008 at 8:49 am
Hi. great work. need clarity on whether vb and SQL server can be connected