SSAS Problem with square brackets

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
denstepa
Posts: 1
Joined: Fri 21 Feb 2014 15:33

SSAS Problem with square brackets

Post by denstepa » Fri 21 Feb 2014 15:37

While processing dimensions in SSAS via dotConnect Postgres professional driver i got querries like:

Code: Select all

SELECT 
  DISTINCT
 [dbo_Sites].[id] AS [dbo_Sitesid0_0],[dbo_Sites].[title] AS [dbo_Sitestitle0_1]
  FROM [public].[sites] AS [dbo_Sites]
And errors:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: syntax error at or near "[".

I think this problem is much like another thread, but with another db: http://forums.devart.com/viewtopic.php? ... 907fa90057

It was working before with express trial version of driver after some manipulations with files, but i can repeat that now purchased licence.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: SSAS Problem with square brackets

Post by Shalex » Fri 28 Feb 2014 14:48


Post Reply