Re: How to get ODBC the status of connection?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Hairgrove <NoSpamPlease@xxxxxxxx>
Date: Tue, 07 Aug 2007 14:15:19 +0200

On Tue, 07 Aug 2007 00:09:17 -0700, Hooyoo <zhaohuyong@xxxxxxxxx>
wrote:

How can I get the status from the handle of connection? I have
initialized a connection at the beginning, but I need know whether the
connection is still established when I execute a sql statement. Is
there such kind of ODBC API?

For ODBC ver. 3.5, you can call SQLGetConnectAttr() with the argument
SQL_ATTR_CONNECTION_DEAD (see the "ODBC Programmer's Reference" for
details on how to call this function). I'm not aware of how this is
done in earlier ODBC versions; presumably you would just trap the
error which occurs when the SQL statement is prepared or executed.

If the handle itself is invalid, the call to SQLGetConnectAttr
returns SQL_INVALID_HANDLE.

--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.

Follow-Ups:
- Re: How to get ODBC the status of connection?
  - From: Hooyoo
- Re: How to get ODBC the status of connection?
  - From: Hooyoo

References:
- How to get ODBC the status of connection?
  - From: Hooyoo

Prev by Date: How to get ODBC the status of connection?
Next by Date: Re: How to get ODBC the status of connection?
Previous by thread: How to get ODBC the status of connection?
Next by thread: Re: How to get ODBC the status of connection?
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Server 2000 (Application) Role accessed through ADO.NET
... >> The database role claims to answer my ... >> through the Connection Object of ADO.NET ... Then I execute the SQL statement passed to the method ...
(microsoft.public.sqlserver.security)
Re: SQL Server 2000 (Application) Role accessed through ADO.NET
... > The database role claims to answer my ... I establish the connection to the database ... I execute sp_setapprole stored procedure (providing the ... Then I execute the SQL statement passed to the method ...
(microsoft.public.sqlserver.security)
SQL Server 2000 (Application) Role accessed through ADO.NET
... All I had to do was put "Pooling=False" in my connection ... Now with this I am able to execute N number of SQL ... >The database role claims to answer my ... Then I execute the SQL statement passed to the method ...
(microsoft.public.sqlserver.security)
Re: How to get ODBC the status of connection?
... connection is still established when I execute a sql statement. ... For ODBC ver. ... error which occurs when the SQL statement is prepared or executed. ...
(microsoft.public.data.odbc)
Re: How to get ODBC the status of connection?
... connection is still established when I execute a sql statement. ... For ODBC ver. ... error which occurs when the SQL statement is prepared or executed. ...
(microsoft.public.data.odbc)