connection timeout

I forgot to mention, that I tried to use SET LOGINTIME:
EXEC SQL SET OPTION LOGINTIME 60;
EXEC SQL CONNECT TO :db_str AS :db_user
But it still interrupts after 10 sec (default value).
Nikolai.

quote:

---

>--Original Message--
>Our application uses Embedded SQL for C to connect to
>MSSQL:
>EXEC SQL CONNECT TO :db_str AS :db_user
>The application runs on the same system as MSSQL server.
>The customer complains that if their server is busy, then
>the application can not connect to the server.
>Questions:
>How to increase connection timeout using Embedded SQL for
>C?
>Is it possible to change connection timeout for local
>connections on a MSSQL (e.g. using SQL Server Enterprise
>Manager)?
>.
>

---

Try logintimeout instead of logintime.
Note this warning from BOL:
While the Embedded SQL for C API is still supported in Microsoft SQL Server
2000, no future versions of SQL Server will include the files needed to do
programming work on applications that use this API. Connections from
existing applications written using Embedded SQL for C will still be
supported in the next version of SQL Server, but this support will also be
dropped in a future release. When writing new applications, avoid using
Embedded SQL for C. When modifying existing applications, you are strongly
encouraged to remove dependencies on Embedded SQL for C. Instead of
Embedded SQL for C, you can use Microsoft ActiveX Data Objects (ADO), OLE
DB, or ODBC to access data in SQL Server.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.