stored procedure error reporting...

Article View: borland.public.cppbuilder.database.ado

Article #4312

Back to borland.public.cppbuilder.database.ado Previous Next

#4312

From: Jurko
Date: Wed, 06 Feb 2002 09:10

23 lines
1815 bytes

// this is a repost - as the original mail doesn't seem to appear in my
// news reader ever after one whole day, and other messages I posted
// after it appeared normally...

I have a question on reporting errors from stored procedures.

I know how to look through the ADODB.Connection objects errors
collection and report all the errors written there, however one thing
escapes me...

Is there any way to get the exact stored procedure name and line number
where a particular error occured... I know that the MS-SQL's query
analyzer reports the same errors that I do when I run the query in it but
it also somehow reports the 'exact' location of the error..

I've looked through all the ADODB obect's properties but haven't been
able to find that information.

If anyone knows anything that might help me find it and is willing to
share it I'd be most grateful...

Thank you,
    Jurko

Technical Details

Message-ID: <5nrq3a.83r.ln@news.ve-mil.hr>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!news.ve-mil.hr!nobody

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,77f260d8460f5114,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-02-06 01:30:43 PST
From: "Jurko" <Jurko@ve-mil.hr>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: stored procedure error reporting...
Date: Wed, 6 Feb 2002 10:10:19 +0100
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <5nrq3a.83r.ln@news.ve-mil.hr>
NNTP-Posting-Host: 195.29.221.130
X-Trace: dnews 1012986977 195.29.221.130 (6 Feb 2002 01:16:17 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!news.ve-mil.hr!nobody