Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
  #1  
Old August 26th, 2003, 06:20 PM
johnbrown johnbrown is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 2 johnbrown User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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

Reply With Quote
  #2  
Old August 26th, 2003, 07:03 PM
Doug G Doug G is offline
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
 
Join Date: Jun 2003
Posts: 10,713 Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level)Doug G User rank is Brigadier General (60000 - 70000 Reputation Level) 
Time spent in forums: 4 Weeks 1 Day 23 h 57 m 59 sec
Reputation Power: 688
There are a couple links to MS troubleshooting ADO errors here.

http://www.dougscode.com/forum4/topic.asp?TOPIC_ID=6

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Multiple-step OLD DB operation generated errors


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway