ODBC
The ODBC pane of the database connectivity dialog provides database access to different database systems, which have ODBC data sources configured on your computer. Use this pane to connect to a number of relational databases such as SQL Server, Oracle, MySQL, DB2 and many others. The tree of ODBC drivers located on the left side of the ODBC panes shows all the ODBC data sources available on your computer. Use the "ODBC Data Source Administrator" from your computer's Administrative tools to create new and modify existing ODBC connections. When you create (modify) ODBC data source after the TARGET component(s) installation they will not appear in the tree automatically, please press F5 of "Refresh" from the context menu to update the tree.
The following picture outlines the basic elements of the ODBC pane. ODBC data sources are located on the top level of the tree. An ODBC driver specific dialog may appear when you try to connect to a new database.
Expand the tree nodes to get to view the tables and views for the selected ODBC data source. The list in the middle of the pane shows all elements for the currently selected tree item. The field structure is shown in the field list when a table or a view is selected in the table list. This user friendly feature allows to make sure that you are looking at the right table without even opening it.
The data connectivity dialog is used for two different tasks:
- to open an existing data source
- to connect to a new data source, which will be created as a result of a future process (tool specific).
In the first case, the "Set" button reads as "Open" and you can not connect to a nonexisting data source. In the second case, you can type in a new table name, which will be used in the future to create a new table. Click "Set" (or "Open") when you have selected your data source.
Note to MySQL Users:
For connecting to MySQL via TextConverter we recommend using the ODBC driver provided by MySQL. YOU MUST INSTALL THE 32 BIT DRIVER.
URL: http://www.mysql.com/downloads/connector/odbc/
1.) When configuring the odbc connection please make sure to for forward-only cursors ( image attached )
2.) Also in order to properly setup the driver on a 64 bit machine you need to explicitly configure the 32 bit version of the odbc driver by calling %windir%\syswow64\odbcad32.exe.
a. Once you have configured the MySQL ODBC datasource you can select it in TextConverter via the ODBC tab in the open data source dialog
i. IF the MySQL datasource does not appear in the list on the ODBC tab hit F5 to refresh the list