BorlandTalk.com

Kjell Rilbe · Guest

Hi,

The error above occurs at the same place (record 1993 or 1994) in a
batch-like job every time it runs.

The batch job reads from a readonly forward only ADOQuery and uses that
data to assemble a value that's put into specific records in another
table using an ADOCommand like this:

update "TheTable"
set "TheField"=:Value
where "Id"=:Id

It's when this query executes that the error occurs. The complete error
message shown is:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied

And the ADOConnection's NativeError = 17 (for Errors[0], which is the
only entry in that collection).

The strange thing is that the error did NOT occur when I inserted a
Sleep(100) between each execution of the update query. Next attempt,
with 10 ms, failed as usual, in the same place (record 1993-1994).

I've tried changing the connection and command timeouts but the error
still occurs at record 1993-1994.

All of this happens only when I run it on our hosted dedicated (web)
server. If I run it at my own computer it always works fine.

The hosted computer runs Windows 2003 Web and IIS6 in IIS5 isolation
mode (involved but I don't think it's got anything to do with the
problem). The DB is located on a different machine, not sure what OS but
probably Windows 2000 Server. The DB is a SQL Server 2000.

My own computer runs Windows 2000 Pro and IIS5. The DB is still a SQL
Server 2000 (developer edition) and runs on the same machine as the
application.

I'm using D7 with ADO and Bold, although this part of the code doesn't
involve any Bold stuff - it's regular Delphi/ADO code.

Any ideas?

Thanks,
Kjell
--
---------------------------------------------------------------------------
Kjell Rilbe
Home: +46 8 7610734
Cell: +46 733 442464
---------------------------------------------------------------------------
"If there's a price for bein' me, that's one I'll have to pay"
Aaron Tippin
---------------------------------------------------------------------------