Alright ... I'm on the verge of throwing in the towel.

Here's the setup:
Windows 2000 Professional with IIS installed.
ODBC User DSN referencing the database has been created.

I exported a table as an asp file to the wwwroot directory and If i just open the page with my browser it works fine. If I try to browse to my computer using http://computername, it gives the following error:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/aspClients.asp, line 16

the coding from lines 12-18 are:

If IsObject(Session("test_conn")) Then
Set conn = Session("test_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "test","",""
Set Session("test_conn") = conn
End If

What the heck am I doing wrong here? I know it has to be something simple.