I'm new to ASP as well, and I manged to run your example perfectly, now the problem I'm having now is to get it to run with Sql server!!
This is the error I get: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.