|
Setting Up a System DSN for an Access Database
Now we are going to make a DSN connection for the ASP database tutorials to be able to connect to the database.
I shall assume that you have already created the 'guestbook.mdb' database described in, Connecting
to an Access Database.
Well, first you need to open the 'ODBC
Data Source Administrator' you
will find it under 'Control Panel', 'Administration Tools' and it will be called 'Data
Sources ODBC'.
Once you open the ODBC Data Source Administrator select the
tab 'System DSN' and click on the 'Add' button at the right hand side of the dialog box.
You will now see another dialog box asking you to select a driver
for the data source. Select the 'Microsoft
Access Driver (*.mdb)' driver from the list and then
click on the next finish button and the bottom of the dialog
box.
In the next dialog box 'ODBC Microsoft
Access Setup', you will need to set a name for the data
source, this will be the name you call from your ASP scripts,
I have called this 'guestbook' to
fit in with the database tutorials.
You will also need to click on the 'Select...' button in the middle on the left. From here you will be asked
to 'Select Database', browse your
hardrive for the database, for the tutorials this should be 'guestbook.mdb'.
Next hit the OK button and you should now see your new ODBC
Data Source.
|
|
|
