Almost every database provides an ODBC interface that can be used to interface with it. The database features provided by IWS can be used with ODBC drivers through the ADO.NET interface for ODBC. In order to use this capability, you must use Microsoft .NET Framework 1.1 or higher.
Note:
Microsoft .NET Framework 2.0 is automatically installed with
InduSoft Web Studio
v6.1+SP5 and
later.
The Database Configuration
dialog allows you to provide connection strings that will
connect to an ODBC DSN. The connection string can be built
automatically by clicking on the Browse button (…). When the Data Link window displays, you should
select the option Microsoft OLE DB Provider for ODBC Drivers as
shown below:
Figure 1. Data Link
Properties, Provider - ODBC
When you click Next, the following window will display:
Figure 2. Data Link
Properties, Provider - Connection
Select the DSN that you want to connect to and click OK. If you want to specify the user name and password on this window instead of specifying on the Object Properties dialog, remember to check the Allow saving password checkbox.