omron — Using Microsoft Excel

Database Interface 2. Extract and install the software on your desktop. A new directory is created containing the Microsoft SQL Server files, including files that are customized for different device processors. 3. Open the directory: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices \wce500 4. In the directory, select the correct sub-directory for your device processor. For example, if your device uses an x86 processor, then select the x86 sub-directory. 5. In the sub-directory, select the CAB files that need to be copied to your device. Continuing with the x86 example, select the following files: • sqlce.dev.ENU.wce5.x86.CAB • sqlce.repl.wce5.x86.CAB • sqlce.wce5.x86.CAB 6.

Copy the CAB files to your device's non-volatile memory and then note where they are located. The exact method you use to copy files to the device depends on your setup. You might use desktop syncing or a network connection or a USB flash drive. Check the manufacturer's documentation to see what methods are available. 7. On your desktop, create a new text file named install.bat . 8. Edit install.bat to create a batch script that loads the CAB files on startup. Continuing with the x86 example, edit the file to contain the following code:

wceload /noui /delete 0 " filepath \sqlce.dev.ENU.wce5.x86.CAB" wceload /noui /delete 0 " filepath \sqlce.repl.wce5.x86.CAB" wceload /noui /delete 0 " filepath \sqlce.wce5.x86.CAB" …where filepath is the location to which you copied the CAB files. For more information, see the MSDN article about the Wceload tool . 9. Copy install.bat to your device's \Windows\Startup directory. If the device does not have a \Windows\Startup directory, then follow the manufacturer's documentation for configuring startup items. 10.Restart the device. If you have correctly selected and installed the files, then SQL Server will run on startup on you should be able to access it with your IWS project.

Using Sybase You need to install the AsaClient provider on your computer; the tests with IWS were performed using the architecture explained in the topic Linking the Database Through a Remote DB Provider . If you are using the browse button to automatically generate the connection string, the string returned will have the following format: Provider=ASAProv.90; Data Source=Test This format requires that you create an ODBC DSN with the same name as the Data Source (in this case, Test ) in order to communicate with the database. If the DSN is not created, the following error will display in the LogWin when connecting to the database: Database: Error: Parse error:

DSN 'Test' does not exist To void an ODBC DSN, you can enter with the connection string manually as shown in the example below: Provider=ASAProv.90; DBF=C:\ Test.db Note: These procedures were tested using Sybase Server Anywhere 9.0.1.1751. Using Microsoft Excel IWS's database interface lets you store information in and retrieve information from Microsoft Excel spreadsheet (XLS or XLSX) files. Page 422 InduSoft Web Studio