IIS recordset problems

[hugz]

Hi,

i am a bit of a novice to web programming, but I understand code quite easily and do not understand why i am getting an error when i try to execute an sql statement to fill a recordset.

i get the error ' object required : " ' when i execute a script i have written. i cannot see what is wrong and need some help. this has not happened before with any of my other scripts and i'm sure the code is right.

then line with the problem is

RS.Open sql, cnn

and it says an object is required...? i thought that was all i needed.

please help

 

[TootingBoy]

Have you instantiated the recordset object? You need to do this:

Dim RS
Set RS=Server.CreateObject("ADODB.Recordset&quot

If this still fails make sure that you have successfully installed ADO on the server.

 

[dave4dl]

Also, if "cnn" is a connection object (and not just a connection string), you have to:

Dim cnn
set cnn = CreateObject("ADODB.Connection&quot