Database Interface maximum (16) , where 19 is the number of letters in the Server Name . Please see Database Troubleshooting for more hints to work around this problem. 4. Click OK to finish the Connection String configuration. Note: These procedures were tested using ORACLE 10g Release 1. Using Microsoft Access Databases IWS's database interface lets you store information in and retrieve information from Microsoft Access database (ACCDB) files. You do not need to have Access installed on the same computer as IWS; IWS can directly read from and write to an existing ACCDB file.
However, you do need to use Access to create the initial file — either a blank database for new data or a populated database for reference data. Once you've created the file, you can move it to any location and establish a connection to it there. Note: This procedure was last tested using Microsoft Access 2007 (12.0.6211.1000). To establish a connection between your IWS project and your ACCDB file: 1. In the Database Configuration property sheet , click the Browse button ( … ). The Data Link Properties property sheet is displayed: Selecting the OLE DB Provider 2. Select the appropriate OLE DB Provider for your database: • For a Microsoft Access 2003 database file, select Microsoft Jet 4.0 .
• For a Microsoft Access 2007 database file, select Microsoft Office 12.0 Access Database Engine . 3. Click Next . InduSoft Web Studio Page 419