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

Cannot Get CSV or XML to Render

Hello,

I've just installed SQL Server 2005 Express, and RS (all with SP2). I can run reports fine for HTML, PDF, and Excel, but whenever I specify a format with "CSV" or "XML", I get the following error:

An attempt has been made to use a rendering extension that is not registered for this report serverAn attempt has been made to use a rendering extension that is not registered for this report server

I'd really like these report formats to work. I haven't modified any system configuration files.

Has anyone else seen this error?

Thanks,

Michael

Sorry, Michael.

CSV, XML, and TIFF don't work in Express.

From TechNet: http://technet.microsoft.com/en-us/library/ms365166(SQL.90).aspx

You'll have to upgrade to another version to use those extension.

-Jessica

|||

Jessica,

What's strange is that I ran XML and CSV reports right after getting the report server installed (with SQL Express), and then they just stopped working the next day when I shut down and then re-started my machine. VERY strange indeed. That lends some argument that it is possible. There were a few points in that link you sent me (thanks for the link, BTW), that were wrong. For example, I can reference my local report server with http://localhost/Reports, whereas the page says that I need to reference my report server with http://localhost/Reports$sqlexpress. That was not correct, or is not correct with SP2. So I am wondering if they changed the allowed formats too. Thanks for the info.

Michael