Sorry, can't help on that either. Although, I really should start playing around with ASP too. Definitely try a post in the MS SQL and ASP groups in UT.


- Brian


>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.