Problem creating ASP/Access Recordset

<i><b>Originally posted by : sanjay saxena (sanjay_saxena@email.com)</b></i><br />I am using ASP with MSAccess 97<br /><br />1: set oconn = Server.CreateObject("ADODB.connection")<br />2: oconn.Open ("<dsnname>")<br />3: dim rst <br />4: set rst = Server.CreateObject("ADODB.Recordset")<br />5: rst.open "resume",oconn, ,adLockPessimistic, ,adCmdTable<br /><br />gives following error in line 5<br />ADODB.Recordset error '800a0bb9' <br /><br />The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <br /><br /><br />

<i><b>Originally posted by : nigel clarke (nigeIT@talk21.com)</b></i><br /><br />Your line 1-5 listing implies you haven't defined the adLockPessimistic, adCmdTable constants.<br /><br />If you use Option Explicit for your scripts this would be picked up otherwise the recordset doesn't recognise the values.<br /><br />Maybe?!<br /><br />------------<br />sanjay saxena at 11/14/2000 10:49:32 PM<br /><br />I am using ASP with MSAccess 97<br /><br />1: set oconn = Server.CreateObject("ADODB.connection")<br />2: oconn.Open ("<dsnname>")<br />3: dim rst <br />4: set rst = Server.CreateObject("ADODB.Recordset")<br />5: rst.open "resume",oconn, ,adLockPessimistic, ,adCmdTable<br /><br />gives following error in line 5<br />ADODB.Recordset error '800a0bb9' <br /><br />The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <br /><br /><br />