ODBC ingres error in report designer

2 posts, 0 answers
  1. Anthony
    Anthony avatar
    5 posts
    Member since:
    Aug 2016

    Posted 08 Aug 2017 Link to this post

    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.

  2. Ivan Hristov
    Ivan Hristov avatar
    172 posts

    Posted 09 Aug 2017 Link to this post

    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.

    Ivan Hristov
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top