Set DSN (Data Source Name) in Windows7

Description

Steps for Setting DSN in for Oracle database and MSAccess database in Windows 7 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 7 for Oracle Database
  • DSN Name: storage
  • Double click the odbcad32.exe file located in the following folder

C:\Windows\SysWOW64\odbcad32.exe
(or)
C:\Windows\system32\odbcad32.exe
(or)
Control panel -> System and Security -> Administrative Tools -> Data Sources (ODBC)

  • dBASE Files
  • Click Add
DSN (Data Source Name) settings in windows 7
  • Select Microsoft ODBC for Oracle
  • Finish
DSN (Data Source Name) settings in windows 7
  • Type DSN as storage
  • DSN gets added in list of data sources
DSN (Data Source Name) settings in windows 7
  • Double click the odbcad32.exe file located in the following folder
  • Database for the corresponding DSN has to be created in Oracle Databse homepage

  • DSN (Data Source Name) Setting in Windows 7 for Ms-Access Database
  • DSN Name: storage
  • Double click the odbcad32.exe file located in the following folder

C:\Windows\SysWOW64\odbcad32.exe
(or)
C:\Windows\system32\odbcad32.exe
(or)
Control panel -> System and Security -> Administrative Tools -> Data Sources (ODBC)

  • dBASE files
  • Click Add
DSN (Data Source Name) settings in windows 7
  • Type DSN as storage
DSN (Data Source Name) settings in windows 7
  • Click Select
DSN (Data Source Name) settings in windows 7
  • Select Drives and Directories in which database is located
DSN (Data Source Name) settings in windows 7
  • DSN gets listed in User Data Sources
DSN (Data Source Name) settings in windows 7