ODBC questions

[Chaitanya Chalasani]

On Sunday 05 February 2006 21:09, Mickael Remond wrote:
> Hello,
>
> I have recently been working a lot with ODBC and Erlang. One problem /
> question remains: Is there any mechanism to detect when the connection
> to the database is lost ? The purpose is to be able to try restarting
> the connection.
> I looked at the ODBC code, but did not find any relevant parts.
> For now, the behaviour seems to be the following: When querying a
> database who went offline, I get an error as the query response. The
> text of the error explains that the database is not more reachable but
> the ODBC process is still there.
>
> I suspect that such reconnection mechanism should be handled by the ODBC
> driver. I have been doing my tests with MySQL.
>
> Does someone here have experienced the same reconnection problem with
> ODBC ?

Yes but not when the connection is lost , when you are trying to query a 
connection which is already broken then an error is shown

-- 
Chaitanya Chalasani