Use the Database Engine tab in the Create New Project Wizard window to define your customized database settings. (Advanced users only.)
Applies to: Borehole Manager
! The Database Engine tab will be displayed only if you've selected the Customize the Database Engine option on the Folder tab.
Tip: If you're using a non-standard database setup, you can establish these settings in the main program configuration window so that they'll be the defaults.
Back to new-project introduction | Next: Project template settings. (Optional)
Menu Options
- Database Engine: Choose the engine that will be delivering the data to RockWorks.
- SQLite: This is the default database type for RockWorks, with built-in support through RockWorks. This will create a local database in the project folder. You can choose this default database even if you are working with RockWorks15-16 projects which used an ".MDB" database - they will be updated automatically.
- Microsoft SQL Server: If you wish to store your RockWorks database in a MS SQL Server database, choose this option. This requires that you have SQL Server installed on your network.
- Server: If you've selected Microsoft SQL Server, select the SQL Server instance supplying the data. Usually this is the name of the computer the server runs on. For SQL Server Express 2008 the value for the Server may be the name of the local machine where it is installed. For SQL Server 2005 it may be just the name of the server. The database server may contain multiple databases.
- Show Login Prompt: Insert a check here if your database is set up to require a login and password and if, when creating or opening a project, you wish to be prompted to enter the login information. Leave this unchecked if your SQL Server is configured to pass through your network login (Windows NT Integrated Security) and the database login prompt does not need to be shown.
- Here's some background information. Two authentication modes are available when connecting to an instance of SQL Server Database Engine:
- Windows Authentication Mode (Windows NT Integrated Security) - Microsoft Windows Authentication mode allows a user to connect through a Windows user account.
- SQL Server Authentication - When a user connects with a specified login name and password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails, and the user receives an error message.
- Security Note: When possible, use Windows Authentication.
- If Show Login Prompt is checked it is assumed you are using a database login and not your Windows network login, and an ID and password prompt will be displayed.
If Show Login Prompt is unchecked it is assumed your network login is to be used, and no prompt will be displayed.
- Prompt for Data Source: Allows you to edit the connection to your database in case you need to fine-tune some settings. This prompt is only shown during the setup of a new project, if you need to edit it afterwards you can edit the connection string that is stored in the project’s configuration file "Menu.ini". If activated, the program will display a Connection window prior to creating the new project database. In the Connection window, you'll see these buttons:
- Choose: Click this button to select the data provider.
- Provider: Click on the Provider tab to select the data provider name. For example, if you are using a SQL database, choose Microsoft OLE DB Provider for SQL Server.
- Connection: On the Connection tab, browse for the server name.
- Load: Use this button to load configuration settings already stored.
- Save: Use this button to save the current configuration settings.
- Generate a SQL Script File without executing it: Will save the SQL script it generates instead of executing it, creating the database. So by choosing this option the database will not be created, instead it will leave you back at the project you started with. This allows greater control on where and how the database is created or handing off the script off to a Database Administrator to run if you do not have create rights in your database server for a new database or tables.
- Save these settings as the default values: Check this box for the above settings to become default for the next new-project process. These settings are stored with other global menu items, and can also be accessed in the Preferences | Program Settings window.
- Click the Next button.
Back to new-project introduction | Next: Project template settings (Optional)
RockWare home page