Hi ,

I create a ODBC for SQL Server 2000 and use VB 6 to connect it. When I
pass it the sql query in vb and process the recordset , I am getting an error
"Microsoft ODBC SQL Server Driver Timeout expired". Where can I set the
time out in the ODBC ? TQ.

--
Travis Tan

There is an ODBC API function called SQLSetStmtOption. Call it with option 0, which is
SQL_QUERY_TIMEOUT.

"Travis" <Travis@discussions.microsoft.com> wrote in message
news:7C4F7364-49A8-4BE3-814D-DB04B3487647@microsoft.com...
> Hi ,
>
> I create a ODBC for SQL Server 2000 and use VB 6 to connect it. When I
> pass it the sql query in vb and process the recordset , I am getting an error
> "Microsoft ODBC SQL Server Driver Timeout expired". Where can I set the
> time out in the ODBC ? TQ.
>
> --
> Travis Tan

How can you call the API from within a stored procedure or from Visual Studio
2003.


"Scot T Brennecke" wrote:

> There is an ODBC API function called SQLSetStmtOption. Call it with option 0, which is
> SQL_QUERY_TIMEOUT.
>
> "Travis" <Travis@discussions.microsoft.com> wrote in message
> news:7C4F7364-49A8-4BE3-814D-DB04B3487647@microsoft.com...
> > Hi ,
> >
> > I create a ODBC for SQL Server 2000 and use VB 6 to connect it. When I
> > pass it the sql query in vb and process the recordset , I am getting an error
> > "Microsoft ODBC SQL Server Driver Timeout expired". Where can I set the
> > time out in the ODBC ? TQ.
> >
> > --
> > Travis Tan
>
>
>