May 18th, 2005, 09:47 AM
|
|
Registered User
|
|
Join Date: May 2005
Posts: 1
Time spent in forums: 20 m 57 sec
Reputation Power: 0
|
|
|
Decision Support Objects problem
Hello
I've written a program that uses DSO to connect to a MS-OLAP database. Everything works fine on my development server, but it doesn't on my test server.
When running the following test code:
DSO.Server oServer = new DSO.Server();
oServer.Connect("fooserver");
System.Diagnostics.Debug.WriteLine(oServer.Version );
oServer.CloseServer();
caught in a try/catch block, i get the following exception:
System.Runtime.InteropServices.COMException (0x80040033): Cannot connect to the repository.
Analysis server: fooserver
Error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
at DSO.ServerClass.Connect(String ServerName)
at WindowsApplication1.Form2.button1_Click(Object sender, EventArgs e) in d:\foo\windowsapplication1\form2.cs:line 109
The user that is trying to connect is part of the OLAP administrators group on the server and has the rights on the msdbrep database(which is referenced in the analysis server repository connection string). Using ADOMD i can connect, but i need to do it with DSO.
Mine is just one of many project running on this test server so reinstallation is not an option.
I would greatly appreciate any help or advice.
Thanks
Shorty
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
