Open recordset worked on Windows 2000 server not on new 2003

K

kifaro

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
 
M

Mike Brind

kifaro said:
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?
 
K

kifaro

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

Aaron
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top