Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BDE Error: Lock time out.SQL Server Connection timed out error

665 views
Skip to first unread message

Prasanna

unread,
Jan 26, 2004, 3:25:42 AM1/26/04
to
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.........

Kevin Frevert

unread,
Jan 26, 2004, 6:14:22 AM1/26/04
to
Prasanna,

The BDE connection timeout can be set by:
(In the BDE Admin)
Configuration tab->Drivers->Native->MSSQL->Connect Timeout

With that, I'd recommend upgrading to D7 (or at least D6). Borland has
depreciated the BDE SQL Links (and Microsoft has depreciated it's DBLib,
which the BDE uses) so the newer features of MSSQL 2000 will not be
available. Microsoft recommends using OLE-DB/ADO/ADO.Net

http://community.borland.com/article/0,1410,28688,00.html
http://community.borland.com/article/0,1410,10359,00.html
http://community.borland.com/article/0,1410,19694,00.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;260817


Good luck,
krf

"Prasanna" <prasanna....@sg.royalsun.com> wrote in message
news:4014dd16$1...@newsgroups.borland.com...

Walter Prins

unread,
Jan 28, 2004, 6:49:18 PM1/28/04
to

"Prasanna" <prasanna....@sg.royalsun.com> wrote in message
news:4014dd16$1...@newsgroups.borland.com...
> 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.

Just a silly hunch based on some strange behaviour I've 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 (http://www.grisoft.com).
Version: 6.0.563 / Virus Database: 355 - Release Date: 17/01/2004


George

unread,
Jan 30, 2004, 10:45:15 AM1/30/04
to
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" <wprins.not...@ananzi.co.za> wrote in message news:<40184a89$1...@newsgroups.borland.com>...

0 new messages