DSN(DATA SOURCE NAME) SETTING PROCEDURE
FOR
JDBC(JAVA DATABASE CONNECTIVITY) TECHNOLOGY
STEP 1:- OPEN RUN
COMMAND AND TYPE "odbccp32.cpl" AND PRESS ENTER
( COMMAND THAT WILL OPEN THE MICROSOFT ODBC DATA SOURCE ADMINISTRATOR )
OR
START->CONTROL PANEL->ADMINISTRATIVE TOOLS->DATA
SOURCES(ODBC)
STEP 2:- CLICK
ON SYSTEM DSN TAB
STEP 3:- CLICK
ON ADD BUTTON
STEP 4:- SELECT
A DRIVER FOR THE REQUIRED DATABASE
SUCH AS :-
A) DRIVER DO MICROSOFT ACCESS (*.mdb)->>
FOR MS-ACCESS CONNECTIVITY
B) MICROSOFT
ODBC FOR ORACLE ->> FOR ORACLE CONNECTIVITY
STEP 4.1:- FOR MS-ACCESS CONNECTIVITY :-
a) SELECT "DRIVER DO MICROSOFT ACCESS
(*.mdb)" AND CLICK FINISH
BUTTON
b) TYPE
DATA SOURCE NAME E.G. VIV (OR ANY
STRING)
c) IF YOU ALREADY HAVE A DATABASE FILE THEN CLICK
ON DATABASE SELECT
BUTTON LISTED BELOW NAVIGATE TO THE
FOLDER WHERE YOUR DATABASE FILE
IS STORED,SELECT IT.
PRESS OK THREE TIMES THEN DSN CREATION IS COMPLETED.
d) IF YOU DONT HAVE A DATABASE FILE THEN CLICK
ON DATABASE CREATE BUTTON
LISTED BELOW NAVIGATE TO THE FOLDER WHERE YOU
WANT TO CREATE
DATABASE FILE.TYPE DATABASE NAME (E.G. db.mdb) AND PRESS OK.
DATABASE
CREATION SUCCESSFULLY MESSAGE WILL BE DISPLAYED.
PRESS OK THREE TIMES THEN DSN CREATION IS
COMPLETED.
STEP 4.2:- FOR ORACLE CONNECTIVITY :-
a) SELECT "MICROSOFT ODBC FOR ORACLE"
AND CLICK FINISH BUTTON.
b)
TYPE DATA SOURCE NAME E.G. VIV (OR ANY STRING) AND PRESS OK TWO TIMES.
STEP 5:-
EXIT
IMPORTANT NOTE:-
1) AFTER MAKING DSN , YOU NEED TO PROVIDE
ONLY THIS NAME INTO
THE JDBC
SOURCE PROGRAM.
2) IF THE DATABASE REQUIRED ANY
AUTHENTICATION LIKE ORACLE
THEN PROVIDE DSN NAME WITH USERNAME AND PASSWORD IN
THE JDBC SOURCE PROGRAM.
3)
IN GENERAL, MS-ACCESS DOES NOT REQUIRE
ANY AUTHENTICATION.
______________________________
__________________________________
No comments:
Post a Comment