Database Connections

The Movicon.NExT I/O Data Server module connects to databases using ADO.NET by means of two Data Providers: the Xpo Provider or the .NET Framework Provider.

Thanks to these two Data Providers, the application is completely independent from the type of database used, and the connection strings can be customized in the appropriate configuration properties in order to use your preferred database.

The use of one Data Provider compared to another depends on which resource accesses the database:

• Xpo Provider = Historian, Event Log, Audit, Recipes

• NET Framework Provider = Datalogger

Xpo Provider Connection Strings (Historian, EventLog, Recipes, Audit)

The Xpo Provider connection strings are used by the Historian, Event Log, Audit and Recipes resources.  They can be configured using the wizard shown in the screen shot below:

This wizard allows you to quickly configure the indicated default databases:

• SQL Server

• SQL Azure

• MySQl

• SQLite

Movicon.NExT fully supports connections with the DB indicated in the below table:

.NET Framework Connection Strings (Datalogger)

The .NET Framework Provider connection strings are used by the Datalogger resource, and can be defined using the wizard shown in the screen shot below:

This wizard allows fast configuration of the ODBC, Access, SQL Server, MySQl, SQLite and Oracle data sources.