ODBC connection configuration
Overview
When you connect to Database via ODBC , select Local DB as the location, select ODBC as the data type, and configure the detailed settings.
64-bit only
SDI is a 64-bit application. Always use a 64-bit ODBC driver and DSN for the connection. 32-bit DSNs and drivers cannot be used.
Configuration
Basic
| No | Item | Description |
|---|---|---|
| 1 | User ID | Username for the database account. |
| 2 | Password | Password for the database account. |
| 3 | Connection Type | Select Basic |
| 4 | DSN | ODBC Datasource Name |
| 5 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |
| 6 | Enable Transactions | Specify whether to enable transaction control. When ON, transactions are enabled for each connection, and operations are executed within the same transaction. When OFF, each operation is committed automatically (autocommit). |
ODBC Connection String
SDI uses System.Data.Odbc to connect to Database via ODBC.
You can connect ODBC by using ODBC Connection String directly.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select ODBC Connection String |
| 2 | ODBC Connection String | Enter the details of the ODBC Connection String. * Do not enter user and password information in the Connection String. Reference:OdbcConnection.ConnectionString property |