“How to create a DSN connection in
Window 7 64 bit system”
1.
In order to check the type of the
operating system (32 bit/64 bit).
·
Go
to “My Computer”.
·
Right
click on My Computer’s “properties”.
· The following window will appear where you can see under the “system” information “system type: 64 bit Operating system” is shown.
2.
To create a DSN connection:
·
Go
to “Start Menu”.
·
Then
go to “Control Panel”.
·
Following
screen will appear. Click on “Administrative tools”.
·
Following
screen will appear. Go to “Data Source (ODBC)”.
·
“ODBC
Data source Administrator” window will get open.
·
Go
under the “User DSN” or “System DSN” tabs. No drivers will be available .On
clicking “Add” button “Create New Data Source” window will open that shows only
SQL Server driver. The reason for this is that there are some issues in window
7 64-bit version for ODBC Data Source Administrator. This application short cut is linked to wrong
file.
·
To
resolve this issue go to the directory
C:\ =>
Windows =>
SysWOW64 (as shown in the figure below)
·
Go
to odbcad32.exe.Create its shortcut and paste it on the Desktop.
·
Double click on the shortcut icon on the Desktop
to run it.
·
Now
go back to the “ODBC Data source Administrator” window.
·
Under
the “User DSN/System DSN” tab click on “Add” button.
·
You
will see the list of drivers now available on “Create New Data Source”.
·
Select
“Microsoft Access Driver (*.mdb,*.accdb)”.
·
Click
Finish.
·
Following
window will appear. Write the name of DSN you want like “studentDSN”.
·
Under the Database tab, click on “Select”
button.
·
Following
window will appear. Select the destination where your database file is present.
·
Click
ok.
·
You
will see on the “ODBC Microsoft Access setup” window the path of your database
file will appear under the Database tab.
·
Click
“ok”.
·
Go
back to the “ODBC Data source Administrator” window.
·
Under
the “System DSN” your created “studentDSN” will appear along with driver name.
·
Click
ok.
