Cannot open connection to AS 2005

Hi All,

I have installed AS 2005 and am using VS 2005 and .Net 2.0.

Connection to AS 2005 is configured for HTTP.

Whenever I open a connection it gives me below error.

"Object not found".

Stack Trace:

at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)\r\n
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)\r\n
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)\r\n
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)\r\n
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)\r\n
at System.Data.OleDb.OleDbConnection.Open()\r\n

Below is peace of code:

string Connection = "Provider=MSOLAP.2;Data Source=http://localhost/olap; Initial Catalog=Cube1";

conn = new OleDbConnection(Connection);

conn.Open();

string Query = " ";

OleDbCommand dbCommand = new OleDbCommand(Query, conn);

dbCommand.CommandType = CommandType.Text;

dtrdr = dbCommand.ExecuteReader();

I have .Net 1.1 installed and vs.net 2003 as well as ADOMD.Net 8.0.

I guess when VS.NET 2005 is installed, ADOMD.NET 9.0 should be automatically installed.

Do I need to install ADOMD.Net 9.0 manually.

Appreciate your help as this issue needs to be resolved urgently.

Regards,

Try using

Provider=MSOLAP

rather than

Provider=MSOLAP.2

In your connection string. MSOLAP.2 is the AS2K version of the provider and will probably have problems connecting to AS2005.

Also, the Initial Catalog property should refer to the name of the AS database you're connecting to, not a cube. Is your database really called 'Cube1'?

You may also need to install ADOMD.Net 9.0 manually too...

Chris

|||

Hi Chris,

I tried with Provider=MSOLAP but could not succeed.

You are right. I wrote Cube1 instead of Database name in my post by mistake.

I tried with TCP/IP connection. But I got different error now. It says

"Can not connect to server. Server is either not started or too busy"

But I can view Database in SQL Server Management .

Regards,

|||

Try getting rid of "http://" from your connection string.

Also, you talk about using ADOMD NET 9.0, but you are using OLEDB...which do you want to use?

|||

Hi,

I am not sure if you have to remove "http://" from the connection string, but.....

Try the following:

1. Try using the provider MSOLAP .3 also.

2. Next, add the user account IUSR to a role with required permissions in SSAS 2005.

3. Another check is to see if you have configured msmdpump to connect to the specific SSAS server.

4. The connection string must include msmdpump.dll in the path (see exmaple)

5. Also the connection string can include a username and password. here is an example:

"Provider=MSOLAP.3;

Persist Security Info=True;

Data Source=http://[target server]/olap/msmdpump.dll;

Initial Catalog=PNGReportOLAP;

User Id=[user id];Password=[password]"

6. Read this link for all other details on connectivity problems to ssas 2005 :

http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

7. For more details on connection strings, check this article:

http://www.connectionstrings.com/

8. An additional thing which I wanted to mention is, you need to use .Net 2.0. only. I am not sure if .Net 1.1 supports ADOMD.Net and some connection features of ssas 2005.

Hope this helps

Regards