OLE error code:80004005

[anjanid]

Hi all,
Iam trying to insert data into sqlserver 2000 from different more than 100 Machines but inbetween iam getting error as :

OLE error code:80004005
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied.


Please help

Regards,

Anjanid.

[Hack]

Welcome to DevX

Does this happen right from the very start, or is it occuring down the road in the process? In other words, do some of the machines data get inserted an others don't?

Are all 100 machines doing this insert at the same time?

[anjanid]

Yes for some of the machines it inserts data and for some of the machines it doesnot.All the 100 machines tries to insert data at the same time.


Please help.


Anjani

[Hack]

All the 100 machines tries to insert data at the same time.

Can you stagger the insert so it doesn't happen all at once?