oops...my fault... I was reading the wrong list when I posted that thanks
----- Original Message -----
From: "Adam Hooper" <adamh@stripped>
To: "'Dean MacIsaac Jr.'" <dmacisaacj@stripped>;
Sent: Tuesday, March 19, 2002 4:28 PM
Subject: RE: mysql and VB issues
> We use a VB app that communicates with MySQL using adodc and it works
> fine -- it has more problems with MSSQL than with MySQL.
> That said, this is the wrong place to ask ;). MyCC is a little app for
> MySQL, not MySQL itself. Perhaps you should send to
> mysql@stripped instead? :)
> Keep working on it, you can do it.
> Adam Hooper
> -----Original Message-----
> From: Dean MacIsaac Jr. [mailto:dmacisaacj@stripped]
> Sent: Tuesday, March 19, 2002 3:52 PM
> To: mycc@stripped
> Subject: mysql and VB issues
> Hi everyone,
> Been a long time since I touched VB, and I'm still learning, so my code
> below may be scary, but I am writing what could turn into a huge project
> using VB and MYSQL DB. I've got them talking to each other, and
> used my program to populate some test fields yesterday. I did get an
> a few times, but now I seem to get one all the time.
> Run-time error '-2147217887 (80040e21)':
> Multiple-step operation generated errors. Check each status value.
> I click debug, it happens on a diff. line occasionally but in each of
> lines above the offending line, the recordset side and the value side
> the same value. On the offending line, the recordset side has a null
> but the variable 'fileloc' has a value of whatever was assigned to it.
> Private Sub cmdSavefile_Click()
> Adodc1.Recordset.Fields("fname") = txtFname.Text
> Adodc1.Recordset.Fields("lname") = txtLname.Text
> Adodc1.Recordset.Fields("email") = txtEmailaddy.Text
> Adodc1.Recordset.Fields("phone") = txtPhonenumber.Text
> Adodc1.Recordset.Fields("imagelocation") = fileloc
> Adodc1.Recordset.Fields("customerid") = txtBarcode.Text
> txtFname.Text = ""
> txtLname.Text = ""
> txtEmailaddy.Text = ""
> txtPhonenumber.Text = ""
> txtBarcode.Text = ""
> imageCheck.Picture = LoadPicture
> I started this email a while ago... I've done some research. My MySQL
> fname field is set to a lenght of 20 if I put in my name, Dean, it works
> fine. If I put in Marge with 5 letters, it errors. I figured maybe it
> putting all the white space in as well and it was totalling over 20
> characters... I bumped fname up to 40, and a 5 character name on up
> on the error. Any help would be greatly appreciated.
> PS I'm posting this same Q. to the VB newsserver.