Open recordset worked on Windows 2000 server not on new 2003

Discussion in 'ASP General' started by kifaro, Sep 14, 2006.

  1. kifaro

    kifaro Guest

    Hi I am opening recordsets in my asp page with the following command:
    rs.open mysql,cn,3,3

    on occasion it isn't working and I have to do:
    set rs=cn.execute(mysql)

    Any clue why??

    Regards,
    Aaron
     
    kifaro, Sep 14, 2006
    #1
    1. Advertisements

  2. Mike Brind

    Mike Brind Guest

    kifaro wrote:
    > Hi I am opening recordsets in my asp page with the following command:
    > rs.open mysql,cn,3,3
    >
    > on occasion it isn't working and I have to do:
    > set rs=cn.execute(mysql)
    >


    What error message/results do you get on the occasions it doesn't work.

    Also, when you say "occasions", do you mean that the problem is
    intermittent on all pages, or does it always fail on some pages, but
    always work on others?

    --
    Mike Brind
     
    Mike Brind, Sep 14, 2006
    #2
    1. Advertisements

  3. kifaro

    kifaro Guest

    some pages and not others, consistantly. In addition no error is
    returned it just returns an empty recordset even if data exists.

    Aaron


    Mike Brind wrote:
    > kifaro wrote:
    > > Hi I am opening recordsets in my asp page with the following command:
    > > rs.open mysql,cn,3,3
    > >
    > > on occasion it isn't working and I have to do:
    > > set rs=cn.execute(mysql)
    > >

    >
    > What error message/results do you get on the occasions it doesn't work.
    >
    > Also, when you say "occasions", do you mean that the problem is
    > intermittent on all pages, or does it always fail on some pages, but
    > always work on others?
    >
    > --
    > Mike Brind
     
    kifaro, Sep 19, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Vaap
    Replies:
    2
    Views:
    1,382
  2. anon
    Replies:
    2
    Views:
    510
    MadCrazyNewbie
    Apr 6, 2004
  3. Darren Li
    Replies:
    4
    Views:
    1,285
    Patrick Olurotimi Ige
    Dec 23, 2004
  4. =?Utf-8?B?TGU5NTY5?=

    Moving web app from windows 2000 to windows 2003 - Help

    =?Utf-8?B?TGU5NTY5?=, Apr 18, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    451
    =?Utf-8?B?TGU5NTY5?=
    Apr 18, 2005
  5. =?Utf-8?B?TGU5NTY5?=

    Moving web app from windows 2000 to windows 2003 - Help

    =?Utf-8?B?TGU5NTY5?=, Apr 18, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    428
    =?Utf-8?B?TGU5NTY5?=
    Apr 18, 2005
  6. Kevin Burton

    LDAP, Windows 2000, and Windows 2003

    Kevin Burton, Dec 27, 2003, in forum: ASP .Net Security
    Replies:
    0
    Views:
    232
    Kevin Burton
    Dec 27, 2003
  7. Adhik
    Replies:
    1
    Views:
    354
    Manohar Kamath [MVP]
    Sep 5, 2003
  8. R M
    Replies:
    1
    Views:
    240
    Dave Patrick
    Aug 9, 2004
Loading...