Publishing ASP's from Access works, but can't surf it

[d0cman]

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.

[d0cman]

Wow ... not much action here ... only 3 viewings and all by myself.

Found the solution to my problem.

After creating a systemDSN of the same name to ensure odbc integrety with the db. and deleting the userDSN, what I didn't realize is that all details that I had specified had been deleted!

[Lowland]

Well done!!

As an afterthought, many .asp problems on IIS can be caused by User permissions being incorrectly set. You should ensure (you probably have!) that the account you use to access the server carries suitable restrictions, but allows scripting access to the folders/files you need. I don't know if you use Front Page too, but this can complicate matters.

You were right to check the bb engine connection through ODBC, I just get concerned when seeing this type of problem that it is not in fact a permissions problem.

But, as I said, WELL DONE - sorry you didn't get a reply!