Log file property of the ConnectionString

[Ivanchain]

Log file property of the ConnectionString



Hi, friends,

I have heard not once in this forum that when you use PivotTable(OWC) to
connect to an AS 2005 server, you could use

the PivotTable.ConnectionString=
"Provider=msolap;Datasource=MySSASServerName;Initial Catalog=MySSASDBName;log
file=c:/log.txt" to record the MDX query in the log.txt.



But, I never success to do this. I have set the PivotTable.ConnectionString,
and no error is reported, the PivotTable get data well, but no log.txt is
produced.



Could you tell me if we could really get the MDX query by the log file
proerty of the connectionString?





yours,

ivan