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

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

Q

How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection

✍: 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

2007-04-17, 6480👍, 0💬

How To Define a Data Source Name (DSN) in ODBC Manager
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection 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 Administ... 2007-04-17, 6481👍, 0💬

How To Connect MS Access to Oracle Servers
How To Connect MS Access to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle tab... 2007-04-17, 4809👍, 0💬

How To Connect ASP Pages to Oracle Servers
How To Connect ASP Pages to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the co... 2007-04-17, 4690👍, 0💬

How To Create Tables for ODBC Connection Testing
How To Create Tables for ODBC Connection Testing? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL> CONNECT system/ret... 2007-04-17, 4660👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.