Hypertext Links
Image formats
Text Formatting
Forms
Tables
Stylesheets
Databases and ASP
   
ASP Home>| ODBC > | Database connection >

Open Database Connectivity (ODBC) is an Application Programming Interface (API) designed to allow a common set of routines to access database (It allows programmers to abstract a program from a database). When writing code to interact with a database, you usually have to add code that talks to a particular database using a appropriate language.

How to create an access data source name
1)Open the control panel and double-click on ODBC (or 32bit ODBC) icon:

 

B)Click on System DSN tab and the click the add button:

 

C: This is the list of all the available drivers. Select the Microsoft Access Driver(*.mdb) and then click the finish button, this will open another dialog box:

 

D:Type a name for your data source name and then click on select button to find your database file or alternatively click on create button to creat a new database.

 

Click OK and then check the list to see you data source has been added and that's all there is it.