Project ODBC Plugins

Movicon manages ODBC connection creations using the plugins contained in a Movicon installation subfolder called "ODBCMgr".

When in the process of creating a new project using the wizard ("DataBase Settings (ODBC)"), you will be asked to choose which database format to use for default. The options are:

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

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

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

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

• SQLServer2000: MS SQL Server 2000 (uses the "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)

• SQLServer2016: MS SQL Server 2016 (uses the  "SQL Native Client 11.0"   driver)

• SQLServerExp2016: MS SQL Express 2016 (uses the " SQL Native Client 11.0"  driver)

Once the project has been created with wizard, the chosen default plugin (using the " DataBase Settings (ODBC)" window) will be indicated in the project's  "Plugin ODBC Default" property and can be changed afterwards if need be. The  "Settings ODBC" command in the project's General properties allow you to modify the connection parameters, in the same way as the wizard's "Customize ODBC Settings" command.  these parameters are saved in the "pluginname.settings" configuration file (i.e. SQLExpress2005.settings) in the ODBCMgr. folder. The configuration xml file structure type will be:

<?xml version="1.0" encoding="UTF-16"?>

<parameters>

<ID text="Driver">SQL Server</ID>

<ID text="SERVER">PCTEST\SQL2000</ID>

<ID text="DATABASE">prjSql2000</ID>

<ID text="Trusted_Connection">yes</ID>

<ID text="Description"></ID>

</parameters>

"The first time the project is launched into runtime, the ODBC DSN connection will not exist immediately and the settings file, saved in the project's "DATA" folder to enable the parameters to become specific to that project, will be used by Movicon to create it.  Once created the configuration parameters in the default ODBC plugin will be ignored.

MSAccess is used as a default value for those projects created with the Template or Empty Project wizard or those projects pre-existing without being defined with the  "Plugin ODBC di Default" property.