I created a new page within my site. I was able to connect the database and the test was successful. When I tried to create the recordset I get an error which reads "HTTP error code 500 Internal Server error"
I remember using this feature awhile back playing around with another site and was able to connect with a database on the same server. Not really sure what the problem is.