VB5, RDO & SQL Server Timeout Expired Error 
Author Message
 VB5, RDO & SQL Server Timeout Expired Error

I am currently using VB5, SQL Server 6.5 Developer Edition and RDO on a
Windows NT Workstation.  I am able to perform an UPDATE properly,
however, when I try to execute an INSERT or DELETE statement, using the
following sample code:

'=======================================================
cn.Connect = "DSN=ESS;UID=TEST;PWD=TEST;DATABASE=ESS;"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection rdDriverNoPrompt

Set qd.ActiveConnection = cn
qd.QueryTimeout = 60
qd.SQL = "DELETE FROM applicationUser WHERE applicationUserId = 8"
qd.Execute rdExecDirect
'=======================================================

I get the following error:

    S1T00: [Microsoft][ODBC SQL Server Driver]Timeout expired.

Does anyone have any suggestions?  Your help in this matter is greatly
appreciated.

Kelly Coen



Sat, 25 Mar 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Timeout Expired Error With SQL server ODBC

2. Timeout Expired Error With SQL server ODBC

3. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ?????????

4. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ????

5. Timeout expired, [Microsoft OLE DB Provider for SQL Server]

6. [ODBC SQL Server Driver]Timeout Expired

7. ODBC SQL Server Driver Timeout Expired

8. VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes

9. ODBC SQL Server Driver Timeout expired

10. [ODBC SQL Server Driver]Timeout expired

11. HELP!! RDO Timeout to SQL Server

12. HELP RDO Timeout to SQL Server

 

 
Powered by phpBB® Forum Software