Providers List in TUniConnectDialog

[m227]

Hi,
Is there any way to limit providers list in TUniConnectDialog to i.e. only MySQL and MS SQL Server?

[MaximG]

The list of available providers of the TUniConnectDialog component includes only providers that are declared in the same module with the TUniConnectDialog component. In your case, the list of included modules will look like the following :

Code: Select all

uses
  ...
  Uni, UniDacVcl, UniProvider, SQLServerUniProvider, MySQLUniProvider;

[baeckerg]

I have the same problem. My users need to choose whether they want to convert a MS Access Database to SQLite or MySQL. Therefore I have in my uses clause

Code: Select all

  
ODBCUniProvider, AccessUniProvider, UniProvider, SQLiteUniProvider, DAScript,
  UniScript, CRBatchMove, DALoader, UniLoader, UniDacVcl, MySQLUniProvider

which shows ODBC and Access as well in the dialog. It would be nice to have a possibility to exclude them from the list.

Regards
Gernot

[MaximG]

Yes, you are absolutely right. TAccessUniProvider is a descendant from the TODBCUniProvider class, therefore ODBC appears in the list of available providers in UniConnectDialog. You can override this behavior using UniDAC sources. In addition, you can implement your own dialog. There is a sample of creating such a dialog in our demo: [UniDAC install folder]\Demos\UniDacDemo\ConnectDialog\