Hi,

-Microsoft Analysis server was installed by local machine
administrator account in win2k server. Our warehouse is in Oracle8i
and trying to use Analysis server to connect through ODBC and create
cubes...
-OLAP_Administrators group was automatically created by Analysis
server and I added my NT domain user (xyz) to it apart from the local
Administrator to access from remote machine.
- First there was permission problem with the data folder access while
saving the cube and we gave permissions for the OLAP_Administrators
group to read execute and modify the data folder of Analysis server.
This solved this issue.

PROBLEM::
- When using data source, the problem is:
- When Microsoft OLE DB Provider for Oracle is used as new data source
and connection is Tested, it gives "An error in initializing provider.
Oracle error occured but error message could not be retrieved from
Oracle". Also obviously it does not process the cube.

Actually we checked location of the dll for this provider is there and
it is in WINNT/system32 folder and gave read and execute permission to
OLAP_ADMINISTRATORS group for these folders and also to the provider
files.
Still getting the error.
(Note: When using Oracle Provider for OLE DB through DSN creation and
using this DSN through Microsoft OLE DB Provider for ODBC Drivers, it
connects and able to create cube. Through DSN route also Microsoft OLE
DB Provider for Oracle gives the same error. All the oracle folders
have permission for OLAP_Administrators group.).

Question::: Is there any specific permission(s) that need to be
enabled in the windows system for any file/folder to have Microsoft
OLE DB Provider for Oracle working? Or is there anything that needs to
be done to have this work?
(When it was installed on another windows 2k professional machine,
Microsoft OLE DB Provider for Oracle worked and Microsoft OLE DB
Provider for Oracle is very very slow so in server we need Microsoft
OLE DB Provider for Oracle.) Please help.

In the windows professional 2k system, the user was having
adminstrative rights to install but was domain user. In windows server
2k system the user was having administrative rights but was the local
server user and not a domain user. Does this make a difference and
anthing to be done with this? Please help...

Thanks & Regards
Prakash

Hi,

Try REGSVR32 to manually register MSDAORA.DLL..

Also check:

PRB: MDAC 2.5 and Oracle8i Connectivity Issue [oledb]
ID: Q264012
http://support.microsoft.com/default...b;en-us;264012

You got some information to work in there and it will direct you to other
articles that can help you with this.

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."