I am migrating my site from MS Access to SQL Server 2000 and I need a little assistance to make my application work. This is probably the most basic ASP, but I just can't get it to work for me. The code runs and the page does not throw an error but when I check to see if the record has been added, nothing has happened. I have a search engine that displays announcements and when you find a favorite you can click on it and add it to your favorites section. When you select which folder you wish to store it, it then does the work necessary to create a new record in the SQL Server Database. Here is the code:
<%@ LANGUAGE ="VBSCRIPT" %>
SET DbConn = Server.CreateObject("ADODB.connection")
DbConn.Open = "DSN=quijasqldb"
SET oRS = Server.CreateObject("ADODB.recordset")
oRS.Open "Favorites", DbConn, 2, 2
oRS("AdvertID") = Request.Form("hidAnunID")
oRS("FolderID") = Request.Form("ddCarpeta")
oRS("UserName") = Session("QuijaID")
SET oRS = Nothing
SET DbConn = Nothing
As I mentioned before the page throws no error and runs but nothing is created in the database. I am sure it is something so trivial and basic, but I really could use some help.
Many thanks for your assistance and time,