Recordset Error / DB Access

Results 1 to 3 of 3

Thread: Recordset Error / DB Access

  1. #1
    Join Date
    Dec 1969

    Default Recordset Error / DB Access

    I just had to rebuild my development machine and ran into a small problem. I restored all of my DBs into SQL Server 7 and now when I try to open recordsets I get an error.<BR><BR>I think it&#039;s a simple fix just unsure of what it is.<BR><BR>If my script opens a recordset by doing the following it bombs and says "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another".:<BR><BR>objRS.Open strSQL, objConn, adOpenStatic, adLockReadOnly, adCmdText (this doesn&#039;t work)<BR><BR>However, if I remove the following they open fine with no problem:<BR><BR>objRS.Open strSQL, objConn (this works fine)<BR><BR>Did I miss setting something up in rebuilding SQL Server 7 and restoring DBs?<BR><BR>Thanks.

  2. #2
    Kentium Guest

    Default try this

    I&#039;d bet you lost which has all those constants.

  3. #3
    Join Date
    Dec 1969

    Default RE: try this

    Yup, that was it. global.asa was overwritten with the original.<BR><BR>Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts