Using Microsoft SQL Server
IWS Database Interface allows you to retrieve and store information on Microsoft SQL Server relational databases. You should follow the steps below in order to configure the SQL Server database:
- Click on the Browse button in the Database Configuration Dialog window. The following window will display:
Figure 1. Data Link Properties, Provider – SQL Server
- Select the Microsoft OLE Provider for SQL Server and click Next. The following window will display:
Figure 2. Data Link Properties, Connection – SQL Server
- Fill out the fields on this window with your database information. If you are not using Windows NT Integrated security, remember to check the Allow saving password checkbox to save the password when the Data Link Properties window is closed.
- Click OK to finish the Connection String configuration.
Your connection string should be very similar to this one:
Provider=SQLOLEDB.1; Integrated Security=SSPI; Initial Catalog=MyDatabase; Data Source=192.168.23.200
Note: These procedures were tested using Microsoft SQL Server 2000.
Tip: The Database Gateway (StADOSvr.exe) now uses an updated time stamp when saving data to Microsoft SQL Server databases, so that milliseconds do not need to be stored in a separate column. However, this only works with Microsoft SQL Server 2008 or later, so if you are using an earlier version of SQL Server, then you must edit the program settings to reverse the change:
- If your project is running, stop it.
- Locate the program settings file at: C:Program FilesInduSoft Web Studio v7.1BinStADOSvr.ini
- Open the file with a text editor, such as Notepad.
- Delete the following line:
TimeStampType2=DATETIME2
- Save your changes, and then exit the text editor.