Re: Using MySQL .NET in Microsoft Analysis Services
Posted by: Peter Åkerström
Date: September 05, 2006 08:09AM

When creating a DataSource I have seen that MS wraps the query with another query.
For example if the sql should be: select * from machine, the new query is:
select [machine].* from (
select * from machine
) as [machine];

And MySQL can´t understand the quote sign '[some table]'. I have tried to set sql-mode=MSSQL, but it only accepts '"' as a quote (ansi)

Options: ReplyQuote


Subject
Written By
Posted
Re: Using MySQL .NET in Microsoft Analysis Services
September 05, 2006 08:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.