Open recordset worked on Windows 2000 server not on new 2003

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

Re: Open recordset worked on Windows 2000 server not on new 2003

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

Re: Open recordset worked on Windows 2000 server not on new 2003

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