ODBC ingres error in report designer

[Anthony]

Hi Guys,

I have an ingres ODBC driver installed on the report server for connecting to our ingres tables.  In the report designer when I select the query builder button in configure data source I receive an error such as "ERROR [42000] [Actian][Ingres IJ ODBC Driver]Line1, There is no such function as 'serverproperty'".  I can use the same driver to connect to the tables in Microsoft Access and this works fine, I just get this error every time in the report designer, can anyone offer any assistance to resolve this issue.

 

Thanks for your help

Anthony Brown.

HSS Senior Developer.

[Ivan Hristov]

Hi Anthony,

We have already answered in the support ticket you created, but we'll post the answer here as well, because it might be useful for another user that experiences the same problems:

Query Builder internally uses our DataAccess product to build relations between the tables and indexes. However, DataAccess supports a limited number of databases and when it stumbles upon an unknown database, the QueryBuilder falls back to MSSQL, as in your case - 'serverproperty' is a valid term in MSSQLand doesn't exist in Ingres. 

Currently being discontinued, it's highly unlikely DataAccess would add support for Ingres database. Unfortunately, we cannot suggest a workaround so you'll be unable to use the Query Builder with your Ingres database. However, your query should work if you place it as a plain text in Configure data source command window.

Regards,
Ivan Hristov
Progress Telerik