[thelist] ADO

Hi all

Probably a really simple one this.  I want to create a recordset using an
SQL query:

Set itemRS = Server.CreateObject("ADODB.RecordSet")
itemRS.Source = "productTable"
itemRS.ActiveConnection = "kusun1"
itemRS.CursorType = adOpenKeyset
itemRS.LockType = adLockPessimistic
itemRS.Options = adCmdText
itemRS.Open

However when I run this on PWS I get this error

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'itemRS.Options'

/KUSU/admin/stock_add.asp, line 41


Anyone know why this isn't working?  AFAIK (and indeed what the WROX book
tells me) is that .options is supported by the RecordSet object.

Thanks in advance

Norman