catching errors [RESOLVED]

[Andy]

what exception should I use to catch "BOF or EOF or record deleted". Pretty much when there is not a row in the db.

I thought of using

catch ex as exception
 'compare ex.message to a literal

but didn't know how efficietnt that would be.

I should probably point out that i'm using ado and not ado.net net for this operation. due to the type of connection i have to use.

[SeanGrebey]

Step through it with the debugger, put a break point in the generic exception, and see what exception it throws when there are no rows. Out of curiosity, why aren't you just handling if MyRecordSet.EOF = true in code instead of waiting for an exception to be thrown?

[salvelinus]

It's probably something like System.NullDB.Exception (just a guess, don't have vb here). The help file could probably tell you. Or, for fun, write your own exception class.

[Edneeis]

What connection trouble makes you use ADODB? Also it would be a COMException but all exceptions thrown from ADODB are of type COMException so you should Check IndexOf("BOF")>-1 to see if its a BOF error.

[Andy]

Originally posted by Edneeis
What connection trouble makes you use ADODB? Also it would be a COMException but all exceptions thrown from ADODB are of type COMException so you should Check IndexOf("BOF")>-1 to see if its a BOF error.

well, i could be going about it the wrong way but i'm connecting to MySQL and using an ip address in my connection string. is it possible to connect like that with ado.net and use a reader? that would be great

for reference, here is the connection string i'm using:

Public Const AdslConnStr As String = "Provider=MSDASQL.1;Persist Security Info=False; Extended Properties=" & _
                                         "DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=co;" & _
                                         "SERVER=192.168.8.50;UID=root;PASSWORD=;PORT=;OPTION=;STMT=;"

[Pirate]

If you're using ODBC class , then use Odbc.OdbcException method to handle any error returned from the ODBC datasource .
As for the reader obj , you have also ODBC reader obj , you can use it .