Results 1 to 4 of 4

Thread: ASP Recordset error-Please help!

  1. Jul 18th, 2001, 11:28 AM #1
    JoshT
    JoshT is offline

    Thread Starter
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    I don't see the exact cause of your problem, but here are some suggestions:

    Use Server.CreateObject instead of CreateObject. Your code will run safer.

    Use a forward-only, read-only recordset, and don't use MoveFirst. You don't seem to need a more resource consuming one.
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    Reply With Quote Reply With Quote
  2. Jul 18th, 2001, 12:12 PM #2
    vbuser1976
    vbuser1976 is offline
    Hyperactive Member vbuser1976's Avatar
    Join Date
    Sep 2000
    Location
    Yonkers, NY
    Posts
    404

    Angry Darn It!

    Thanks for the ideas, but I am still having this problem. I am going crazy here. I'll keep trying. Thanks again.
    -vbuser1976
    VB6 Enterprise SP6
    SQL 7.0 SP2
    VBScript, HTML, Javascript, C++, a little UNIX
    Reply With Quote Reply With Quote
  3. Jul 18th, 2001, 03:18 PM #3
    monte96
    monte96 is offline
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    Also:
    Change this
    Code:
    cn.Provider="SQLOLEDB.1"
cn.ConnectionString="DATABASE=Helpdesk;SERVER=WEBSQL;UID=sa;PWD=;"
    to this
    Code:
    cn.ConnectionString="Provider=SQLOLEDB;DATABASE=Helpdesk;SERVER=WEBSQL;UID=sa;PWD=;"
    And make sure you are setting your objects to nothing at the bottom of your page.
    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    [email protected]
    [email protected]


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..
    Reply With Quote Reply With Quote
  4. Jul 18th, 2001, 03:42 PM #4
    vbuser1976
    vbuser1976 is offline
    Hyperactive Member vbuser1976's Avatar
    Join Date
    Sep 2000
    Location
    Yonkers, NY
    Posts
    404

    Unhappy Still...:mad:

    I added your suggestions and I still get the same error. AAAARGH! This is really frustrating. I really do not want to do this project all over. Thanks for your help.
    -vbuser1976
    VB6 Enterprise SP6
    SQL 7.0 SP2
    VBScript, HTML, Javascript, C++, a little UNIX
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width