Im having trouble getting this to work, and honestly I dont know where to really start on this, I want to pull product information out of a database and display it on a webpage using asp, but I get error messages and to be honest I dont know where to start or if im even doing it right. TO get a better IDEA of my problem goto Http://www.rhjgold.com
, click on the wax catalog button and then click on the diamond fashion button, I want to pull all products in that database out, and display them. here is the code and the error messages im getting.
Server object error 'ASP 0177 : 800401f3'
/dfashionwax.asp, line 8
Invalid class string
Here is the code:
' open database connection
set db1 = Server.CreateObject("ADODB
' db1.Open "DSN=DB2094a;UID=*****;PWD
' open recordset
' open Recordset
Set RS = Server.CreateObject( "ADODB.Recordest" )
RS.ActiveConnection = db1
RS.Open "SELECT * FROM diamondfashion"
' loop through Recordset
WHILE NOT RS.EOF
Response.Write RS( "product_name" )