I have a VB5 application which updates a SQL table every 3mts
based on entries from a dbase table. I am using SQL server 6.5.
The application uses ODBC to connect to the SQL table - it has
a Data source and the connect parameter specifies the connection
parameters. The application comes up with Error 3146 after about
15 mts in some cases and it occurs every 15 mts (Here the application
is running in the same machine as the SQL server). Also, in
another test machine (in a workstation), the error happens every 7 hrs
and finally the program freezes.
Has it got anything to do with the Query getting timedout?
I increased the QueryTimeOut parameter in the SQL Enterprise
Manager /Configuration from 0 (Default) to 2 sec. But it doesn't help.
If I increase the QueryTimeOut property of Databse object, will it
override that of the SQL Server ?
Dim MySQLDB As Database
Dim SQLBuffData As RecordSet
Do while DbaseData.EOF = False
Get the first dbase record
Extract the value of IDSearchBuff from the record
On Error GoTo SQLTableSelect
Set SQLBuffData = MySQLDB.OpenRecordset("SELECT Status, EventNo,
EventStatus, SentDateTime,ConsolEntry FROM OutTransmissions where
ConsolEntry = '" & IDSearchBuff & "'", dbOpenDynaset)
It goes thru this procedure couple of times without any problem initially.
The result set of the query always has one record. (There is only one SQL
record corresponding to a Dbase record)
Can someone help?
Thanks in advance.