Board index » delphi » BDE Error: Lock time out.SQL Server Connection timed out error

2004-01-26 04:25:42 PM
delphi98
Hi,
Iam using Delphi 3.0, SQL Server 2000.
My application,database are on the same machine which is P4,256 MB.
I tried increasing the Max Query Time to 120000 in BDE Administrator interface. But still my application throws out this eror.
Please help!!!!!!!
Thankx in advance.........
 

Prasanna,
The BDE connection timeout can be set by:
(In the BDE Admin)
Configuration tab->Drivers->Native->MS SQL->Connect Timeout
With that, I would recommend upgrading to Delphi 7 (or at least D6). Borland has
depreciated the BDE SQL Links (and Microsoft has depreciated it is DBLib,
which the BDE uses) so the newer features of MS SQL 2000 will not be
available. Microsoft recommends using OLE-DB/ADO/ADO.Net
community.borland.com/article/0,1410,28688,00.html
community.borland.com/article/0,1410,10359,00.html
community.borland.com/article/0,1410,19694,00.html
support.microsoft.com/default.aspx
Good luck,
krf
"Prasanna" <XXXX@XXXXX.COM>writes

"Prasanna" <XXXX@XXXXX.COM>writes
Just a silly hunch based on some strange behaviour I have seen (Are you using
the SQL 2000 ODBC driver through the BDE? Hmm.) If so, try doing
"Fetchall; Last; First;" straight after opening a query in your application
and see if it helps...
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (www.grisoft.com).
Version: 6.0.563 / Virus Database: 355 - Release Date: 17/01/2004
 

I am using Delphi 6 and DB2 database with dbExpress components NOT THE BDE.
But I get the same Server Connection timed out error. Any help highly aprreciated.
"Walter Prins" <XXXX@XXXXX.COM>writes news:<40184a89$XXXX@XXXXX.COM>...