OleDbException exception native error in multithreading

  • Thread starter Thread starter gdesai
  • Start date Start date
G

gdesai

OleDbException: c#
I have stored procedure, which raises exception.
In normal connection, OleDbException returns exact error
in ex.Errors[0].NativeError. But when I star6t my
connection in multithreading environment it returns
{System.Data.OleDb.OleDbException}
System.Runtime.InteropServices.ExternalException:
{System.Data.OleDb.OleDbException}
oledbErrors: {System.Data.OleDb.OleDbErrorCollection}
message: "No error information available: E_FAIL
(0x80004005)."
source: null
ErrorCode: -2147467259
Errors: {System.Data.OleDb.OleDbErrorCollection}
Message: "No error information available: E_FAIL
(0x80004005)."
Source: ""


There is no Errors collection available in exception
object.

If I do not start collection in multithreading
envirognment I get exact error in
ex.Errors[0].NativeError.

It is very important for me to get exact error from store
procedure.
Can anyone help.

gdesai
 
Some questions:

1. Have you narrowed down this problem to the stored procedure or the code
line?

2. To trace the error in multiple-thread environment, you can create a log
file to trace the behavior for every thread. Then you could find the root
reason according to the log file.


Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| Content-Class: urn:content-classes:message
| From: "gdesai" <[email protected]>
| Sender: "gdesai" <[email protected]>
| Subject: OleDbException exception native error in multithreading
| Date: Mon, 8 Sep 2003 09:51:11 -0700
| Lines: 32
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcN2KWhLReqBhBxDSnOY8vfqIZ9sEQ==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:60544
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| OleDbException: c#
| I have stored procedure, which raises exception.
| In normal connection, OleDbException returns exact error
| in ex.Errors[0].NativeError. But when I star6t my
| connection in multithreading environment it returns
| {System.Data.OleDb.OleDbException}
| System.Runtime.InteropServices.ExternalException:
| {System.Data.OleDb.OleDbException}
| oledbErrors: {System.Data.OleDb.OleDbErrorCollection}
| message: "No error information available: E_FAIL
| (0x80004005)."
| source: null
| ErrorCode: -2147467259
| Errors: {System.Data.OleDb.OleDbErrorCollection}
| Message: "No error information available: E_FAIL
| (0x80004005)."
| Source: ""
|
|
| There is no Errors collection available in exception
| object.
|
| If I do not start collection in multithreading
| envirognment I get exact error in
| ex.Errors[0].NativeError.
|
| It is very important for me to get exact error from store
| procedure.
| Can anyone help.
|
| gdesai
|
|
 
It seems the OLEDB exception error has been fixed in Framework version
1.1. Because when i deployed application on PC where Framework 1.1 was
installed it worked fne. It was not working OK with Framework 1.0.
Thanks for the response.

gdesai
 
Back
Top