dbTalk Databases Forums  

Usage-Based Optimization Wizard FAILURE

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Usage-Based Optimization Wizard FAILURE in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Guus Kramer
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.