XMLA Connection String

#1

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.

#2

I've found the answer. Wasn't in BOL unfortunately. Requires the use of
msmdpump.dll

"Val Matison" <vmatison (AT) infoinfoinfo (DOT) com> wrote

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

XMLA Connection String

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

XMLA Connection String - 11-22-2005 , 07:58 PM

Re: XMLA Connection String - 11-23-2005 , 04:24 PM