Insert into SQL Database with ASP

Hi, I am very new to ASP and a lot more comfortable with PHP so ASP is seeming rather alien to me!

I'm trying to insert one piece of data into an SQL Server 2000 database.

Can anyone see anything wrong with the code I'm using? Wondering if I maybe haven't got the right permissions with my access to the database. Everytime I try and enter new records through SQL Admin Studio it tells me I'm using an 'Invalid object name 'tiles''. Quite bemusing because there is no mention of the name 'tiles' in any attributes/entities/table names, its not even the name of the database however, the database holds data relating to tiles.

I have tried adding data to the database through ASP and I get the attached error. Being new to ASP I do not know what BOF or EOF (End of file?) are.

Any help much appreciated.

Thanks,
AlastairStart Free Trial

1:
2:
3:
4:
5:
6:
7:
8:

<%
dim choice
 
choice = Request("choice")
strSQL = "insert into managerchoice values('" & choice & "')"
set rs=Server.CreateObject("ADODB.Recordset")
 
 %>