How to create DSN..Explain?

Answer Posted / parifs

1. Control Panel>>Admin Tools>>Data Services (ODBC)>>

2. From ODBC Data Source Administrator dialog, select
requires DSN type
(User DSN, System DSN, File DSN). From the selected DSN,
click ?Add? button and select the required driver and
click ?Finish? button.

3. From ODBC Text Set up enter the Data Source Name and
Description.
Select the DB and click Ok button.

4. DSN is created.

Is This Answer Correct ?    37 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to store pictures on to the database?

519


How to connect to a local oracle 10g xe server?

522


How to rename a tablespace in oracle?

607


Explain table?

638


Explain about achiever in sql?

576






How to save query output to a local file?

551


How many types of segments in Oracle?

523


Explain oracle’s server parameter file.

559


Explain the difference between replace() and translate() functions in oracle?

566


Explain overloading. Can functions be overloaded?

560


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1473


How to create a new view in oracle?

599


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1647


What is a dead lock in oracle?

583


How to add a new column to an existing table in oracle?

576