this may be an OLEDB error :

did you check http://discuss.develop.com/archives/wa.exe?A2=ind0012&L=oledb_dev&T=0&P=165

1) oracle uses versioning, whilst sqlserver uses locking.

    Only when updated/deleted, a lock will be placed in Oracle.

2) what kind of isolation level are you using. In many cases read...

check out http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

check out http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

this may solve your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

select datediff(dd,'2006-01-01', getdate()) gives you the number of days.

If you want weekdays(mo-fr) you would have to make your own function like this one :

CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1)...

- was the database detached in a propre way ? (detatchdb ...)

- you may be better off with backup/restore

add startup parameters -T1204 and T3605 to your sqlserver's parameters.

or execute dbcc traceon(1204, 3605, -1)

This way you get deadlockinfo in your sql server logs.

If you fetch/arrange me a ticket too, I'll even wear that tricky colored T-shirt from last year at Dallas

Can you pass me some...

maybe you could try to start sqlserver with minimal configuration using startup parameters from the commandline.

sqlservr.exe -f

check out "sqlservr Application" in books online.

is it running behind a firrewall or in another domain than the client ?

can you see the server in the serverlist when you try to register it in SQLserver management console ?

Did you check case sensitivity ?

If your server is installed case sensitive, .. your userId and password are also case sensitive !

avoid trailing blancs in passwords !

- how are you trying to connect ? Windows authenticated or SQL-authenticated ?

- can you ping the sqlserver ?

Drop / Create will be your only solution.

maybe this script can gat you on track :

set nocount on

print 'Linked Servers voor [' + @@Servername + ']'

print '------------------- ***********'

if not...