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

2. Download ODBC client C35 (64bit version) from ftp://ftp.tigerlogic.com/pub/ODBC/2.0.x/Releases/ to the customer’s tech folder and run it. This will load both versions of the client on the system. You need to create ODBC driver on both sides (32bit to test with WINSQL and 64bit for the web service).

3. Next, create a new ODBC driver in All Programs\Tiger Logic D3\D3 ODBC Client and click on Data Source Setup (64bit) . 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. Now go back in All Programs\Tiger Logic D3\D3 ODBC Client and click on Data Source Setup for the 32bit and add ODBC Driver.

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

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

8. Once complete, you can open Winsql.exe

9. 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

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

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