Hi,

We have a SQL 2000 cluster server. We need to run a query
on an access database. We have set up a linked server,
however we always get the error;

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
error.
[OLE/DB provider returned message: Cannot open
database ''. It may not be a database that your
application recognizes, or the file may be corrupt.]


This setup always worked before we changed to clustered
servers. Does anyone know a way around this?

Thanks.

Does the SQL service account have access to the underlying file? Is the
file accessable from a UNC share that appears the same to all host nodes?

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"PC" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I have checked the permissions on the c:\winnt and
c:\winnt\temp folders and the SQL Server service account
has Full Control over these.

Storing user files in the winnt folder or subfolders is a bad idea all by
itself.

When you have a clustered instance, you need to make sure that the file is
accessable to the SQL instance no matter which node is currently hosting it.
If the file is on Host1 and the SQL instance is running on Host2, the SQL
instance will see only the disks on Host2.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"PC" <anonymous (AT) discussions (DOT) microsoft.com> wrote