Active Query Builder support area

Oracle Database links

Avatar
  • updated
  • Completed

Hello,

we are using AQB to connect to an Oracle Database Server with several configured database links. Is it possible to show those database links in the DatabaseSchemaTree and to use those links in the DesignPane?

Best Regards,

Christian Sack

Avatar
Andrey Zavyalov, PM

Hello,

Database links will be visible in the Database Schema Tree if QueryBuilder.MetadataLoadingOptions.LoadDefaultDatabaseOnly property is set to false.

Avatar
pdv-software

Thanks for your fast answer, but it doesnt work in my case. After switching LoadDefualtDatabaseOnly to false i still can only see tables, synonyms and views. The AQB version is 2.9.6.720

Avatar
Andrey Zavyalov, PM

Please set the necessary QueryBuilder.MetadataStructureOptions.GroupBy* properties (...Server, ...Database) to have objects from linked servers grouped in the tree.

Avatar
pdv-software

I have set GroupByDatabases = true,GroupByTypes and groupByServers to true but i still don't see the database links. I have the following DatabaseSchemaTree:

Is there any other option I need to enable or disable?

Avatar
Andrey Zavyalov, PM

Indeed, there's a problem with Oracle linked servers. We will fix it and let your know as soon as the new version will be available for downloading.

Avatar
Andrey Zavyalov, PM

The new version with support for Oracle database links is available for downloading.