469,610 Members | 2,449 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

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

Sep 13 '06 #1
2 1293

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

Sep 14 '06 #2
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
Sep 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.