Create an ODBC data source on 64-bit computers

An ODBC driver is a software standard that lets different applications share data. There are ODBC drivers for Microsoft® SQL Server™, Microsoft Access, Oracle® and many others. The ODBC driver lets you define information for connecting to databases in SQL Server, including the directory source name (DSN), directory, driver of the database, and the ID and password of the user.

Note: If you are using a computer with a 64-bit operating system, you need to use the steps below to set up an ODBC data source for the system's database, instead of creating and configuring the data source during the FH CAD Monitor installation process.

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?, at http://pcsupport.about.com/od/fixtheproblem/f/32-bit-64-bit-windows.htm.

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

  2. Double-click odbcad32.exe.

    The ODBC Data Source Administrator dialog box appears.

  3. Click the System DSN tab.

  4. Click Add.

    The Create New Data Source dialog box appears.

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

    The Create a New Data Source to SQL Server wizard appears.

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

    Example: ODBC data source

  7. 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

  8. Click Next >.

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

  9. 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.

  10. Click Next >.

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

  11. Select Change the default database to, and then choose the name of your FIREHOUSE Software database from the menu below it.

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

  12. 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.

  13. Click Finish.

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

  14. Click Test Data Source.

    The SQL Server ODBC Data Source Test dialog box appears.

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

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

  18. Depending on whether or not you installed FH CAD Monitor as a service, do one of the following.

    Installed as a service? Do this
    No
    Yes