MySQL connection via System-DSN

OL Connect Professional Workflow
1

Hello,

I want to open an external mysql database. So i can save information from my VBscript.
How can I create the connection by using a System-DSN?

Thx for your help

Rolf

2

Welcome into our forum.

You can look at the following examples found on the web:

https://www.codesanook.com/connect-mysql-with-vb-script
https://forums.nicelabel.com/viewtopic.php?t=886
https://www.makeuseof.com/create-a-vb-script-odbc-connection/ (step by step) :wink:

3

Thx for the links

in the end I used the connection string from database import and I created a SystemDNS via
MySQL ODBC 8.0 Unicode Driver (MYODBC8W.DLL)

ConnectString = “DSN=OL2MySQL32;DESCRIPTION=OL zur MySQL Datenbank;SERVER=yourserver;UID=youruser;PWD=yourpassword;DATABASE=yourdatabase;PORT=3306”
con.open ConnectString