Connect Classic ASP to SQL Server 2005 Express

I just had a vendor install a Grading/Attendance Software on a fresh Win 2003 Server.  Their ASP.NET program is web based and makes use of SQL Server 2005 Express on the same machine.  Their installation went fine and program works.

I am trying to now use classic ASP to pull info from that database.  I am trying to first JUST make a connection to the SQL Server with a basic ASP page, but nothing is working.

_______________________________
With the following:

Set conn = Server.CreateObject("ADODB.Connection")
DBstring = "Provider=SQLNCLI;Server=Gradespeed\Gradespeed;Database=GradeSpeed;UID=AAA;PWD=AAA;"
conn.Open DBstring

I get the following error:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
________________________________
With the following:

Set conn = Server.CreateObject("ADODB.Connection")
DBstring = "Driver = {SQL Server};" & _    
            "Data source = GradeSpeed\GradeSpeed;" & _    
            "Database = GradeSpeed;" & _    
            "uid = AAA;" & _
            "Pwd = AAAA"
conn.Open DBstring

I get the following:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
________________________

To me these are the most relevant Connection string options.  I REALLY need to get this connection working soon, but this problem has left me at a stand still.

If someone has a registry or software update solution to this problem, please be very specific about steps to a solution.
Start Free Trial