Hi there,

I've had the same problem and I'm on service pack 3A and it still hasnt got any better!

Rolf

The SAGE software uses a proprietary database. Its pretty old and is based on something called Retreive 4G I think!

We have support through the SAGE reseller but they have not...

Thanks,

I didnt realise the logic would be so similar to VB etc.

Looks simple enough..I'm off to try it thanks again.

Rolf

All the clients are set to TCP. Its also very intermittent. For the vast majority of the time the connections are fine.

Rolf

Its SQL2000 with service pack 3. The ODBC driver is old (3+ years) but its not that that is causing the problem. The old driver is the reason the IIs...

Thanks for all the replies.

So the general opinion is to not force SQL to lock a row but use a flag and attempt to write that flag as;

Update table where...

That last suggestion is neat but unfortunately I have to check first that the bid value has not changed since the initial point that the user started the bid. Tried...

thanks for the replies...looking into an ActiveX script now.

Rolf

Anyone else got any views on this concurrency problem or why I cant get my head round the conception of flagging being any more robust...?

Rolf

Thikning about the flagging method; wont that be just as suceptible to concurrent attempts...? Two users could be setting the flag to locked at the same time, they would both...

isnt that just a more precise way of locking tables...?

Rolf

Thought there might be some issues with locking...in what instances would locking be suitable then..?

Thanks again

Rolf

You can also use ActiveX scripting within a DTS task and use the SPLIT command of VB, like so;

split(YourString, ",")

This will split a string(which in your case is one dimensional)...

I didnt realise that by activescript you meant ActiveX script! Dum really I should have guessed.

Already read that section then dived straight in ann built my VBscript code to read...

Cant find anything much about it in BOL =(.

Will give it a go today. Luckily its not a mission critical job, just something to save someone some time!

Hopefully I am...