To insert a new SQL Server Database, follow these procedures:
1.Right-click the project's name in Explorer and select the Insert - Database option. In Domain mode, right-click the Server objects - Databases item, select the Insert Database In option, and then the project's name. The object is then created and its script edition window is opened.
2.To configure it, select the Configuration tab on the Properties Window.
Configuration for SQL Server Databases
The available options on this tab are described on the next table.
Available options for the Configuration tab
Option |
Description |
|---|---|
Database |
Selects the type of Database to use in this project. Possible values for this option are 0: stAccess, 1: stOracle, 2: stSqlServer, 3: stPostgreSQL, or 4: stMySQL. This option corresponds to the SourceType property of a Database object |
Server |
Server name |
Database |
Database name |
Network Library |
Network library used by ADO. Possible values for this option are 0: Default, 1: Named Pipes, 2: Winsock TCP/IP, 3: SPX/IPX, 4: Banyan Vines, or 5: Multi-Protocol (RCP). This option corresponds to the MsSQLNetworkLibrary property of a Database object |
Provider |
Selects an OLE DB data provider for accessing an SQL Server. Possible values for this option are 1: SQLOLEDB or 2: MSOLEDBSQL (default). Please check the next note for more information. This option corresponds to the MsSQLProvider property of a Database object |
Change connection string |
This option allows changing the String to connect to a SQL Server database. The following restrictions apply to this option: •Performed changes ARE NOT validated by Elipse E3. Therefore, users are fully responsible for configuring this customized String correctly •If this option is not selected, Elipse E3 uses a default format to perform this connection •This connection String accepts the {SERVER} macro, which is replaced by server's name configured in the Server option, and the {DB} macro, which is replaced by database's name configured in the Database option This option corresponds to the UseCustomConnectionString property of a Database object and the edition field of the connection String corresponds to the CustomConnectionString property of a Database object |
User |
User of the database connected via Elipse E3. Depending on the type of object to use in a project, they must have different kinds of permissions. This option corresponds to the UserName property of a Database object |
Password |
Password of the user performing the logon |
Test Connection |
Tests the connection with a SQL Server |
NOTE |
The option for an SQLOLEDB data provider is now deprecated by Microsoft and should not be used. However, applications created in versions previous to version 6.0 keep working normally. In case of updating these applications to version 6.0, Elipse E3 automatically adds to the connection String the compatibility parameter "DataTypeCompatibility=80". |
3.In the Database option, select the 2 - stSqlServer item.
4.If necessary, configure the User and Password options according to SQL Server's definitions. These options may remain blank and, in this case, an application assumes Elipse E3's default settings.
5.Click Test Connection to check whether these settings are correct and then click OK to save these settings.