|
Create |
  
|
|
Create |
|
Click on "New" in the FRAME toolbar when this module is open to create a new connection.
A wizard will walk you though the necessary steps.
A first message will show up to let you define the ODBC Type of connection you want to create : Access - Excel - HyperFile or SQL's
Access - HyperFile and Excel
If you select Access HyperFile or Excel, a checkbox will be displayed to let you define if you will be using an existing System DSN to connect to the tables
If you define that you will use an existing DSN, you will be then be shown a list to choose from the system DSN's the one to use for this connection.
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
TIP & TRICK* (when you have problems connecting or during data reading on some miscellaneous SQL connections)
If you had originally selected SQL from the ODBC Type window then you will be offered a second List to select the SQL server TYPE you want to use for this new connection
Change ALL colors and fonts in DMC
Depending on your selections you will be then taken to the ODBC connection pre filled form for you to complete and Save.
ACCESS and HyperFile
For any HyperFile ODBC connection the NAME MUST CONTAIN HF_ or hf_ for DMC to "see" it as such
Nothing has to be done - you can use the "Test" button
EXCEL
You still have to fill in the Worksheet name using the appropriate button
After filling in the Worksheet name the "Test" button will come up for you to test this connection
SQL's
You have all the main items pre filled for you and just have to finish entering the proper data to build the connection string
Enter the required values (press "Tab" between each field)
SERVER NAME (if applicable) and press "Tab"
USERNAME to be used and press "Tab" (or in Ms SQL case check "Empty login if you want to create a Trusted Connection string)
PASSWORD to be used and press "Tab" (or again in Ms SQL case use the "Empty Pwd" checkbox to create a Trusted Connection)
DATABASE NAME and press "Tab"
You can also enter the PORT if required by your settings
Depending on the SQL type you will need or not to select the driver to use by clicking on the 'Select" button :
SQL Anywhere - Oracle - PostGreSQL - MsSQL and MySQL :
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 and it REQUIRES the Oracle one to be installed and used
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 one to use.
For Postgre SQL you have to use the UNICODE version of the ODBC driver (and not the ANSI one which will not allow proper connections)
The Driver List is displayed for you to select with a simple Double-Click on the appropriate driver
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....
* TIP & TRICK :
some older versions of some SQL's can give you problems to connect or when reading - transferring data
You can use this "trick" to test and use DMC in "limited" ways (no sql specific features and functions like GUID or server side defaults etc)
Create a SYSTEM DSN pointing to your SQL DB and use (and create in DMC) an ACCESS "type" of connection
Some users for example requiring to connect to version 6of SQL anywhere could not get the proper settings (keys etc read) when using an SQL connector
The system tables DMC uses to query the server did not exist in those older versions and the KEYS were not properly returned resulting in errors while reading tables
Creating an ACCESS "type" of connection solved this issue.