Multiple-step OLE DB operation generated errors. 1

[gwillr]

I have a form that uses .asp and vbscript to submit the results, (name, email, filename) to a database.

I am having a problem with the email field, in that if i have someemail@domain.com , the information submits correctly, and all is well. -BUT- If i have someemail99@domain.com (numbers in the email address next to the '@') i get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/folder/folder/file.asp, line 27


what could be causing this error to occur by simply having numbers in the email? (I have another form that is similar {same thing, but without the filename field} that works just fine with the email address field)

Gary

http://www.robarspages.ca

 

[tsuji]

gwillr,

Check out this bug and measures for resolution:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294160

regards - tsuji

 

[gwillr]

Thanks Tsuji, for the insight. Your reference to the bug page pointed me in the right direction. Turns out that this error can also occur when the character length of the Access DB field is not as long as the length of the input form.

Gary

http://www.robarspages.ca