Thanks Brian. I fixed it earlier today by doing an IIs Restart. I don't know what was causing the problem, but now it works.

I have a new problem though.

I'm following through the Wrox book "Beginning ASP Databases" and I have created a two System DSNs, one for Access and another for SQL Server. In the ODBC Administrator I have stepped through each page successfully, and on the SQL Server DSN I get a successful connection test. But, using either one I get the same error, which is:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The Access database is in the wwwroot folder (Win 2000 Pro & IIs 5). I tried my own code first, then copied the sample code from the book I'm reading (Wrox: Beginning ASP Databases) directly and it does the same thing. Ok, so what the heck am I missing?

Here's the offending code (straight out of the Wrox sample code):

set oRS=server.createobject("ADODB.recordset")
oRS.open "Select * from People", "DSN=sailors"
oRS.movefirst
response.write "" & oRS("PeopleNameLast") & ""

I should probably post this in its own thread, but wondered if you happen to know a solution?

Thanks.