BorlandTalk.com

Jeff Butterworth · Guest

I had asked this question in the bde newsgroup but wa told to try here.

I am using BDE to SQL Server 2000. It seems that when I run a select query
and
there is a lock, it just sits there waiting for the lock to be release and
eventually it will time out. Is there any setting I can make on the BDE to
force SQL Server not to wait and raise an error immediately, sort of like
the NOWAIT
in the Interbase SQL Links?

Please don't tell me not to use the BDE, that's its been depricated etc. I
know all that. We are using Corelab's SDAC for our newer apps but haven't
had time to convert them all so some of the programs are still using the
BDE. I just wait an answer to the question I asked.

Thanks

Jeff

Kevin Frevert · Guest

Jeff,

You can try the READPAST query optimizer hint (see Books Online for the
complete list of optimizer hints)

Select
C.CustNum, C.FirstName, C.LastName
From
dbo.Customers C (READPAST)
Where
{what ever}

Good luck,
krf

"Jeff Butterworth" <jefbut (AT) drs (DOT) com.au> wrote

Jeff Butterworth · Guest

Wasn't quite what I was after but it is an interesting possibility.

I think its actually the @@LOCK_TIMEOUT variable in SQL Server that I really
need to adjust.

Jeff

"Kevin Frevert" <Work (AT) drinkingcoffee (DOT) com> wrote

Kevin Frevert · Guest

Jeff,

Another option is in the BDE Admin
- Select the Configuration tab, expand off the Configuration tree until you
get to :
Configuration->Drivers->Native->MSSQL
- On the Right-hand side of the BDE Administrator, select the TimeOut , set
the value to 0 (wait forever)

Good luck,
krf

"Jeff Butterworth" <jefbut (AT) drs (DOT) com.au> wrote