ODBC database
Object that represents a local or remote database among those supported with ODBC (Open DataBase Connectivity) protocol
- BrowseName
- ODBCStore
- SuperType
- Store(Store)
Properties
| Name | BrowseName | DataType | Description |
|---|---|---|---|
| DSN | DSN | String | DSN (Database Source Name) |
| DBMS type | Type | DBMS type | Type of the database server |
| Username | Username | String | Name of the user for access to the database |
| Password | Password | Password | User password for access to the database |
| Database | Database | String | Name of the database in the database server |
| Server | Server | String | IP address or hostname of the database server in the network |
| TCP Port | Port | UInt16 | TCP port of the database server (if 0, SQL default = 1433, MySQL default = 3306) |
| Tables | Tables | ODBC store table | (Inherited from Store) |
| Max column name length | MaxColumnNameLength | UInt32 | (Inherited from Store) |
| Max columns count | MaxColumnCount | UInt32 | (Inherited from Store) |
| Data type compatibility map | DataTypeCompatibilityMap | NodeId | (Inherited from Store) |
| Status | Status | Store status | (Inherited from Store) |