Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Define DSN with ODBC Manager

By: FYIcenter.com

(Continued from previous topic...)

How To Define a Data Source Name (DSN) in ODBC Manager?

DSN (Data Source Name) is an ODBC connection identifier for Windows applications. Here is how you can define a DSN on your Windows system:

  • Go to Control Panel.
  • Go to Administrative Tools.
  • Run Data Sources (ODBC).
  • Go to System DSN tab.
  • Click the Add button.
  • Select the "Oracle in XE" driver.
  • Enter Data Source Name: FYI_DSN.
  • Enter Description: FYIcenter DSN Oracle Setting.
  • Enter TNS Service Name: XE.
  • Click the Test Connection button.
  • Enter User Name: fyi.
  • Enter Password: retneciyf.
  • Click the OK button.

You should see a "Connection successful" as shown in the following picture:
    DSN Setting for Oracle ODBC Driver

(Continued on next topic...)

  1. What Is Open Database Communication (ODBC)?
  2. How To Install Oracle ODBC Drivers?
  3. How To Find Out What Oracle ODBC Drivers Are Installed?
  4. How Can Windows Applications Connect to Oracle Servers?
  5. How To Create Tables for ODBC Connection Testing?
  6. How To Verify Oracle TNS Settings?
  7. How To Define a Data Source Name (DSN) in ODBC Manager?
  8. How To Connect MS Access to Oracle Servers?
  9. How To Connect ASP Pages to Oracle Servers?

Oracle Tutorials:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: