English (United States)
Call us! 512-349-0334 or (877) INDUSOFT

InduSoft Web Studio Forums

Find additional forum posts in in the Forum Archives. For assistance view the Forum Frequently Asked Questions.

Maria in a Nutshell
Last Post 11 Oct 2019 01:31 PM by Aveek. 3 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
Wild BullUser is Offline
Basic Member
Basic Member
Posts:12


--
17 Apr 2019 01:23 PM
    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.




    Wild BullUser is Offline
    Basic Member
    Basic Member
    Posts:12


    --
    18 Apr 2019 07:04 AM
    MySQL ODBC Connector version 8.0 driver does not work with MariaDB and Indusoft.
    Will test the version 8.0 connector with MySQL.

    BTW, "My" is the name of Monty Widenius first daughter and "Maria" is his second daughter
    Wild BullUser is Offline
    Basic Member
    Basic Member
    Posts:12


    --
    24 Apr 2019 12:47 PM
    MySQL ODBC Connector version 8.0 does not work with MySQL 8.0 but the 5.3 version connector works fine with MySQL 8.0
    AveekUser is Offline
    Senior Member
    Senior Member
    Posts:171


    --
    11 Oct 2019 01:31 PM
    Very useful for MariaDB users, thank you for posting this.
    You are not authorized to post a reply.