Getting ConnectionRead(Recv() Error on connect to an SQL Server DB
Posted on 2004-10-04
Our MS SQLServer 2000 database exists on our web hosting companies server. We've got a few Delphi programs that connect using the following connection string. We have suddenly begin getting the error
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead(recv()
whenever we run programs. It sems to fail opening a certain table. The table contains roughtly the same number of records each week, about 1000.
Nothing has changed as far as I know, and we get it running from two different locations with different firewalls, OS configurations, etc.
Can anyone tell me why we get this and how to resolve it? And how I look at the SQL Server log on the server?
'Provider=MSDASQL.1;Password=fishing;Persist Security Info=True;'+
'User ID=microtech;Data Source=MTCDataWeb;Mode=ReadWrite;'+
'Extended Properties="DSN=MTCDataWeb;Description=test connection;'+
where WeekEndingDate between :WE_Date_Start and :WE_Date_End
order by WeekEndingDate ,