Usage-Based Optimization Wizard FAILURE -
05-08-2006
, 08:54 AM
Hi,
First how things are set up;
A) Local installed Analysis manager ( with one local envirionment set up for
testing purposses) - XP client ( my PC )
B) 3 servers which have OLAP (and it's latest SPs) installed.- SQL server 2000
The problem we encounter;
Using the UBOW on the local environment works fine but NOT on one of the
registered servers.
it pops up with the next error;
Details: <blanc>
Error Number ; -2147467259
Error desc : Can not use ....The file is in use.
Error Source : MS JET Database Engine
The Connection strings
Local;
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft
Analysis Services\Bin\msmdrep.mdb
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\DAFEHVL05624\MsOLAPRepository$\msmdrep.md b
Server;
Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=msmdqlog;Data
Source=dafehvosql2;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=DAFEHVL05624;Use Encryption for Data=False;Tag with
column collation when possible=False
Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=msmdqlog;Data
Source=dafehvosql2;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=DAFEHVL05624;Use Encryption for Data=False;Tag with
column collation when possible=False
The registery has been setup for the local environment.
Why oes it prompt an error on the JET Engine while it is configured for the
SQLOLEDB ??
Please help me out on this. ( hand how to handle to correct it )
GKramer
The Netherlands |