Installing NerveCenter - Setting Up the Database on Windows - Connecting to an Existing Database -
Creating an Access Database Doing Silent and Remote Installations on Windows

Connecting to an Existing Database

If you already have a version 3.8 NerveCenter database, or if you installed NerveCenter 3.8 in a new location, you can configure the ODBC data source and connection string to point to this database.

Upgrading to NerveCenter 3.8

The steps for a SQL database and an Access database are slightly different.

For a SQL database, see Connecting to a SQL Database.
For an Access database, see Connecting to an Access Database.

Connecting to a SQL Database

Follow these instructions to point to a SQL database:

From the Start menu, select DBWizard.
The Start dialog box displays.
Select Create Data Source and Connection String.
To load predefined or default values, select the Load IDB File button.
An IDB file contains settings used during this install. If you are re-running DBWizard, you can load an existing IDB file to save time.
The Open dialog box displays.
1. Select an IDB file from the NerveCenter Db folder. (If you haven't created one before, select InstallDB.idb. This file contains default settings.)
2. Select Open to load the file.
  This returns you to the Start dialog box.
Select the Next button.
The Select Database dialog box displays.
Select Microsoft SQL Server as the database type.
Select the Next button.
The ODBC Data Source dialog box displays.
Type in an ODBC data source name.
Select the Next button.
The SQL Server Information dialog box displays. Provide the host name, user ID, password, and database name for the SQL database.
Select the Next button.
The Finish dialog box displays.
To create the ODBC data source and connection string for the database you just specified, check the Create and Execute InstallDB checkbox.
If you need to repeat this process on different machines, check the Create InstallDB command file with name checkbox and provide a file name in the text box. InstallDB will create another IDB file that saves the settings that you used in this install. You can then load this new IDB file into the InstallDB wizard when you run it on the other machines.
Select the Next button.
The Events Status dialog box displays. It lists the settings that you have specified.
Verify that all the settings are correct. If necessary, you can use the Back button to return to previous dialog boxes and make corrections.
When everything is correct, select the Finish button.
The Status Screen dialog box displays with status information.

When the installation is complete, select the OK button to exit DBWizard.

Connecting to an Access Database

Follow these instructions to point to an Access database:

From the Start menu, select DBWizard.
The Start dialog box displays.
Select Create Data Source and Connection String.
To load predefined or default values, select the Load IDB File button.
An IDB file contains settings used during this install. If you are re-running DBWizard, you can load an existing IDB file to save time.
The Open dialog box displays.
1. Select an IDB file from the NerveCenter Db folder. (If you haven't created one before, select InstallDB.idb. This file contains default settings.)
2. Select Open to load the file.
  This returns you to the Start dialog box.
Select the Next button.
The Select Database dialog box displays.
Select Access as the database type.
Select the Next button.
The ODBC Data Source dialog box displays.
Type in an ODBC data source name.
Type in the location of the Access database.
Select the Next button.
The Finish dialog box displays.
To create the ODBC data source and connection string for the database you just specified, check the Create and Execute InstallDB checkbox.
If you need to repeat this process on different machines, check the Create InstallDB command file with name checkbox and provide a file name in the text box. InstallDB will create another IDB file that saves the settings that you used in this install. You can then load this new IDB file into the InstallDB wizard when you run it on the other machines.
Select the Next button.
The Events Status dialog box displays. It lists the settings that you have specified.
Verify that all the settings are correct. If necessary, you can use the Back button to return to previous dialog boxes and make corrections.
When everything is correct, select the Finish button.
The Status Screen dialog box displays with status information.

When the installation is complete, select the OK button to exit DBWizard.

Creating an Access Database	Doing Silent and Remote Installations on Windows
	29 July 2003