Open recordset worked on Windows 2000 server not on new 2003
am 14.09.2006 02:08:47 von aalexander
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
am 14.09.2006 15:24:56 von Mike Brind
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
am 19.09.2006 19:54:10 von aalexander
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