SQL Query Problem

Report · Dec 18, 2006

I am trying to run a basic query on my Access database, using ASP.Net code generated through Dreamweaver. The query works when run directly against the database but hangs when I try and run it through ASP.Net on my IIS server.

The query is as follows:

myQuery = "SELECT (RatingTotal / RatingNumber) AS Avrating, * FROM Campaign_Table WHERE RatingNumber > 12 AND Status = " + Chr(39) + "Open" + Chr(39) + " ORDER BY 1 DESC"

Strangely this works fine when the RatingNumber > 12 is changed to RatingNumber > 5 (this returns three results rather than two).

No error message is given the page simply hangs before it is loaded and CPU utilisation goes to 100% on the aspnet process.

Any ideas what is causing this?

Report · Dec 18, 2006

Check your MDAC version. If it's less than 2.81, then you need to go
update.

"Yooma" <webforumsuser@macromedia.com> wrote in message
news:em6pss$855$1@forums.macromedia.com...
>I am trying to run a basic query on my Access database, using ASP.Net code
> generated through Dreamweaver. The query works when run directly against
> the
> database but hangs when I try and run it through ASP.Net on my IIS server.
>
> The query is as follows:
>
> myQuery = "SELECT (RatingTotal / RatingNumber) AS Avrating, * FROM
> Campaign_Table WHERE RatingNumber > 12 AND Status = " + Chr(39) + "Open" +
> Chr(39) + " ORDER BY 1 DESC"
>
> Strangely this works fine when the RatingNumber > 12 is changed to
> RatingNumber > 5 (this returns three results rather than two).
>
> No error message is given the page simply hangs before it is loaded and
> CPU
> utilisation goes to 100% on the aspnet process.
>
> Any ideas what is causing this?
>