?
Solved

Multiple-step OLE DB operation generated errors

Posted on 2004-03-22
7
Medium Priority
?
2,702 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 2000 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
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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

764 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