Create an ODBC information source on 64-bit computers

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

Annotation: If you are using a reckoner with a 64-fleck operating system, you demand to use the steps below to prepare an ODBC information source for the arrangement's database, instead of creating and configuring the data source during the FH CAD Monitor installation process.

Tip: If y'all are unsure as to whether you are using 32-bit or 64-bit operating organisation, 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.nigh.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 Arrangement DSN tab.

  4. Click Add.

    The Create New Data Source dialog box appears.

  5. Whorl down through the list and select SQL Server, and and so click Finish.

    The Create a New Information Source to SQL Server sorcerer appears.

  6. In Proper noun and Clarification, blazon the proper name and a clarification for the ODBC information source you lot are creating.

    Case: ODBC information source

  7. From Server, select the proper noun of the SQL server your FIREHOUSE Software database exists on.

    Circumspection: Include the full proper name of the SQL example where the FIREHOUSE Software database exists.

    Instance: SERVER1\SQLEXPRESS

  8. Click Next >.

    The side by side screen of the Create a New Information Source to SQL Server wizard appears.

  9. Ascertain which SQL Server login credentials to use in one of the following ways.

    ClosedThe current or active Windows user account

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

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

      Case: advsetup@sqlserv

    ClosedUnique SQL Server login credentials

    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 point 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 proper noun and password for SQL Server.

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

  10. Click Next >.

    The side by side screen of the Create a New Information 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 carte below it.

    Warning: Do non change any of the other settings on this screen of the sorcerer.

  12. Click Next >.

    The next screen of the Create a New Information Source to SQL Server sorcerer appears.

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

  13. Click Stop.

    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 Information source Administrator dialog box, click OK.

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

    Installed as a service? Practice this
    No
    • Continue with Configure FH CAD Monitor .
    Yep
    • Go along with Specify the service password .