• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2723
  • Last Modified:

Multiple-step OLE DB operation generated errors

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
timokeeffe
Asked:
timokeeffe
1 Solution
 
lschweerCommented:
Can you post the code you use? this could be of some help

Lars
0
 
timokeeffeAuthor Commented:
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
 
danblakeCommented:
How does the query perform is written as:

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

?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Anthony PerkinsCommented:
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
 
camisadeCommented:
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
 
v_raajkumarCommented:
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
 
camisadeCommented:
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now