Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add data to MySql table using VB

Status
Not open for further replies.

rw73

Programmer
Feb 21, 2002
10
US
I am using Mysql tables to store data that is entered through a Visual Basics interface program. When adding new records to a table the first record in the table is accepted fine, however, any subsequent data that I enter must only contain the same number of or less characters in each field as the first record entered. An example is if I enter a customer name for the first record that is 15 characters long, from that point on only customer names of 15 characters or less are accepted. If I enter data longer than the first record I receive the following error message:

Run-time error '-2157217887 (80040e21): Multiple-step operation generated errors. Check each status value.

I am connecting to MySql with no DSN. Any help will be greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top