Create a New RockWorks Project - Advanced Database Options

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.

Back to new-project introduction | Next: Project template settings. (Optional)

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 with the same name as the folder and a ".sqlite" file name extension. 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.
- MS Access: This option will generate a Microsoft Access (.MDB) database for the project in the local folder, with the same name as the folder an an ".MDB" file name extension.
  ! This requires that you have the correct drivers installed on your computer, either through Microsoft Access or separate DLL's. MDB database support is not included with RockWorks. See Troubleshooting for more information.
- 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: 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.
  - Database: Select the name of the database for the project.
  - Use Trusted Connection
    - Check this if your SQL Server is configured to pass through your network login (Windows NT Integrated Security). This Windows Authentication is the preferred method, if possible within your server setup.
    - Uncheck this if SQL Server logins are required when creating or opening a project. Click the Advanced button and enter the User Name and Password into their respective prompts (in the long list) as part of the connection settings to the database.
  - 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.
Click the Next button.

Setup | Other Preferences for storing some of these defaults for future projects.

Back to new-project introduction | Next: Project template settings (Optional)

RockWare home page