MdacTools 1.1 - Putting it together.
Download MdacTools 1.1
What's new for Version 1.1
Unzip MdacTools.zip to any folder.
MDAC 2.x (tested up to MDAC 2.5 SP2).
MdacTools is a combination of six OLE DB tools:
Connections made with any of MdacTools' pages are global: this means
that all pages show their features related to the same connection. You can start or change the connection to another provider from any page, and the rest of the pages will refresh to show the new contents.
Connection string builder:
Press the 'Build' button and the Data Links wizard will pop up, allowing you to select a provider and set the desired properties. Closing the wizard displays the obtained connection string. You can modify it or leave it alone, and then check the connection pressing 'Connect'. Or you can copy the string to the clipboard pressing 'Copy'.
Once successfully connected, the string will be modified to reflect those properties the provider sets by default. To select a new connection, start over pressing 'Build'. If the selected provider requires a password, be sure to set 'Persist Security Info' to True, otherwise the password will not be included in the string.
You can save the connection string to a text file, and re-open it later (Registered version).
If not connected, press 'Connect' and follow the wizard's instructions. Once connected, you will get the selected provider's supported property sets on the listbox to the left. Selecting a property set, all supported properties for that set will show up on the rightmost listbox.
Since these properties are obtained via GetPropertyInfo, only properties belonging to the initialization or data source set will have their values set. Once again, press 'Connect' to change the provider.
Connect to a provider in the usual way. The leftmost listbox will display all supported schemas. Selecting a schema, the rightmost listbox will display the restrictions that can be set on that particular schema. If you select a restriction, you can set its value by typing it on the 'Value' edit box and pressing 'Set Value'. To get the schema, press 'Get Schema'.
Restrictions are reset after getting a schema. If you selected a restriction and want to cancel, just select another schema and go back to the original: this resets any selection.
When you select this page, the root enumerator's content will be displayed. You will have typically two kinds of rows: data sources and child enumerators (check the Type field). If you select a child enumerator, the button to the right will display 'Enumerate'. Pressing the button opens the child enumerator.
If you select a data source, the provider-specific prompt will pop up, allowing to connect to that data source. Be aware that some providers may not have an available data source on your machine.
Connect as usual, and you will get a list of user tables, with three columns: Table Name, Catalog and Schema. Some providers require the full qualified name of a database object, and this is built 'on the fly' based on provider's properties.
Selecting a table, you can view full schema information by pressing 'Schema', or display its data by pressing 'Data'. The data viewer is a 'grid-like' listview with editing capabilities (registered version). This grid was built upon the 'original' list control (Pre-Explorer 3.0), thus it will run on any Windows 9x / NT platform.
Navigation: Arrow keys
Start edition: F2 key, double click or context menu (Edit)
Cancel editing: Escape key or new selection
Confirm editing: Enter key
Delete row: Delete key or context menu (Delete)
Insert row: Insert key or context menu (Add) *
* you can confirm the insertion with Enter but it will depend on table's
schema if the data source accepts partial rows.
Connect as usual, and type your query . If a rowset is returned, you
can view and edit its data in the grid.
Registered vs. evaluation versions:
A new page for 'Command Processor' is added to the registered version. This tool allows to perform SQL commands against any datasource, set properties on the command object and obtain editable data on request.
The registered version of MdacTools allows you to edit tables and rowsets with Table Analyzer and Command Processor. Full email support is granted to registered users (evaluators can ask for support and they generally get it).
Buenos Aires, August 1999