Learn how to connect to different kinds of databases in ASP.
Although our ASP database tutorials all use MS Access connection
strings, there are many sorts of database software out there for use
with ASP. This tutorial will show you how to connect with them.
MS ACCESS First, we'll take a look at the regular MS Access Connection String:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0; DBQ=" _
& Server.Mappath("db/users1.mdb") & "User ID=Administrator;Password=rev01t;"
Conn.Open
|
Some people have trouble with this string, so I decided to add another connection string in its place:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.connectionstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" _
& Server.Mappath("db/users1.mdb") & ";User Id=Administrator;Password=rev01t;"
Conn.Open
|
One of these two should work out for you, where the Password is
the database password, or a combination of the User ID and the Password
are given to restrict access to a certain table.
Note: if you have no username or password, erase everything after the third to last ';' like so:
& Server.Mappath("db/users1.mdb") & ";"
MS SQLThis is a less common alternative to Access databases,
most commonly used by large scale websites. Here's our connectionstring
to SQL:
set Conn = server.createobject("ADODB.Connection")
Conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=servername;User ID=username;_
Password=password;DATABASE=databasename;"
|
There's your MS SQL string. Be sure to change servername to the
name of the server (localhost, computername, or IP), and to change
username, password, and databasename to match those of your database.
