Started using MariaDB instead of Microsoft SQL Server.
Maria database is great, free, and compatible with MySQL.
1) Install MariaDB and HeidiSQL Manager. Open HeidiSQL and create database = "trainning", user = root, and password. MariaDB seems to defaults to user = "root". "MySQLDemo2.APP" uses database "trainning" with two "n". Close HeidiSQL Manager.
2) Open Microsoft Windows "Services". Verify "MySQL" is set to automatic and is started. Close Services
3) Download and install the 32-bit MySQL ODBC 5.3 ANSI Driver from MySQL website. Search the Web for "mysql odbc driver download".
4) Start the 32-bit version of Microsoft ODBC Data Source Administrator program. (C:\Windows\SysWOW64\odbcad32.exe)
5) Click "Driver" tab and verify the MySQL ODBC 5.3 ANSI Driver was installed.
6) Click on "User DSN" tab and click the "Add" button
7) Select the MySQL ODBC 5.3 ANSI Driver from list. This opens up a pop up window for the MySQL Connector Configurator
8) Enter "myODBC" for the Data Source Name
10) Enter "5.3 ANSI" for Description
11) Enter "localhost" as TCP/IP Server
12) Leave the Port address of "3306" unchanged.
13) Enter "root" for User.
14) Enter your root password.
15) Select the database "trainning" from drop down list. If no drop down list, check user name and password.
16) Click on Test button should get "Connection Successful"
17) Clicked on Ok button and configuration window closes.
18) Clicked on OK and the Microsoft ODBC Data Source Administrator program closes.
19) Open IWS. Open the demo project "MySQLDemo2.APP"
20) Select "Project" tab.
21) Select "Options" on the ribbon,
22) Click on "Default Database".
23) This demo program should already be configured. Database = Primary.
24) Connection string = "Provider=MSDASQL.1; Data Source = myODBC; Initial Catalog = “trainning". The string "MSDASQL" comes from the provider name configured in C:\Windows\Program Files (x86)\Indusoft Web Studio v7.1\Bin\StADOSvr.ini. Note: The IWS v7.1+SP3 Technical Reference on page 634 says to directly enter a connection string. But, this demo application used the "click" method. Click on button for the dialog box on the right.
25) The data source name = "myODBC". (Should already be entered).
26) Change User name from "user" to "root", enter password.
27) Enter the initial catalog to use = "trainning". The catalog name is the SQL database name. (Should already be entered).
28) Click on "Test Connection" button and it should say "Test connection succeeded". Click on "OK"
29) Click on "OK" to close the "Data Link Properties" dialog box.
30) Verify User name is "root", enter password again.
31) Click on the "Advanced" button. Opens the Advanced dialog box. Host = "127.0.0.1". Port = "3997". The "Database Gateway" is the Studio Database Gateway. (IWS v7.1+SP3 Technical Reference on page 609)
32) Click on "OK" to close the "Advanced" dialog box.
33) Click on "OK" to close the "Default Database Configuration" dialog box.
34) Click on the "Alarm Database" button. Verify Database = Primary. Verify "Use project default", "Use default name", and "Automatically create" are all checked. Click on "OK" to close dialog box.
35) Click on the "Event Database" button. Verify Database = Primary. Verify "Use project default", "Use default name", and "Automatically create" are all checked. Click on "OK" to close dialog box.
36) Open screen "client.scr". Right Click on the grid. Select Properties. Click on the "Data source settings" button. Verify Database = Primary. Verify "Use project default" and "Automatically create" are both checked. Table Name = "clients". Click on "OK" to close dialog box.
37) Open screen "products.scr". Right Click on the grid. Select Properties. Click on the "Data source settings" button. Verify Database = Primary. Verify "Use project default" and "Automatically create" are both checked. Table Name = "products". Click on "OK" to close dialog box.
38) Open screen "sales.scr". Right Click on the grid. Select Properties. Click on the "Data source settings" button. Verify Database = Primary. Verify "Use project default" and "Automatically create" are both checked. Table Name = "[qry_sales] ". Click on "OK" to close dialog box.
39) Open screen "sales_report.scr". Right Click on the grid. Select Properties. Click on the "Data source settings" button. Verify Database = Primary. Verify "Use project default" and "Automatically create" are both checked. Table Name = "[qry_total_by_name] ". Click on "OK" to close dialog box.
40) After being run once, uncheck "Automatically create" boxes.
