How to create DSN..Explain?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suresh boddu
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 ? | 4 Yes | 1 No |
What is DTS and purpose of DTS ?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Define Normalization with example?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
how to truncate date and get only time part 9:20:00
Can we create trigger on materialized view in oracle?
What is the difference between Sleep and Wait? (Java)
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What do you mean by a deadlock?
Difference between oracle's plus (+) notation and ansi join notation?
Differentiate between function and procedure in oracle.
what is difference between sql plus and sql*plus? (not sql and sql plus).