VB/MySQL.com

Please send to me article mysql

Ok for vbmysqldirect

Great dev!!! waiting for more tutorials and updates.

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”)

sir, I want to join your forum.

Help me further

Thank you

renga

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

To raja:

Revise your mysql parameters…

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.

nice work. any more development?

i found this site very useful for my mysql database system… keep up the good work bro. we are waiting for more development.

hi,,,,, can i ask about connecting the mysql to visual basic 6.0??? thank you

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!

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

how can i join sir?

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.

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.

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).

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

this project is very very super. i like that………. thkx for the publisher bye……… SaRu

Hi. great work. need clarity on whether vb and SQL server can be connected

can vbmysqldirect connect with vb6 datagrid ?????

like set datagrid1.datasource = rs

then error prompt out

run time error 13

type mis match

thanks.i will try this.

thanks. i will also try this… god bless!

guys can you give me a program about the user account system? or some link about this program? tnx

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.

I’ll do a testing on vb6+mysql+wine on opensuse and slax.

y vbmysqldirect cannot bind datagrid with mysql.
anyone can help me
pls……………..

sir, will you please teach me to make a search engine using visual basic and mysql?

What is the code for connecting VB 2005 to My SQL 4.1

Hi everybody

I need a small project to lean Vb with Mysql database

Thanks

Jothimani

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?

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.

anyone that can help me directly, can mail directly to benny.acolyte@yahoo.co.id
really appreciate the help.

Warms Regards

Benny

Revised : vb6 + cr 9 + mysql ( sometime i use other database, )

hi please send tutorials on this project using vb.net and mysql.

selain ODBC koneksi untuk Mysql ke VB apa lagi??

for connetction mysql to visual basic??but not ODBC? URL?

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….

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.

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.

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

Pictures, Thumbprints and any other binaries can now be saved remotely and locally now with ANY language + mysql or mssql. Want to know how???

Subair Ayobami,

Sure… show us please. TIA.

Discuss proper etiquette and social graces. ,

I hope you know why us mere mortal men are unable to accomplish this feat. ,

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?

help me plizzz…..
How to send MySQL Command Line Client from VB6 ??
thanxz

please send to me coding for connecting vb 6.0 with mysql. else …..

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…

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,

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

Hope new version !!!!

How to call Store Procedure in mysql with mySQLDirect (Tabel Source Contains Fields Picture)