FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Dan Mohn wrote:
> On Thu, 2007-04-26 at 08:28 -0400, James K. Lowden wrote:
> 
> > According to the ODBC standard,
> > 
> > 1.  Does an ODCBC connection handle need a timeout? 
> > 2.  Is it OK to set a statement timeout before the connection is
> > established? 
> > 3.  Under what conditions does the timeout revert to its default? 
> > 
> > --jkl
> 
> I spent a few hours search, but I wasn't able to find any standards
> documents, apart from references to an "industry standard".  Could you
> point me in the right direction where I might find the "standard"?

Oh, that's very unfair of me.  ODBC isn't a free standard:

http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34134&ICS1=35&ICS2=60&ICS3=&scopelist=

I always rely on Microsoft's pages:

http://msdn2.microsoft.com/en-us/library/ms714177.aspx

and sometimes I look at IBM's description:

http://publib.boulder.ibm.com/infocenter/iisclzos/v9r1/index.jsp?topic=/com.ibm.websphere.ii.federation.classic.clientsref.doc/reference/iiyfcodbcrefodbccli.html

HTH.  And thanks.  

--jkl