In the Connection and Backend Settings screen you should specify the connection settings for your application. The Connection and Backend Settings screen is shown on the snapshot below:
The Connection and Backend Settings screen contains the following settings:
Connection Settings (3) - OpenAccess ORM currently supports two ways of defining the connection information:
- ConnectionId (1) - the id you specify here is a Connection Id that refers to a section within the configuration file. This section contains information that is required to establish a connection to a server and a database. Practically this is the connection string name.
- Backend (2) - choose the database backend. You have the following options:
- OpenAccess to MS SQL Server 2000 / MSDE - your client application connects to Microsoft SQL Server 2000 or Microsoft SQL Server Desktop Edition (MSDE).
- OpenAccess to MS SQL Server 2005 / EXPRESS - your client application connects to Microsoft SQL Server 2005 or Microsoft SQL Server Express Edition.
- OpenAccess to Oracle (version 9.2 or higher) - your client application connects to Oracle 9.2 or higher.
- OpenAccess to MySQL 5.0 - your client application connects to MySQL 5.0 (version 5.0.19 or higher).
- OpenAccess to Advantage Database Server (version 8.1) - your client application connects to Advantage Database Server 8.1.
- OpenAccess to SQL Anywhere Server - your client application connects to SQL Anywhere Server (OpenAccess supports and has been tested on SQL Anywhere Version 10).
- OpenAccess to Firebird Server - your client application connects to Firebird Server (OpenAccess supports only Firebird Server Version 2.0 and it has been tested on the same.
- OpenAccess to SQL Azure - your client application connects to the SQL Azure cloud database server.
- OpenAccess to Microsoft SQL Server CE - your client application connects to a Microsoft SQL CE in-memory database server.
- OpenAccess to VistaDB - your client application connects to a VistaDB in-memory database engine.
New Connection (4) - pressing this button will open the New Connection dialog, where you should specify database settings such as: server name, windows or sql authentication, user name and password, database name.
- Using standard connection settings(Web.Config or App.config) – additionally to some information required inside the connection node in the "openaccess" section, a standard connection string is added to the "connectionStrings" section of the .config file, and later can be used by the OpenAccess runtime and can be overridden in the application .config file (if already defined inside the model library project). Selecting and working with this option will result in the following changes regarding the connection node definition inside the "openaccess" section of the config file:
"> <references />
<connectionString>Data Source=server name;Initial Catalog=Northwind;Integrated Security=True</connectionString>
<backendconfiguration id="mssqlConfiguration" backend="mssql">
<mapping id="mssqlMapping" />
- Using OpenAccess ORM connection settings – this approach is used in previous versions of OpenAccess and is the default way of handling the connection information (everything is defined inside a connection node in the "openaccess" section).
If you choose this option, then you should fill the following fields:
- Server Name - this specifies the host name where the database server is running.
- Use integrated security - the generic ADO2 and ODP drivers support integrated security. However, the genericADO2 driver, the MySQL, the Advantage Database Server, the SQL Anywhere Server and the Firebird Server backends do not support integrated security.
- SQL User - this textBox is required to be filled, when the "Use Integrated Security" is unchecked or disabled due to the backend or the driver being used, i.e., integrated security is set to false for your project.
The username and password are also written to the App.config file. This is necessary for providing appropriate information during development time to support the OpenAccess wizards and for post-compile steps.
- SQL Password - this textBox is required to be filled, when the "Use Integrated Security" is unchecked or disabled, i.e., integrated security is set to false for your project.
- Database Name - in this field, specify the database name that your application will use to identify the database.
- Test Connection - press this button to verify the settings set above. It will try to establish a database connection with the current settings. A sample output when you verifying your connection settings is shown on the next snapshot.
The Connection and Backend Settings screen offers you the following navigation options:
- Help Button - clicking the help button will navigate you to the help page.
- Expert Button - clicking the expert button will open the Expert Wizard dialog, which is described later in this section.
- Back Button - clicking the back button will navigate you to the previous step in the Enable Project wizard.
- Next Button - clicking the next button will navigate you to the next step in the Enable Project wizard.
- Cancel Button - clicking the cancel button will cancel the wizard.