Set DSN (Data Source Name) in windows XP

Description

Steps for Setting DSN in for Oracle database and MSAccess database in windows XP have been mentioned here. Driver used for Oracle database is Microsoft ODBC for Oracle and for MSAccess database is Microsoft Access Driver (*.mdb). While executing java file with connectivity code the database pointed by the corresponding DSN will be referred for operation.
  • DSN (Data Source Name) setting in Windows XP for Oracle Database
  • DSN name: Object

Steps for setting path for java using environment variable in Windows XP

  • Control Panel
  • Administrative Tools
DSN (Data Source Name) settings in windows XP
  • Data Sources(ODBC)
DSN (Data Source Name) settings in windows XP
  • Add
DSN (Data Source Name) settings in windows XP
  • Select Microsoft ODBC for Oracle
DSN (Data Source Name) settings in windows XP
  • Finish
  • Type DSN
DSN (Data Source Name) settings in windows XP
  • Type OK
  • DSN gets added in list of data sources
DSN (Data Source Name) settings in windows XP
  • OK
  • Database for the corresponding DSN has to be created in Oracle Databse homepage
  • DSN (Data Source Name) setting in Windows XP for MS-Access Database
  • DSN name: Object
  • Control Panel
  • Administrative Tools
DSN (Data Source Name) settings in windows XP
  • Data Sources(ODBC)
DSN (Data Source Name) settings in windows XP
  • Add
DSN (Data Source Name) settings in windows XP
  • Select Microsoft Access Driver (*.mdb)
DSN (Data Source Name) settings in windows XP
  • Type DSN
  • Click Select
DSN (Data Source Name) settings in windows XP
  • Select the drive and directory in which database is located
  • OK
DSN (Data Source Name) settings in windows XP
  • DSN gets added into list of User Data Sources
  • OK
DSN (Data Source Name) settings in windows XP