recordset error

[hugz]

hello,

i am getting an error from my browser saying 'object required' on the line

RS.Open sql, cnn

where the sql and the cnn settings are correct coz i've used them in other scripts.

please help as this is driving me insane

thanks

 

[Genimuse]

Is "RS" correctly defined as as recorset object?

 

[pjames]

Please post the rest of the script. Also make sure every object has been set. I personaly like to establish my recorset as follows...

Dim strCon
Dim strSQL
Dim objRecordSet

Set objRecordSet = Sever.CreateObject("ADODB.RecordSet&quot

'Pick One'''''''''''''''''''''''''''''''''''''''
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=yourdata.mdb;"'Access Connection
'strCon= "Provider=SQLOLEDB;Server=sqlServer;Uid=sa;Pwd=password;Database=yourdata" 'SQL Server Connection
''''''''''''''''''''''''''''''''''''''''''''''''

strSQL = "SELECT * FROM YourTable"

objRecordSet.ActiveConnection = strConn
objRecordSet.Source = strSQL
objRecordSet.CursorLocation = 3
objRecordSet.LockType = 3
objRecordSet.CursorType = 0
objRecordSet.Open


objRecordSet.Close