Using SELECT in your example

I downloaded the example code for this article and observed it working just fine. I then changed the first parameter (source) of the rs.Open call from "Names" to "select * from Names", which I believe should perform an identical operation. Unfortunately, ASP now complains:

Error Type:
(0x80004005)
Unspecified error
/SLSPlayer/Paging/paging.asp, line 29

Can anyone tell me why I cannot use a select as a datasource in this example?

Thanks!