If this page is not accessible, please contact the Division of Facilities Operations at: phone 301-443-3121
U.S. Department of Health and Human Services
Indian Health Service: The Federal Health Program for American Indians and Alaska Natives
 
Nationwide
Programs
and Initiatives
OEHE Home Page
DFO Home Page
 
   
 

ODBC Setup

Healthcare Facilities Data System ODBC Setup Instructions


  1. Go to Settings > Control Panel > Administrative Tools, double click "Data Sources (ODBC)"

  2. Under "User DSN" tab, look for "facilities", highlight and hit "Remove" button.  If “facilities” is not on list, proceed to step 3.

  3. Click "Add" button, choose "SQL Server" as driver

  4. Type the following into the three text boxes on screen:
    • Name: facilities
    • Description: ODBC Data Source for HQESDB2
    • Server: HQESDB2
    Click Next

    Screenshot showing SQL Server DSN Setup - Step 4


  5. Note: Effective Sept. 2009, most users will now be using their Windows login instead of their old SQL Server login. Therefore, please follow the below instructions accordingly.

    1. For Windows Users:
      • Click on the first option "With Windows NT authentication using the network login ID"
        Screenshot showing Windows Authentication Setup - Step 5a
    2. For SQL Server Users:
      • Click the second option "With SQL Server authentication using a login ID and password entered by the user"
        Screenshot showing SQL Server Authentication Setup - Step 5b
    For assistance please contact Sunny.Yun@ihs.gov or Brian.Kaplan@ihs.gov


  6. Click "Client Configuration" button, choose "TCP/IP" as Network Libraries, type the following into the two text boxes on screen:
    • Computer Name: 161.223.220.78
    • Port: 1433 (You may have to uncheck the “Dynamically determine port” box)

    Click OK

    Screenshot showing Client Configuration Setup - Step 6


  7. Upon clicking OK, the previous screen will appear.  Type your Login name and password, click Next

    Screenshot showing Authentication Screen again - Step 7


  8. Check the box that have "change default database to Facil", click Next, then click finish

    Screenshot showing Database Setup - Step 8


  9. On the next screen, keep all defaults, click Finish

    Screenshot showing Final SQL Server Setup Screen - Step 9


  10. Click Test Data Source on the next screen

    Screenshot showing Test Data Source Screen - Step 10a


  11. Click OK three times to exit setup

    Screenshot showing Test Completed Successfully - Step 10b
  Please e-mail questions and comments to the DFO website administrator DFOwebadmin@na.ihs.gov.

Content on this page may require: Link to Adobe Acrobat Plug-in Acrobat  Link to MicroSoft Excel Plug-in Excel  Link to MicroSoft Word Plug-in MS Word  Link to MicroSoft PowerPoint Plug-in PowerPoint  Link to Corel WordPerfect Plug-in WordPerfect 

usa.gov link   Accessibility · Disclaimer · Website Privacy Policy · Freedom of Information Act · Kid's Page · Contact   This website is accredited by Health On the Net Foundation. Click to verify.

Indian Health Service (HQ) - The Reyes Building, 801 Thompson Avenue, Ste. 400 - Rockville, MD 20852