
August 26th, 2003, 06:20 PM
|
|
Junior Member
|
|
Join Date: Aug 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Multiple-step OLD DB operation generated errors
I am getting the following error on some machines:
Error = -2147217887
Multiple-step OLD DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error Source = Provider
1) On my Win 2000 development machine, I do not get this error and the routine operates with no errors.
2) On my Win 2000 laptop that I use to transport the program to my (only) beta test site, I get the error. If I run the program from the IDE on the laptop and choose debug from the error message box, the error shows up on different lines of the code at different times.
3) I always get the error at my Win 95 beta test site. The beta test site has been running for over 45 days with many updates.
The database is Jet/Access. I use ADO 2.5, VB6.0(SP5) Version 8988 on both the development machine and the laptop. The routine is an AddNew, assign values to fields, and Update.
I found a possible solution in a previous post in the MySQL forum. Darryl provided the solution that solved that situation. Part of it was: "So I went to the ODBC driver and clicked the 'Don't optimize column width' option. At this point the insertion started working whether the table had data or not." How do I go to my ODBC driver? Is this specific to MySQL?
My connection string is: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPathFile & ";Mode=ReadWrite;Persist Security Info=False"
Any help would be appreciated.
Thanks, John Brown
|