User Tools

Site Tools


t2yb.htm
Navigation:  SQL Drivers > ODBC Accelerator Driver >====== ODBC Driver Configuration–Table Properties ====== Previous pageReturn to chapter overviewNext page

Typically, you add SQL support to your application by importing the SQL or ODBC table, view, and synonym definitions into your Clarion Data Dictionary. The Import Wizard automatically fills in the Table Properties dialog with default values based on the imported item. However, there are several prompts in the Table Properties dialog you can use to further configure the way the ODBC Accelerator Driver accesses the data. These Table Properties prompts, and their uses, are described below.

Owner Name

Typically, the Import Wizard places the SQL database connection information (Host, Username, Password, etc.) in the Owner Name field.

Some backend databases may require additional connection information which you can supply in the Owner Name field. This information follows the password and is separated by semicolons, using the syntax: keyword=value;keyword=value.

For example, when accessing a Sybase database with the ODBC driver, this would appear as:

DataSource,UserID,PassWord,DATABASE=DataBaseName;APP=APPName

Consult your appropriate SQL Server's documentation for information on these keywords, their uses and effects.

t2yb.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1