ADO/ODBC Explorer

Previous  Top  Next

( Pro Edition )


The ADO/ODBC Explorer can be used to connect to any ADO or ODBC datasource and start a Database Navigator. This, however, is a read-only version of the navigator so all Edit options etc are disabled and their will be no Navigator Workspace.


You start the ADO/ODBC Explorer by using Tools | ADO/ODBC Explorer, this will show the following dialog:


Starting the ADO/ODBC Explorer


You can select a previously used ADO datasource from the drop down box, or select the ODBC radio button to select an existing ODBC datasource. If you want to create a new ADO connection string, click the Edit Connectstring button next to the ADO edit box. Creating a new ADO connection string will add it to the available previously used strings as in the drop down list.


Because ODBC username/password combinations can be different from the available datasource as stored on your machine, you can enter a new username/password combination in this dialog.


After that, click Finish to start your ADO or ODBC session.


See also: Building an ADO Connection String


An ADO connection to a MS Access database


What is available in the Database Navigator tree after connecting to an ADO or ODBC datasource depends on the datasource capabilities. ADO and ODBC drivers define a certain set of objects that are available and Database Workbench uses these to get the objects into the tree view of the session.


Everything related to Editing objects, or Schema Printing will be disabled for this session.


Once connected, you can run queries like any other in the SQL Editor for this session, the Script tab will be invisible though.


A simple select from an MS Access table