Solved

Multiple-step OLE DB operation generated errors

Posted on 2004-03-22
7
2,681 Views
Last Modified: 2007-12-19
I am getting error below when I try to pass an Order number(SDDOCO) field to my ASp page for view. any ideas how to work around this issue? I rerefence the aricle andthe Registry entry is there for SQLOLEDB which is waht I am using sql server 7. thouhgts??


Database Results Error
Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Number: -2147217887 (0x80040E21)
Source: Microsoft OLE DB Provider for ODBC Drivers
0
Comment
Question by:timokeeffe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 2

Accepted Solution

by:
lschweer earned 500 total points
ID: 10651745
Can you post the code you use? this could be of some help

Lars
0
 

Author Comment

by:timokeeffe
ID: 10651785
sure it is used in the custom query section iof the Frontapage DRW:


SELECT * FROM Open_Brasw WHERE SDDOCO =  ::SDDOCO::
ORDER BY SDTRDJ_GR DESC
0
 
LVL 13

Expert Comment

by:danblake
ID: 10653576
How does the query perform is written as:

SELECT * FROM Open_Brasw WHERE SDDOCO =  'SDDOCO'
ORDER BY SDTRDJ_GR DESC

?
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 10654729
Please maintain your many old open questions.  For the record:
1 11/06/2003 500 Julian Date Coversion  Open Microsoft FrontPage
2 11/10/2003 500 Julian Date Conversion - DB2 Export -> S...  Open Mysql
3 11/12/2003 500 NULL Table Values Not Displaying  Open Microsoft FrontPage
4 12/10/2003 500 Lgoin Security Issue  Open Active Server Pages (ASP)
5 03/08/2004 500 Convert Data Type from Numeric to Nchar  Open Microsoft SQL Server
6 03/19/2004 500 Major DB Error  Open Microsoft Access
7 03/22/2004 500 Security Filter at DB Level using OR sta...  Open Microsoft SQL Server
8 03/22/2004 500 Multiple-step OLE DB operation generated...  Open Microsoft SQL Server
9 09/18/2003 500 File System Object  Open Active Server Pages (ASP)
0
 

Expert Comment

by:camisade
ID: 10908590
I'd love to be able to figure this one out, too. Using MySQL, we began seeing this error after installing the latest MyODBS drivers and updating to the l4.0.16 version of MySQL anytime we queried a record and tried to check a value of a TEXT (clob) field that was empty.

Damned frustrating.
0
 

Expert Comment

by:v_raajkumar
ID: 10986848
The problem might be with the DSN set up. I had a similar issue and the problem was traced back to the DSN entry. The driver was set up as "Oracle Driver for Oracle 9i". Once it was changed to "Microsoft ODBC for Oracle", the application started working fine.
0
 

Expert Comment

by:camisade
ID: 10987312
This problem was solved by us (using ASP with MySQL) by updating our Miscrosoft Data Access Components (MDAC).  The versions that are installed by default with Windows 2000 will cause these errors. We got them when trying to read a value from a CLOB/TEXT field that was empty after updating to the MyODBC v3.51 from the 2.x version, but I've heard similar stories from people using MS SQL and the MD ODBC drivers.

You can download the Microsoft MDAC latest version (2.8) from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Note, that though this is the latest version, upon installing them you will note two things:
1) Instances causing those Multiple Step OLE DB Errors should go away (they did for us), and
2) You will get an update from the MS update site inviting you to apply a security patch to the MDAC components you just downloaded from the MS site, because they've been updated. :-/
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question