MySQL + VB6

hiya fellas..

Does anybody know where i can get step by step Instruction on connecting VB6 application with MYSQL??

I believe this can be done, though i dont know how...
I also found out that it uses ADO..
(correct me if im wrong)

if anybody know...
please let me err.. know..

thanks in advanced...

-jassh

I work with a MySQL database that supplies data to an Access 2000 interface... which uses vb.

I used MyODBC 3.51. You can get it from mysql.com. I'm not sure it will work, but it's worth a shot. The only language connectors that I know they have are for C++ and Java. But you could look around their site http://www.mysql.com

thaks froggy.. i have downloaded MyODBC... and have installed it..
and oh.. it support VB6..

it work find in retreiving data..
but.. it always have error when update..

gotta checkout some issue on that..
tell me if u got sum tips/trick..


anyway, thanks... really appreciated it..

take care buddy...
have a nice day

-jassh

Check your mysql logs to see whats going on. I once spent a whole day trying to figure out why i couldn't update from this one form. as it turned out, the user i was connecting as (as specified in the DSN) was only allowed to SELECT data from the database, not INSERT, UPDATE, or DELETE. so i could *see* the data just fine, just couldnt do much with it. sily me.

hi there filefrog

ermm... here's a more specific to my problem..
kinda strange though...

i configured myodbc..
and everything went fine..

so i created a table customer
put some field..
(CustID, CustName, Phone)
and make the CustID primary key...
(coz i read somewhere, u gotta do that..)

then i uses my VB. (VB6 + SP5 running on Win2K)
Create 1 form for view, delete, navigate..
so i start enter data... using:and another form which i can enter new data..
then it'll update the data using

Form1.Adodc1.Recordset.Update

when i enter
CustID 1 to 9, no prob..

but when i enter bigger than 9, 13 for example..
it gives me this error.. :

---------------------------------
Run-time error '-2147217887 (80040e21)':
Multiple-step operation generated error. Check each Status value.
---------------------------------


strange though..
this would happen
even if there's only 2 record in the table..

for instance, the first CustID is 2,
then when i enter the second CustID, 11
Boom... it went error...

I'm puzzled, confused, and err.. blurred
Any idea Froggy??

Or maybe you wanna examine my code>>??

anyway..
thanks for ur kindness and time to help me out..

hope to hear from ya..
take care buddy..
have a nice day..

-jassh

owh.. forgot to mention...

i logged on the Database using root..
err.. superuser.. i guess..

-jassh, again