ODBC
You will need to create an ODBC Database Connection if
you are going to be using ASP pages within your website. You
do this by clicking on the ODBC link in your control panel.
You will then see the ODBC screen similar to the one shown below
(Image 1).
 If you need
to create a new ODBC Connection then click on the link.
If you already
have ODBC Database Connections set up on your domain then they
will be listed on this screen and edited via it.
Image 1
Creating an ODBC Database Connection in 2 steps.
Step
One:
When you create a new ODBC Connection
you will see a screen like Image 2 below.
You will be
need to enter a name for this ODBC connection.
Select the type of database that you are using from the dropdown
list. Usually with ASP pages this is an Access database.
Click Next.
Image 2
Step
Two:
Step two requires you
to enter the path on the server to your database so that your
ASP pages function correctly.
For example:
If you are using a database called mydb.mdb for your ASP pages
and you upload it to the htdocs directory on the server then
you would need to enter htdocs\mydb.mdb in the box and click
Create.
Of course, you can create a different
directory for your database but the path you enter would have
to reflect this.
For example:
You create a directory called databases and you upload your
database to this directory within the htdocs directory. You
would need to then enter the path: htdocs\database\mydb.mdb
Once the ODBC connection is setup you can edit it at
any time from the main ODBC screen of your control panel.
Further
online help is available by clicking the Click here if you are
having a problem with Database Connections link.
Non ODBC database connections.
It is also possible to make database connections without creating
an ODBC link. There are many ways to do this, many scripts that
you may choose to use will already have this setup. However,
if you need an example script to connect to your database we
prefer the following method:
Set Conn = Server.CreateObject("ADODB.Connection")
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Conn.Open ConnString & Server.MapPath("Your-Database.mdb")
|
