I am using SQL server 2005 Managment Studio connecting to a SQL 2000 server.
The OPENROWSET command will not work. When I use SQL Query Analyzer, the
command works fine.

This is error I recieve from Mgmt Studio:

[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.


PLEASE HELP!!

FredF (FredF (AT) discussions (DOT) microsoft.com) writes:
And you are dead sure you are connecting to the same SQL Server
instance from both Query Analyzer and SQL 2000? Run "SELECT @@servername"
to find out.

I'm not well acquainted with error messages from the Jet provider,
but the message certainly looks like it cannot find the file. So that
would indicate that you connect to different servers.

Or you are simply spelling things differently in the two query windows.
Copy and paste may be a good idea.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx