Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

TheboL.wwwxxxxx, WWWXXXAPC , wwwxxn.xsss, wwwxxxapc, WWWXXX.VCBA, wwwxxx vba, wwwxxxdoco, Wwwxxx.APC, wwwxxx CN2, can't locate feature.pm in @inc (@inc contains

Links

XODOX
Impressum

#1: Open recordset worked on Windows 2000 server not on new 2003

Posted on 2006-09-14 02:08:47 by 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

Report this message

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

Posted on 2006-09-14 15:24:56 by 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

Report this message

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

Posted on 2006-09-19 19:54:10 by 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

Report this message