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.
Thank you for the tutorial, it has been very useful.
i only get this error when i close the a form u open first is closed and try to open another i get this error
key cannot be null and points to this part of code
I develop many programs with vb + cr 9 + mysql ( sometime i use other database, ), i never encounter any problem, today i encounter a problem, a report that has been successfull exported 100 % to ms excell ( i choose ms excell 97/2000 in option list ) and no problem occur in progress exported, but when i tried to open those exported file, message occured with message error, in sum total, but i didnt used any formula for summerize, i created report just for displaying data, i didn’t create any formula. but the error message like above. i admit that each field with type string, i setted can grow the height automatically. and why a record that adjust automatically grow in height, is not in one row in excell but write on the second row or later. please advice for anyone who had same expriented and has solved it. any advice will be appreciate.
SQL = “Select * from hi_danji where user_id = ‘” & txtId & “‘”
Set pRs1 = gCnn.Execute(SQL)
If pRs1.EOF() Then
pRs1.AddNew
pRs1.Fields(“user_id”) = txtId.Text
pRs1.Fields(“user_city”) = cCity.ListIndex
pRs1.Fields(“user_area”) = cArea.ListIndex
pRs1.Fields(“user_danji”) = cDanji.ListIndex
pRs1.Fields(“user_sangsa”) = cSangsa.Text
pRs1.Update
end if
rumtime error : 40003
Server Error Detected.
Number : 1064
Description : You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near
Sir,
I’m almost giving up about saving Binary data in a mysql field from .Net environment. The major problem is that I can’t concatenate the binary variable with other strings in the INSERT query. Please, I would like you to forward anything that can help me out. I’m already in a loop, help me out please.
Hi. I keep getting the file not found error. Every time i try to run the sample programs provided or any of my own projects, i get the error 53: File not found: libmysql. ALthough the file libmysql.dll is right there beside vbmysqldirect.dll. I even tried putting them into system32 folder. Tried registering them (didnt register). I dont know what is up! and libmysql doesnt reference into vb either.
SOme info: using mysql server (Version 5.1.37) with xampplite
Please helppp!!
I would like to reduce coding process by adding MySQL database into the my project using “Add New Data Source” wizard. This method ease data-binding task to controls and etc. I encounter an error saying “failed to create relation” at the end of the wizard. However, the Data Source is created and ready for use. Any idea what is happening?
I am not very good in vb also mysql, but I am very concern regarding application speed mostly on displaying data.
I just wonder by this method, how many user can access in same time?
Do I need to set up anything on server like concurrent user accessing database, expendable bandwidth size or elsewhere?
Alas, vbmysqldirect.zip appears corrupt. VBMySQLDirect_Setup.exe cannot be extracted, although it seems all other files are. I’ve downloaded the file twice, so I doubt it’s corrupted in transit.
hi, can you pls. help me do my project, it was a video rental system, i’m using vb.net 2008 and mysql, what are the codes to edit, save and update? and also, if i click search by, there are names that will appear on the data grid view? hope you will help me.. PM me pls. tnx
hey, guys anybody can help me out. i need a vb6 project for sales and service which is using “my sql” has back end and vb has front end.
please send me the link to download this project. here is my Email id : http://www.may9_waghith@yahoo.com
November 19th, 2006 at 6:25 am
[...] See http://www.vbmysql.com/projects/vbmysqldirect/ [...]
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
August 6th, 2008 at 8:49 am
Hi. great work. need clarity on whether vb and SQL server can be connected
August 29th, 2008 at 3:03 am
can vbmysqldirect connect with vb6 datagrid ?????
like set datagrid1.datasource = rs
then error prompt out
run time error 13
type mis match
September 8th, 2008 at 3:48 am
thanks.i will try this.
September 10th, 2008 at 8:52 am
thanks. i will also try this… god bless!
September 10th, 2008 at 11:27 pm
guys can you give me a program about the user account system? or some link about this program? tnx
September 11th, 2008 at 1:27 pm
hi
Thank you for the tutorial, it has been very useful.
i only get this error when i close the a form u open first is closed and try to open another i get this error
key cannot be null and points to this part of code
try
conn.open
any help will be appriciated.
September 19th, 2008 at 5:13 pm
I’ll do a testing on vb6+mysql+wine on opensuse and slax.
October 9th, 2008 at 3:55 am
y vbmysqldirect cannot bind datagrid with mysql.
anyone can help me
pls……………..
October 14th, 2008 at 7:40 am
sir, will you please teach me to make a search engine using visual basic and mysql?
October 31st, 2008 at 8:07 am
What is the code for connecting VB 2005 to My SQL 4.1
December 17th, 2008 at 6:49 am
Hi everybody
I need a small project to lean Vb with Mysql database
Thanks
Jothimani
January 14th, 2009 at 6:17 pm
I want to know if VB 6 my sql can be connected or not?
If i Keep My Sql in Linux Server is it Possible To Connect through VB6?
January 19th, 2009 at 7:51 am
Dear All,
I develop many programs with vb + cr 9 + mysql ( sometime i use other database,
), i never encounter any problem, today i encounter a problem, a report that has been successfull exported 100 % to ms excell ( i choose ms excell 97/2000 in option list ) and no problem occur in progress exported, but when i tried to open those exported file, message occured with message error, in sum total, but i didnt used any formula for summerize, i created report just for displaying data, i didn’t create any formula. but the error message like above. i admit that each field with type string, i setted can grow the height automatically. and why a record that adjust automatically grow in height, is not in one row in excell but write on the second row or later. please advice for anyone who had same expriented and has solved it. any advice will be appreciate.
January 19th, 2009 at 7:54 am
anyone that can help me directly, can mail directly to benny.acolyte@yahoo.co.id
really appreciate the help.
Warms Regards
Benny
January 19th, 2009 at 7:59 am
Revised : vb6 + cr 9 + mysql ( sometime i use other database,
)
March 9th, 2009 at 11:15 am
hi please send tutorials on this project using vb.net and mysql.
May 13th, 2009 at 6:23 am
selain ODBC koneksi untuk Mysql ke VB apa lagi??
May 13th, 2009 at 6:25 am
for connetction mysql to visual basic??but not ODBC? URL?
June 3rd, 2009 at 3:35 am
hi~~
use vb6
SQL = “Select * from hi_danji where user_id = ‘” & txtId & “‘”
Set pRs1 = gCnn.Execute(SQL)
If pRs1.EOF() Then
pRs1.AddNew
pRs1.Fields(“user_id”) = txtId.Text
pRs1.Fields(“user_city”) = cCity.ListIndex
pRs1.Fields(“user_area”) = cArea.ListIndex
pRs1.Fields(“user_danji”) = cDanji.ListIndex
pRs1.Fields(“user_sangsa”) = cSangsa.Text
pRs1.Update
end if
rumtime error : 40003
Server Error Detected.
Number : 1064
Description : You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near
check up please….
June 3rd, 2009 at 8:37 pm
Sir,
I’m almost giving up about saving Binary data in a mysql field from .Net environment. The major problem is that I can’t concatenate the binary variable with other strings in the INSERT query. Please, I would like you to forward anything that can help me out. I’m already in a loop, help me out please.
July 20th, 2009 at 1:56 am
I always read your amazing website every week, its great fun and got lots of interesting information to take in and lots of interesting articles.
August 18th, 2009 at 1:08 am
Hi. I keep getting the file not found error. Every time i try to run the sample programs provided or any of my own projects, i get the error 53: File not found: libmysql. ALthough the file libmysql.dll is right there beside vbmysqldirect.dll. I even tried putting them into system32 folder. Tried registering them (didnt register). I dont know what is up! and libmysql doesnt reference into vb either.
SOme info: using mysql server (Version 5.1.37) with xampplite
Please helppp!!
Thanks in advance
-Roman
September 7th, 2009 at 4:02 pm
Pictures, Thumbprints and any other binaries can now be saved remotely and locally now with ANY language + mysql or mssql. Want to know how???
September 9th, 2009 at 5:16 am
Subair Ayobami,
Sure… show us please. TIA.
October 22nd, 2009 at 2:26 pm
Discuss proper etiquette and social graces. ,
October 23rd, 2009 at 12:29 pm
I hope you know why us mere mortal men are unable to accomplish this feat. ,
November 6th, 2009 at 10:07 am
I would like to reduce coding process by adding MySQL database into the my project using “Add New Data Source” wizard. This method ease data-binding task to controls and etc. I encounter an error saying “failed to create relation” at the end of the wizard. However, the Data Source is created and ready for use. Any idea what is happening?
January 27th, 2010 at 8:08 am
help me plizzz…..
How to send MySQL Command Line Client from VB6 ??
thanxz
April 12th, 2010 at 1:54 pm
please send to me coding for connecting vb 6.0 with mysql. else …..
April 15th, 2010 at 2:26 am
Hai…
I am not very good in vb also mysql, but I am very concern regarding application speed mostly on displaying data.
I just wonder by this method, how many user can access in same time?
Do I need to set up anything on server like concurrent user accessing database, expendable bandwidth size or elsewhere?
Please let guide me regarding this matter…
May 14th, 2010 at 1:35 pm
Hi Mike,
Alas, vbmysqldirect.zip appears corrupt. VBMySQLDirect_Setup.exe cannot be extracted, although it seems all other files are. I’ve downloaded the file twice, so I doubt it’s corrupted in transit.
Regards,
July 16th, 2010 at 3:25 pm
hi, can you pls. help me do my project, it was a video rental system, i’m using vb.net 2008 and mysql, what are the codes to edit, save and update? and also, if i click search by, there are names that will appear on the data grid view? hope you will help me.. PM me pls. tnx
August 6th, 2010 at 9:48 am
hey, guys anybody can help me out. i need a vb6 project for sales and service which is using “my sql” has back end and vb has front end.
please send me the link to download this project. here is my Email id : http://www.may9_waghith@yahoo.com