Connect to a Configuration Database

The Configuration Database is a Microsoft SQL Server database that will be used to store the Micromine Geobank configuration tables. A connection to a configuration database must be established the first time Micromine Geobank is run.

When you start the application for the first time, a blank login screen is displayed.

To add a connection to a configuration database:

  1. Click the Add button to add a database connection.

    2. The Connection Property Editor is opened:

  2. Enter a Name and Description for the configuration database, then click the Connection Properties link.

    3. WARNING: Subsequently changing the Name of this Connection will cause any Scheduled Jobs that use this Connection to no longer work as expected. Ensure the name you initially enter is the name you intend to use and only change the name if there are no scheduled jobs, or if you plan to manually update those scheduled jobs.

    Any other usage of the Micromine Geobank command line, such as shortcuts, may also be affected by a name change.

  3. Click Build... to define the ADO connection string.

    4. When a blank database is added as a new datasource, table name and column name mapping tables are created automatically

  4. In the Data Link Properties dialog, on the Provider tab, select the version of the SQL Native Client. The version of the native client will vary depending on the version of SQL Server you have installed. Currently, the default provider is Microsoft SQL Server Native Client 11.0.

    5. For best results, use the SQL Server Native Client available on your machine.

    The Provider tab in the Data Link Properties form

  5. On the Connection tab:
    1. Select the name of the data source that points to the instance of SQL Server (using the servername\instance format). You should use the Micromine Geobank configuration database server name here. The example shown below in the Data Link Properties dialog is for a networked configuration database. If you are using a local database server, the server name will be localhost\sqlexpress2008.
    2. Select Use Windows NT integrated security to allow access to the database based on your windows login details. Otherwise provide the login User Name and Password needed to access the database.
    3. Select the configuration database that you want to connect to. This should be provided by your system administrator.

      4. Click Test Connection.

    4. Click OK on the SQL Server Native Client Data Link dialog, then click OK on the Data Link Properties dialog to save the ADO Connection String properties and return to the Configuration Property Editor.
  6. Click on Environment Settings to review or change Date and Time format settings, and the timeout values for the database connection and Micromine Geobank commands. See:Database Connection Environment
  7. Click on Database Options to setup options for the interaction between the SQL Server software and the database. See: Database Options