I have tried and it still does not use the UID and PWD from the connection string. And someone has told me that MS OLAP only uses NT authentication. Probably thats why it is not working for me.
Thanks anyway Robert.
Thanks Paul !!! It is really helpful :>
However, the "UID=uid;PWD=pwd;" section does not seem to work as SQL server always use my window login rather than the UID/PWD.
Hi,
I have an application which is running on a different machine then the SQL Server. Both machines are running within the same workgroup but not domain.
I have MDAC 2.6 installed on client. My application is a Lotus Notes client using ADOMD to access the OLAP cubes on the SQL server...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.