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 one 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 defined 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

As an alternative, you can also use other DBs whereby the Xpo Provider connection strings must be defined manually and then be inserted in the "Default Historical Connection", " Event Log Connection", " Default Audit Trail Connection" of the Advanced Server Settings.  

Check to see that the installed DevExpress version in the “C:\Program Files\Progea\Movicon.NExT 4.2” path matches the version displayed on the DevExpress website.

Please also refer to this website for DB connection strings using this link: "DevExpress Connection String" .

.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.