Create

Click on "New" in the FRAME toolbar when this module is open to create a new connection

A first message will show up to let you define the ODBC Type of connection you want to create : Access - Excel or SQL's

dmc_odbc_create_type

Access and Excel

If you select Access or Excel, a checkbox will show to let you define if you will be using an existing System DSN to connect to the tables

dmc_odbc_create_type_dsn

If you define that you will use an existing DSN, you will be then be shown this screen to choose from the existing DSN's the one to use for this connection

dmc_odbc_create_type_dsn_select

If you had defined that the DSN did not yet exist, DMC will open up for you the ODBC Manager and let you create it there - it will then open up the above mentioned screen with the same List for you to choose from ....

SQL

If you had originally selected SQL from the ODBC Type window then you will be offered a second window to select the SQL server TYPE you want to use for this new connection

dmc_odbc_create_type_sql

Depending on your selections you will be then taken to the ODBC connection pre filled form

ADO is not yet supported - ODBC is always pre-checked for you.

ACCESS

This is an ACCESS connection window - nothing has to be done - you can use the "Test" button

dmc_odbc_create_access

If you click on the ODBC Manager button that will open it up for you from DMC itself ....

odbc_manager

EXCEL

This is an EXCEL connection window - you still have to fill in the Worksheet name using the appropriate button

dmc_odbc_create_excel

After filling in the Worksheet name the "Test" button will come up for you to test this connection

SQL

This is an SQL connection window - you have all the main items pre filled for you and just have to finish entering the proper data to build the connection string

dmc_odbc_create_mssql

Enter the all the required values (press "Tab" between each field)

Enter the USERNAME to be used and press "Tab" (or in Ms SQL case check "Empty login if you want to create a Trusted Connection string)

Enter the PASSWORD to be used and press "Tab" (or again in Ms SQL case use the "Empty Pwd" checkbox to create a Trusted Connection)

Enter the DATABASE NAME and press "Tab"

You can also enter the PORT if required by your settings

SQL Anywhere - Oracle - PostGreSQL:

You will also have to enter the Name of the Driver to use (example "Oracle in XE") - DO NOT USE the Microsoft one : it is too slow

You will NOT need to fill in the Server field with this driver (so it is hidden)

A button 'Select' is here for you to choose from the list of all ODBC drivers installed on your machine the good one

odbc_oracle

This Driver List is displayed for you to select with a simple Double-Click on the appropriate driver

odbc_driver_list

You can also of course change the selected driver from this list at any time when editing the record

DB2 : You have to use the ALIAS of the Table name

You can modify any field if need be and after again pressing "TAB" the entered value will show in the connection string ....

Do not forget to fill in the TEXT and IMAGE fields with LENGTH values (BLOB's and IMAGE's) - by default the tool will fill in 512 if you forget so as not to block your imports(MEMO and BLOB fields not seen).

You can define EMPTY passwords if you need to by using the appropriate checkbox :

When the connection string is filled in with the DSN name on your machine (and other checkbox's filled with Worksheet if need be) then you can use the "Test ODBC" button and if all is fine you will see all Access Tables or all Excel Sheets.

You also have the name of the server connected to for better information....

odbc_good

Oracle : We have filtered the returned list as otherwise it would show you zillions .... if ever some are wrongly filtered please ask us for their appearance