ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
Categories >> Software >> Databases >> Oracle >> Oracle General
 


 

 
Question How to create DSN..Explain?
 Question Asked In Companies :: BeBo Technologies, Infosys,     < I also faced this Question! >
 Question Submitted By :: suresh
  Answer Posted By  
 
Answer
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 ?    3 Yes 0 No


 
  suresh boddu
 
View All Answers
 
 
Please Help Members By Posting Answers For Below Questions
 
 Question Views   Select
 
how can db_files > maxdatafiles since db_files is for instance and the later is for database 907
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that? 714
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)? 592
Youre getting high busy buffer waits - how can you find whats causing it? 415
20. Using a set operator, display the client number of all clients who have never placed an order. 681
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program? 469
how to clone 9i Database on to 10g Database. 730
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future. 537
defination of bitmap index 491
What query tells you how much space a tablespace named test is taking up, and how much space is remaining? 714
what are steps for interface? where is exchange rate defined in which table? 454
Differentiate between TRUNCATE and DELETE? 98
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages. 3633
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE 504
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible.... 475
E-Mail New Answers        Answer Selected Questions