This FAQ helps you choose the correct provider for InduSoft to communicate with your SQL Server database or MySQL database.
In general, the Studio Database Gateway works best with OLE DB providers. If you are attempting to communicate with a database other than SQL Server or MySQL, first look for an OLE DB provider to use. If an OLE DB provider does not exist, then the next best option is to use a 32 bit .NET provider or connector.
Microsoft SQL Server
When you go to setup your database connection two options become relevant for SQL Server, 'SQL Server Native Client' and 'Microsoft OLE DB Provider for SQL Server'. You will want to choose 'Microsoft OLE DB Provider for SQL Server'.
Using 'SQL Server Native Client' can cause odd behavior and throw error messages when trying to write to the database such as 'Must declare the scalar variable "@Value0"'.
MySQL
It is best to use the .NET Connector provided by MySQL to speak to a MySQL database. You need to install the 32 bit x86 version of the connector, it can be found here as of the time of this FAQ https://dev.mysql.com/downloads/connector/net/.
The connection string for MySQL databases must be created manually. The structure of a typical connection string looks like:
Provider=MYSQLCLIENT; Server=myServerAddress; Database=myDataBase; Uid=myUsername; Pwd=myPassword;