>>In VB5, when using OpenConnection to open an ODBC Direct connection, is there any way to tell if a connection is actually open?
>>
>>The problem is that even if the connection is not open, the Connection object is still valid. I couldn't find any property such as "Open" or the such
>>
>>Thx 4 your help!
>
>One way that I figure you could use is to try to open a recordset and then trap if an error occurs. Then, using the error code, you can determine what the error was and if it was related to not having a connection open.
>
>There are most probably other ways, but this is the quickest workaround I know of since there isn't a property or a method that tells you directly if the connection IS open, unless I'm forgetting something.
>
>Hugo Dahl
Jay Shepherd