DataBase Settings (ODBC)

When you create a new project, you will be able to set the "DataBase Settings (ODBC)" to define which ODBC connection Movicon will use for default to record data inherent to the Historical Log and the Variable Trace.

In this phase, you will be able to select the provider you wish to use from  the combo-box and then configure its parameters by using the mask which opens with the "Customize ODBC Settings" command. This selection will then be associated to the project's  "Plugin ODBC Default" property which can be changed  afterwards.

The ODBC drivers to choose from  are:

• MSAccess: MS Access (uses the "Microsoft Access Driver (*.mdb)" driver and is the predefined choice)

• MySQL: MySQL 5.1 (uses the driver installed with this MySQL version)

• OracleEx10: Oracle Express (uses the  client-less driver installed with this Oracle version)

• Oracle11g: Oracle Express 11 (uses the client-less driver installed with this Oracle version)

• SQLServer2000: MS SQL Server 2000 (uses "SQL Server" driver)

• SQLServer2005: MS SQL Server 2005 (uses the "SQL Native Client" driver)

• SQLServer2008: MS SQL Server 2008 (uses the "SQL Native Client 10.0" driver)

• SQLServerExp2000: MS SQL Express 2005 (uses the "SQL Native Client" driver)

• SQLServerExp2008: MS SQL Express 2008 (uses the "SQL Native Client 10.0" driver)

• SQLServer2012: MS SQL Server 2012 (uses the "SQL Native Client 11.0" driver)

• SQLServerExp2012: MS SQL Express 2012 (uses the " SQL Native Client 11.0" driver)

• SQLServer2014: MS SQL Server 2014 (uses the  "SQL Native Client 11.0"  driver)

• SQLServerExp2014: MS SQL Express 2014 (uses the " SQL Native Client 11.0" driver )

Naturally, in order to use one of above listed providers you will need to install its relating ODBC driver on your machine beforehand. "MsAccess" is the only native Operating System driver.

The "Customize ODBC Settings" button permits you to set some specific connection parameters for each plugin, such as the driver or the database instance name. If you already know the values of these parameters, this is the best time to set them. When pressing the "Next" button a connection test is carried out after which the set parameters will be reviewed if failed. You can, however, proceed with running the wizard independently from the test result.

For further information please refer to sections:  "Project ODBC Plugin " and "ODBC Plugin list".