Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to trap ODBC errors exactly in VB

Status
Not open for further replies.
Rajeswari

Rajeswari

Technical User
Oct 6, 2001
17
IN
I am using stored procedures to insert the data, if stored procedure fails VB gives a common error like &quot;<Stored procedure name> expects parameter &quot;. I want the exact ODBC error which is thrown by database.
 
Sort by date Sort by votes
Your connection whatever it is for example &quot;dcnDB&quot; has a collection called errors or something like that that keeps the Database real error with more description that Visual Basic does.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
212
Ken01
Ken01
Niki_S
  • Locked
  • Question
How to use 2D array in vb 6? 1
Replies
10
Views
231
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to merge two variables into one in VB 6? 1
2
Replies
22
Views
353
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
139
Niki_S
Niki_S
sal21
  • Question
scraping table in web page 3
2
Replies
24
Views
2K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top