During the process of creating a new borehole project, you are offered the choice of the type of database to be created. The default type is a SQLite Database (.SDB file). However, RockWorks also supports work with other database providers, such as SQL. You can access these settings by inserting a check-mark in the Customize Database Engine (Advanced) check-box in the Create New Project window.
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.
- 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 connect to 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 Authentication) 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 an Edit Database Connection window prior to creating the new project database.
- Edit Data Source: Click this button to manually type in the name of the Database, server name, etc.
- 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 | General Program Settings window.
RockWare home page