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.

Choosing a provider for SQL Server and MySQL databases
Last Post 01 Feb 2019 12:03 PM by Aveek. 0 Replies.
Printer Friendly
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
AveekUser is Offline
Senior Member
Senior Member

01 Feb 2019 12:03 PM
    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"'.

    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;
    You are not authorized to post a reply.