The Data Sources Panel (SQLIO)
Within a Sunbelt SQLIO Schema database a required table named "sun_sqlio_databases" must exist. The SchemaEditor exposes this table using the DataSources panel. This table defines end-user database references that allows a connection to a specified SQL Database Engine.
|
Column |
Use |
|
id |
This column is a unique number that identifies the data source. |
|
name |
This text column that store the user defined name for this database connection information. |
|
description |
This column contains text for user information as desired. |
|
driver |
Integer column that contains the same information as described by the PLB_SQLIO_DRIVER keyword for the INI configuration file. |
|
sql_type |
Integer column that contains the same information as described by the PLB_SQLIO_SQLTYPE keyword for the INI configuration file. |
|
host |
Text column that contains the same information as described by the PLB_SQLIO_HOST keyword for the INI configuration file. |
|
user_name |
Text column that contains the same information as described by the PLB_SQLIO_USER keyword for the INI configuration file. |
|
pass |
Text column that contains the same information as described by the PLB_SQLIO_PASS keyword for the INI configuration file. |
|
conn |
Text column that contains the same information as described by the PLB_SQLIO_CONN keyword for the INI configuration file. |
|
ext |
Text column that contains the same information as described by the PLB_SQLIO_EXT keyword for the INI configuration file. |
|
flags |
Text column that contains the same information as described by the PLB_SQLIO_FLAGS keyword for the INI configuration file. |
Data Source Addition or Edit
To add or edit a data source to the database, select "Add" or "Edit" from the Data Sources menu or right click on the Data Sources panel. The Data Sources Editor will then be displayed.
Delete Data Source
The Delete Data Sources function removes the data source from the schema database. The Delete functions within the SchemaEditor utility all support multiple selection.
 |