msde (now known as the sql server 2000 desktop installer) can be installed either integrated into an existing installer (using merge modules) or running a setup.exe with either command line...

You didn't supply the connectstring to your example.  However, to disable connection pooling add the following to your connection string.

OLE DB Services = -2

there are various articles in MSDN that...

put the following into a file of extension .vbs and run

it after changing the tnsname user and password.

dim cn

SET cn = createobject("ADODB.cONNECTION")

cn.open  "Provider=MSDAORA;Data Source=<tns name>","<User>","<pass>"

msgbox "connection...

We upgraded from sp2 to sp3 a few months back without any issues.

I would work back and eliminate possiblities.

See if from the sql server box you can tnsping the box.

then...

What provider are you using?  MSDAORA or the Oracle oledb provider or a third party provider?

Does the OPENROWSET and OPENQUERY command executed through QA give any more info?

Error Code 0x80004005 is unfortunately an unspecified error.

You aren't really very specific about the error?  Does the OPENQUERY command get this error? Does the OPENROWSET command get this error?

the following...

There are a number of issues involved in allow the linked server connection to work as fast as the passthrough (openquery) connection.

1) Make sure that the sql server collation is...

A way to do this without reloading (which enterprise manager does behinds the scenes including constraints) is to add the column, use sp_rename on the table and then create a...

We have code to do that. Its pretty complicated though. In our case all the

client process when they log in hook into the

event sync of a process running...