Ok, I will give you a few tips on db connection using asp: I used MS sql server 2000

DB connection:

<%
set conect= Server.CreateObject("ADODB.Connection")
lincon= "dsn=testodbc; uid=user; pwd=passwd"
conec.open lincon
%>


Executing queries:

set result= conect.execute ("create, drop, select, update......)


Note: conect, result are just variables, testodbc means I created and named an odbc as "test", user and passwd are just any user name and password for your database.

Hope this helps, I could go more into depth about configuring MS SQL server 2000 for using with asp. Also checkout my turorial about php with a database, in my opinion I prefer php over asp...