1. Download the program WINSQL to the desktop (get it from our FTP site)

2. Download ODBC client C35 (32bit version) from ftp://ftp.tigerlogic.com/pub/ODBC/2.0.x/Releases/ to the customer’s tech folder and run it.

3. Next, create a new ODBC driver in Programs\Tiger Logic D3\D3 ODBC Client and click on Data Source Setup. Once open, click on System DSN tab, ADD, select D3 ODBC Driver then Finish. Then fill in the Configuration Parameters:

Data Source Name – Account Name (PM)

Host – IP Address of Server (ex. 192.168.1.1)

Virtual Machine – IP Address of Server (ex. 192.168.1.1)

D3 User ID – ODBC

User Password - odbc

D3 Account - PM

Server Version – 7.2.X-7.5.S3 or 7.5.S4 and up

4. Once you click OK, it creates D3 ODBC Driver then click OK to close the window.

5. In DM, create a ODBC  user (U USERS ODBC). This setup is the same a PM, except for the last line is left blank.

6. A new item will appears in the list, hit Ok to complete

7. Once complete, you can open Winsql.exe

8. Choose the Data Source Name is PM, User ID is odbc and Password is odbc then click Ok and it should open into a Query window

9. To test, type SELECT * FROM CUSTOMER, click the green arrow and the results page will appear listing data.

10. Add the  !net start d3odbcsv  command to the coldstart