Active Query Builder support area

No schema shown for ProvideX database

Avatar
  • updated
  • Completed

Has anyone been able to connect to a ProvideX database server?  This is the database for MAS90.  They have an ODBC driver but not OLE DB, as far as I can tell.  I can open connections and execute queries in .Net without any problems, but when I try connect the ActiveQueryBuilder to it, the schema tree is blank.  I tried it with the Samples as well as my own application.  There aren't any exceptions thrown.

 

Is there any way for me to figure out why it doesn't fill the schema tree?

Avatar
Anonymous

Possibly your ODBC driver doesn't implement the necessary functions to retrieve database schema information and your database server doesn't have the INFORMATION_SCHEMA.* tables or their structure differs from the standard. In this case you can load metadata programmatically. Have a look at the Load Metadata demo project that's included in the installation package, review the articles of the Knowledge Book:

for AQB. 2 NET: Adding objects to the Metadata Container programmatically

for other editions: Loading metadata programmatically

Avatar
JLathem


Thanks for the info.  I ended up going with the dynamic method using the

ItemMetadataLoading event and it works great.  I set the Schema node to 'Default' so the QueryBuilder doesn't include it in the SQL statements.

 

Avatar
Anonymous

Hello,


Possibly your ODBC driver doesn't implement the necessary functions to retrieve database schema information and your database server doesn't have the INFORMATION_SCHEMA.* tables or their structure differs from the standard. In this case you can load metadata programmatically. Have a look at the Load Metadata demo project that's included in the installation package, review the articles of the Knowledge Book:


for AQB. 2 NET: Adding objects to the Metadata Container programmatically

for other editions: Loading metadata programmatically

Avatar
JLathem


I want to add something else that I've discovered.  If I manually type in a valid SQL Query, the visual designer portion does show the Tables with all fields.  It's only the Schema tree that is blank.  Thanks!