Creating Module For Database Connection

We need to create a database connection, there is some connection;1. ODBC (open database connectivity)2. Data Environtment3. Script Module4. ADODC (using ADODATA Control)5. Data Control6. And other
We will discuss some, the first how to use ODBC. ODBC commonly used in MS-Windows. Do the following;Open the control panel in the MS-Windows, select administrative tools, then select the ODBC

Step 1

Choose System DSN Tab, and then Click Add Button as shown below ;

 and then choose driver of database which is used. for example Microsoft Access Driver (*.mdb), this is for recognized Access Database. we can use another driver according with RDBMS as storage data.

After finishing choose the driver click finish button, and we prepare to select the database, of course in mdb format.