ADO for the Beginner - Connect to a Database with ODBC

[hari]

Using our friend the ODBC database connection, you can connect to any database that is located on your network (providing of course that there is an ODBC connection to use). Here is how that would look in ASP:


<%

set conn=Server.CreateObject("ADODB.Connection")

conn.Open "chucknorrisvicims"

$>

Connect to a Microsoft Access Database Using ODBC

So you want to connect to a Microsoft Access database? Well you can do that with ODBC. First, you must make sure to configure your ODBC connection on the same computer that holds your web site. In other words, if your web site is located on a remote server, your web host will need to be contacted to do this for you. If you are using Personal Web Server or Internet Information Server on a computer you have access to, the following will allow you to set up the connection yourself:


    *     Double Click the ODBC icon (it should be located in your Control Panel).
    *     Find the System DSN tab and click on it.
    *     Click the Add button under the System DSN tab.
    *     Click on the Microsoft Access Driver and click the Finish button.
    *     When the next screen appears, click the Select button to locate your database.
    *     Choose a DSN (Data Source Name).
    *     Click the OK button.