
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