Yes, it's possible. And best of all, easy --
By you asking that type of question, I wouldn't presume to be able to give you a lesson or anything, but can point you to some great resources and give you a little bit of concept and code on how this is done. Two great resources are
(great tutorials -- just look under db and connections) and
(great downloadable html vbscript reference along with some tutorials to get you going).
Basically, connecting to a database boils down to two things -- a connection (think of this as the pipe through which your data will travel from the database to the client), and the recordset (think of this as a perfect replica of your database table, and it's what holds the data and the vehicle by which you access it).
You need to have some way of connecting to the database, and this is usually done with a DSN (Data Source Name), and greatly simplifies the process with ODBC (Open DataBase Connectivity). You set this up in the control panel of the server where your asp page will reside. You specify what database you want to connect to and give it an alias (the actual DSN -- usually something easy to remember like myDataBase or whatever)
That being said, you create a connection by saying:
Code:
dim con
set con = server.createobject ("ADODB.Connection")
con.open ("DSN=myDataBase")
There, you now have a connection to the database. Now, you have to actually get the data into a recordset:
Code:
dim rs
set rs = server.createobject ("ADODB.Recordset")
rs.activeconnection = con 'tell this recordset to use con
rs.open "SELECT * FROM tableName"
And there you are. You now have a replica of the data that exists in the table, tableName. You can refer to the different columns of data by the names that you have given them in the database table.
You can output it by saying:
Code:
response.write rs("columnName")
The above code will write to the browser whatever value is in the first row of the table under the column, columnName.
There are a plethora of functions that you use with the recordset, such as rs.movenext (to move to the next row), rs.movefirst, rs.movelast, etc...
I hope this gets you headed in the right direction, as posting much more here probably wouldn't be appropriate. Just visit the sites above, and do a little reading. It's a piece of cake once you get the hang of it.
good luck!

Paul Prewett