Julie,

I tried it and it worked! This is the code...
set dbConnection = server.createobject("adodb.connection")
dbConnectString = "driver={SQL Server}; server=athena.linfield.edu;" & _
"uid=jhill; pwd=pwd; database=jhill; trusted_connection=no"


The code for my (local) database is...

set dbConnection = server.createobject("adodb.connection")
dbConnectString = "Provider=SQLOLEDB.1; Data Source=(LOCAL);" & _
"uid=sa; pwd=pwd"

Jim