Create a FIREHOUSE Software ODBC data source

When you configured FH CAD Monitor, in the FIREHOUSE Software CAD Monitor Options dialog box, on the Database tab, under FIREHOUSE Software Database, you had the option to select the type of FIREHOUSE Software database you are using. If you selected Update remote database through ODBC data source, you must set up an additional ODBC data source for your FIREHOUSE Software database.

  1. Depending whether you are using a 32-bit or 64-bit operating system, do one of the following.

    1. In Windows Explorer, navigate to C:\Windows\syswow64\.

    2. Double-click odbcad32.exe.

      The ODBC Data Source Administrator dialog box appears.

    1. Choose Start → Settings → Control Panel.

      The Control Panel window appears.

    2. Double-click Administrative Tools.

      The Administrative Tools window appears.

    3. Double-click Data Sources (ODBC).

      The ODBC Data Source Administrator dialog box appears.

    Tip: If you are unsure as to whether you are using 32-bit or 64-bit operating system, information on determining this for a number of operating systems is available in Am I Running a 32-bit or 64-bit Version of Windows?.

  2. Click the System DSN tab.

  3. Click Add.

    The Create New Data Source dialog box appears.

  4. Scroll down through the list and select SQL Server, and then click Finish.

    The Create a New Data Source to SQL Server dialog box appears.

  5. In Name and Description, type a name and a description for the ODBC data source you are creating for FIREHOUSE Software.

    Example: FIREHOUSE Software ODBC data source

  6. From Server, select the name of the SQL server your FIREHOUSE Software database exists on.

    Caution: Include the full name of the SQL instance where the FIREHOUSE Software database exists.

    Example: SERVER1\SQLEXPRESS

  7. Click Next >.

    The next screen of the Create a New Data Source to SQL Server wizard appears.

  8. Define which SQL Server login credentials to use in one of the following ways.

    • Select With Windows NT authentication using the network login ID.

      Note: This option is only available for Windows networks, and the logged-in user must have an SQL security login added for their Windows login.

      Example: advsetup@sqlserv

    1. Select With SQL Server authentication using a login ID and password entered by the user.
    2. Select or clear Connect to SQL Server to obtain default settings for the additional configuration options to indicate whether or not to use default settings from SQL Server.
    3. (If you selected Connect to SQL Server to obtain default settings for the additional configuration options) In Login ID and Password, enter the user name and password for SQL Server.

    Warning: Do not click Client Configuration and change the connection parameters between FH CAD Monitor and the SQL server your FIREHOUSE Software database is on.

  9. Click Next >.

    The next screen of the Create a New Data Source to SQL Server wizard appears.

  10. Select Change the default database to, and then choose the name of the FIREHOUSE Software database the ODBC data source you are creating will work with.

    Warning: Do not change any of the other settings on this screen of the wizard.

  11. Click Next >.

    The next screen of the Create a New Data Source to SQL Server wizard appears.

    Warning: Do not change any settings on this screen of the wizard.

  12. Click Finish.

    The ODBC data source is created, and the ODBC Microsoft SQL Server Setup dialog box appears.

  13. Click Test Data Source.

    The SQL Server ODBC Data Source Test dialog box appears.

  14. Click OK.
  15. In the ODBC Microsoft SQL Server Setup dialog box, click OK.

  16. In the ODBC Data source Administrator dialog box, click OK.