| sefe dery 2005-09-30, 8:24 pm |
| jb1677@gmail.com schrieb:
> When attempting a simple connection using an http:// data source:
>
> Dim conn As New ADODB.Connection
> conn.Open("Provider=MSOLAP.2;Data Source= SqlServer01....etc
>
> We receive the following:
>
> The HTTP or HTTPS connection feature is available only with Analysis
> Services for SQL Server 2000 Enterprise Edition. The server you are
> attempting to connect to is not an Enterprise Edition server.
>
> The issue is SQL is in fact Enterprise edition and Analysis server was
> installed from Enterprise Edition media. We also checked with a script
> from msdn
> (http://www.microsoft.com/technet/pr...ervog.mspx#EFAA)
> which also confirmed that Analysis Services believed it was enterprise
> edition.
>
> Has anyone ever seen this before?
>
thats strange,
but are you sure that you have copied the msolap.asp to the
inetpub/wwwroot folder and you have to use in your connection string
Data Source=http://Servername
thats all.
|