This is what I am getting when tryi

[RPredrag]

This is what I am getting when trying to connect to olap database from an asp page:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

/Olap/Default.asp, line 4


This is peace of code I want to connect to:


<Language=VBScript>
<%
set cn = Server.CreateObject(&quot;ADODB.Connection&quot
cn.Open &quot;Provider=msolap;Data Source=Solomon&quot;
cn.defaultdatabase = &quot;Foodmart&quot;
%>


I also installed latest Microsoft MDAC 2.7 version.
Any one has any idea why I am getting this error and is there any way around this.

Thanks a lot

 

[issahar]

Hi, RPredrag!

Use ADOMD and not ADODB, using the next syntax:
Dim l_oCellSet As ADOMD.Cellset
l_oCellSet.Open <<yourQuery>>, <<yourConnectionString>>

Issahar
senior software engineer

http://www.softwatch.com

Israel

 

[issahar]

..sorry, one mistake
Dim l_oCellSet As New ADOMD.Cellset
and not
Dim l_oCellSet As ADOMD.Cellset Issahar
senior software engineer

http://www.softwatch.com

Israel