SSAS Problem with square brackets

SSAS Problem with square brackets

Postby 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?p=29404&sid=c104696dfc42c12bad174c907fa90057

It was working before with express trial version of driver after some manipulations with files, but i can repeat that now purchased licence.
denstepa
 
Posts: 1
Joined: Fri 21 Feb 2014 15:33

Re: SSAS Problem with square brackets

Postby Shalex » Fri 28 Feb 2014 14:48

Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL