'on error resume next
' Create ADO Connection Object
Set ac = Server.CreateObject("ADODB.Connection")
' Build connection string and then Open connection
strSQL7 = "Provider=SQLOLEDB;Persist Security Info=False;" &_
"User ID=USERNAME;Password=PASSWORD;Initial Catalog=DBNAME;" &_
So I found this which seems to work, except I can't figure out what the name of my server should be. With mysql usually your default is localhost, does MS SQL have a similiar default? I tried typing int he name of the server that's listed in myLittleAdmin, butthat didn't work.