Customize the OLE Database Providers

You can customize the default database providers displayed in the Provider list in the Add Data Source dialog box or the Edit Data Source dialog box, enabling you to define your own list of OLE Database (DB) providers.

To customize the list of OLE DB providers:

1. Navigate to the <Cobra Installation Directory>.
2. Locate the DataTool.exe.config file and open it using a text editor (such as Notepad).
3. Add the following tags to the file.
   Note: If these tags are already present in the file, remove <-- and -->.

   <configSections>
   <section name="customAppSettingsGroup" type="DataTool.CustomAppSettings,DataTool"/>
   </configSections>
   <customAppSettingsGroup>
   <SupportedOLEDBProviders>
   <OLEDBProvider startsWith="ORAOLEDB.Oracle" databaseProduct="Oracle" />
   <OLEDBProvider startsWith="SQLOLEDB" databaseProduct="SqlServer" />
   <OLEDBProvider startsWith="SQLNCLI" databaseProduct="SqlServer" />
   </SupportedOLEDBProviders>
   </customAppSettingsGroup> 
   

   Consider the following when customizing the OLE DB providers:

   • The OLEDBProvider tags under the SupportedOLEDBProviders node define each OLE DB provider. You can add or remove these tags.

   • The startsWith attribute defines the beginning of the OLE DB provider name. All installed OLE DB providers on the machine, whose name starts with the value specified in the attribute will be included in the Providers list in the Add Data Source dialog box or the Edit Data Source dialog box.

   • The databaseProduct attribute defines the target database product of the OLE DB Provider, which can only be Oracle or SQL Server.