Hi,

I'm trying to make work the example project to be able to read/write to MySQL Database.

I have the driver installed, and it test ok with my DB '' test_vrod''  See Picture 1

The only change I have made in the exanple project is the conn.Open.

In th original project it is : conn.Open "Provider=MSDASQL;DSN="&Database_Name&"" 'DSN= name of the odbc-database - DSN= Name der ODBC-Datenbank

Also in the original project it was for an access to Microsoft server DB.

In my case i need to do the same but with MySQL DB.

The only change I have made is that : conn.Open "Driver={MySQL ODBC 8.0 Unicode Driver};SERVER=172.16.3.21;DATABASE=test_vrod;PORT=3306;UID=user;PWD=leger12345678;"

When i try to make a reading of a table, I have this error. See picture 2

Thank for yout help.

Hi, I got the application example fully working using the procedure below.

• Install Windows updates
• Install .NET framework 4.5.2 if not present (pre-requisite for MySQL)
• Install WinCC Runtime Advanced 15
• Install all MySQL packages using the MySQL Installer 8.0.17 web installer: https://dev.mysql.com/downloads/file/?id=488054
• apply any upgrades suggested during installation
• setup type is: developer default (other setup types may also work)
• click Next for the failing requirements check and click Yes to not install these components (Excel etc)
• Many components may fail the installation initially.  Keep clicking "Try again" until they all install.
• MySQL server setup (part of mySQL installer):
• MySQL server configuration: Standalone MySQL Server, config type = server computer.  Leave all other details default.
  • Use strong password encryption.
  • select a root password and create a db admin user for the ODBC access: in this example, wincc_mysql / wincc@ccess
  • all other settings are default.
  • Install the Connector/ODBC 8.0.17, 32-bit version.  This is required because WinCC Advanced runs in 32 bit mode.  location: https://dev.mysql.com/downloads/file/?id=488707
• Set up the ODBC connection:
  • run Data sources (ODBC): you MUST run the following file exactly: c:\windows\sysWOW64\odbcad32.exe
  • add user DSN
  • MySQL 8.0 Unicode Driver
  • DSN = Database_1 (to match what's in the WinCC example project)
  • tcp/ip server = localhost
  • user wincc_mysql  / wincc@ccess
  • database=blank
  • click test, it should succeed
  • OK

• restore the project example from here and convert to your version of TIA:
• https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script-?dti=0&lc=en-US
• Change the RT Advanced Device from V14 to the correct version to match the Runtime installation above.
• the following script modifications are required:
  • For all queries/ commands, add a ; to the end.
  • for all connection strings, where "Initial Catalog" exists in the connection string, replace it with "Database"
  • additionally for the copy table script (actually copy contents of table), change the query to:
    • "Insert into " & SmartTags("szNewTableName") & " select * from " & SmartTags("szTableName") & ";"

Deploy WinCC project and test.