Hi,

I'm trying to connect to my SSAS2005 throught ADOMD.net.

I got :
{"A connection cannot be made. Ensure that the server is running."}
and in detail :
{"No such host is known"}

Of course SQL browser and SSAS2005 are started and I can access to my cube
throught SQL Mgt.

My conn. String is :
<add name="MyLocalCube2005" connectionString="Provider=MSOLAP;Cache
Authentication=False;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=Analysis Services Tutorial;Data
Source=.\BILAB;Impersonation
Level=Impersonate;Location=.\BILAB;Mode=ReadWrite; Auto Synch
Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX
Compatibility=0;MDX Unique Name Style=0;Non Empty
Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell
Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet
Size=4096"/>


My code is :
#region Cube Connectivity

public ConnectionState Connect(string connString )

{

this.ConnectionString = connString;

_mdConn = new AdomdConnection(this.ConnectionString);

_mdConn.Open();

return _mdConn.State;

}

#endregion

Reno

Can you change from using .\BILAB to localhost\BILAB? Perhaps '.' is causing
a problem?

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Renaud Harduin" <rh (AT) nospam (DOT) fr> wrote

I did it.
What I've done :
Inititialy my SSAS dirs where pointing to the regular dit, and I changed to
another location.

I reset it to the original value and it worked. Any idea on that phoenemena.

rgds,

"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote

Its difficult to guess what may have occurred without more information.
Perhaps its a permissions issue -- if you are switching from admin to
non-admin user on the machine then perhaps you lost permissions when you
moved the data folder.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Renaud Harduin" <rh (AT) nospam (DOT) fr> wrote

Hi Akshai,

You're true
I guess that you're true about permissions.
I noticed into SSAS config a param. "Allow browse dir" where only the
standard dir are listed, and not my repositories.

thks,

Renaud


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> a écrit dans le
message de news: %23j1m4VKRGHA.2088 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

The browse directories list is meant for administrators to do backup/restore
to/from a specific list of folders. It isn't directly related to the data
folder...

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"RH" <rhm_register-nospam@atyahoodotfr> wrote