Hallo together,
I want to access Microsoft SQL Server Analysis Services 2008 from PROLOG. For the SQL Server it is no problem because I can establish an odbc connection and send SQL commands over this and receive the results.
But for Analysis Services I can not use ODBC. How could I communicate with that.
For OLE DB for example I normally enter this connection string
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
and it works. Can I use connection strings in PROLOG somehow.
Thanks for any help with that,
Martin
I want to access Microsoft SQL Server Analysis Services 2008 from PROLOG. For the SQL Server it is no problem because I can establish an odbc connection and send SQL commands over this and receive the results.
But for Analysis Services I can not use ODBC. How could I communicate with that.
For OLE DB for example I normally enter this connection string
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
and it works. Can I use connection strings in PROLOG somehow.
Thanks for any help with that,
Martin