Results 1 to 3 of 3

Thread: Trap ODBC Error

  1. Oct 6th, 1999, 04:48 PM #1
    jaypee
    jaypee is offline

    Thread Starter
    New Member
    Join Date
    Jan 1999
    Location
    madras,tn,india
    Posts
    2

    Post

    How to trap ODBC errors. I am using "On error goto last".
    But the error reported by ODBC gives like "S1000" which is an alphanumeric whereas On error is a numeric field. Hence unable to compare . In other words whenever I get ODBC error , it simply (error) flashing on the .
    HOW DO I TRAP IT???
    Reply With Quote Reply With Quote
  2. Oct 7th, 1999, 03:16 PM #2
    velkave
    velkave is offline
    New Member
    Join Date
    May 1999
    Location
    Feltham,Middlesex,United Kingdom
    Posts
    6

    Post

    Think most of the ODBC errors come under a major runtime error like 40002, 3146, 3151 etc. You can trap it using both err.number and err.descrption.

    rgds
    velkave.
    Reply With Quote Reply With Quote
  3. Oct 7th, 1999, 06:24 PM #3
    jaypee
    jaypee is offline

    Thread Starter
    New Member
    Join Date
    Jan 1999
    Location
    madras,tn,india
    Posts
    2

    Post

    thanx for the reply,
    But I am using mysql ODBC which indeed gives me err number as "S1000". You can get ODBC driver at www.mysql.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width