Active Query Builder support area

OLEDBMetadataProvider

Avatar
  • updated
  • Completed

Just installed the trial version of Active Query Builder for WinForms. When I add this line to my project:

OLEDBMetadataProvider metadataProvider = new OLEDBMetadataProvider();


I get the following error:

The type or namespace name 'OLEDBMetadataProvider' could not be found


I have reference to ActiveDatabaseSoftware.ActiveQueryBuilder2 and ActiveDatabaseSoftware.ExpressionEditor2 in my project, plus at the top of my code file for the form in question, I have the following using statement:

using ActiveDatabaseSoftware.ActiveQueryBuilder;


So what am I missing?


Thanks in advance!


Avatar
Andrey Zavyalov, PM

You have to add reference to ActiveDatabaseSoftware.OLEDBMetadataProvider2.dll assembly.

Avatar
Andrey Zavyalov, PM

The UniversalSyntaxProvider was renamed to GenericSyntaxProvider in the second version. All syntax providers are included in the ActiveDatabaseSoftware.ActiveQueryBuilder2.dll assembly. Note that we do not recommend to use this syntax as it's limited in ability to parse amd edit database server specific clauses, such as TOP, LIMIT, etc. It was made for the Free version of the component. I recommend you to use a special syntax provider if it exist for your database server (MSSQLSyntaxProvider for MS SQL Server, etc.) If the component don't have a syntax provider for your database server, try to use ANSI SQL standard syntax providers (SQL92SyntaxProvider, SQL2003SyntaxProvider). If you let the end-user to decide to what database server he/she will be connected to, use the AutoSyntaxProvider which detects the database server being used by sending a serie of server-specific clauses.

Avatar
Steve Smith

Hey, that did it! Thanks! Now I can't find a reference to UniversalSyntaxProvider. Suggestions?

Avatar
Andrey Zavyalov, PM

You have to add reference to ActiveDatabaseSoftware.OLEDBMetadataProvider2.dll assembly.