|
Home > Archive > MS SQL Server OLAP > November 2005 > XMLA Connection String
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
XMLA Connection String
|
|
| Val Matison 2005-11-22, 8:24 pm |
| Hi,
I am unable to connect to SQL 2005 using XMLA. The exa,ples once the
connection has been made are available in BOL but what aobut the initial
connection?
Here's some basic code. I try to communicate using HTTP and will eventually
create a SOAP package. What I don't know is what to make of the variable
lcUrl. When I configured this for SQL 2000 I used
http://localhost/xmla/msxisapi.dll for lcUrl and that worked fine. In 2005,
I no longer need the msxisapi.dll as far as I know. So far I've tried
various combinations of http://localhost and 127.0.0.1 and even added some
ports to the string.
loXMLHTTP = CREATEOBJECT("Microsoft.XMLHTTP")
lcURL = ???
loXMLHTTP.open("POST", lcUrl, .F.)
? loxmlhttp.readyState
What am I doing wrong?
TIA.
| |
| Val Matison 2005-11-23, 8:24 pm |
| I've found the answer. Wasn't in BOL unfortunately. Requires the use of
msmdpump.dll
"Val Matison" < vmatison@infoinfoinf
o.com> wrote in message
news:%23GN8jF97FHA.2676@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I am unable to connect to SQL 2005 using XMLA. The exa,ples once the
> connection has been made are available in BOL but what aobut the initial
> connection?
>
> Here's some basic code. I try to communicate using HTTP and will
> eventually create a SOAP package. What I don't know is what to make of the
> variable lcUrl. When I configured this for SQL 2000 I used
> http://localhost/xmla/msxisapi.dll for lcUrl and that worked fine. In
> 2005, I no longer need the msxisapi.dll as far as I know. So far I've
> tried various combinations of http://localhost and 127.0.0.1 and even
> added some ports to the string.
> loXMLHTTP = CREATEOBJECT("Microsoft.XMLHTTP")
>
> lcURL = ???
>
> loXMLHTTP.open("POST", lcUrl, .F.)
>
> ? loxmlhttp.readyState
>
> What am I doing wrong?
>
> TIA.
>
>
>
>
>
>
|
|
|
|
|