Basic Oracle Concepts and Programming Question:
How To Define a Data Source Name (DSN) in ODBC Manager?
Answer:
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: ggl_DSN.
► Enter Description: globalguideline DSN Oracle Setting.
► Enter TNS Service Name: XE.
► Click the Test Connection button.
► Enter User Name: ggl.
► Enter Password: retneclgg.
► Click the OK button.
You should see a "Connection successful" as shown in the following picture:
DSN Setting for Oracle ODBC Driver
► 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: ggl_DSN.
► Enter Description: globalguideline DSN Oracle Setting.
► Enter TNS Service Name: XE.
► Click the Test Connection button.
► Enter User Name: ggl.
► Enter Password: retneclgg.
► Click the OK button.
You should see a "Connection successful" as shown in the following picture:
DSN Setting for Oracle ODBC Driver
| Previous Question | Next Question |
| How To Check the Oracle TNS Settings? | How To Connect MS Access to Oracle Servers? |