Cluster Issue w/ Jet 4.0 error

[JayKusch]

Afternoon Folk ...

Have an Active/Active cluster of SS2K (SP3) on Windows 2003 server.

I have an SP that runs great on one node of the cluster BUT FAILS on the other node of the cluster.

So in all the DBs (over 50) on NodeA the SP runs and returns the result set. On NodeB , in all the DBs (over 40), the EXACT SAME SP failes with the following error:


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


Where should I start to look?

Where do I find where the 'Microsoft.Jet.OLEDB.4.0 is loaded?

Thanks ALL!

Thanks

J. Kusch

 

[mrdenny]

Jay,
What is the procedure trying to do while when it's erroring out?

What happens if you fail the virtual worlds over to the other node? Does it still run on the same physical node only?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com