Help files

Connection Strings and Drivers

Through the "Open SQL Connection" Action, the user can define the connection string to connect to any kind of SQL database, as long as there is the proper ODBC driver installed.

More connection strings for any kind of Database can be found in the link below:

www.connectionstrings.com

Of course you are free to use variables in any connection string like for example:

Server=%ServerAddress%;Database=%myDataBase%;User Id=%Username%;Password=%Password%;

or

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%ExcelFile%;Extended Properties="Excel 12.0 Xml;HDR=YES";

Most common Drivers List:

You must download and install the appropriate drivers from the list below according to the database that you want to connect to:

Microsoft Data Access Components (MDAC) 2.8 SP1

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access Database Engine 2016 Redistributable

SQLite ODBC Driver

https://dev.mysql.com/downloads/connector/odbc/

https://dev.mysql.com/downloads/connector/odbc/5.1.html (For previous generally available ODBC connectors. Make sure that you download the correct one according to your machine characteristics 32-bit or 64-bit)

PostgreSQL ODBC Drivers

For Process Development tips regarding SQL queries and Connection Strings, click on the following link:

https://support.softomotive.com/support/solutions/articles/35000106850-tips-on-sql-queries-and-connection-strings