Define DSN with ODBC Manager in Oracle

Q

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

✍: FYIcenter.com

A

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

 

Connect MS Access to Oracle Servers in Oracle

Verify Oracle TNS Settings in Oracle

ODBC Drivers and DSN Configuration for Oracle

⇑⇑ Oracle Database Tutorials

2016-10-15, 2024🔥, 0💬