ODBC connection configuration
When you connect to Database via ODBC , select Local DB as the location, select ODBC as the data type, and configure the detailed settings.
|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||Transaction Supported||Transactional statements may not be supported by some databases when making an ODBC connection. At that time, it was necessary to set Transaction Supported to off.
ODBC Connection String
SDI uses System.Data.Odbc to connect to Database via ODBC.
You can connect ODBC by using ODBC Connection String directly.
|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.