Webmaster Forum / ASP / Database Access / October 2008

I'm trying to use inside a transaction scope the method
Roles.AddUserToRole(Username, UserRole)
but the DTC thows the exception:
"The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled

We have an old app that we're having a problem with. We're using MySQL
through ODBC on in an old ASP application. We running into some odd
type mismatch errors are cause us fits and we just can't figure out
what's going on. The following SQL statement works for most people but

I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm
trying to get daily sales totals.  The problem is sales for the day do not
stop at 11:59pm.  What is a clean way to select the records from say 8:00am
at start of business to 4:00am the next morning?  I ...

We're trying to resolve some performance issues and would be grateful for
your thoughts on the benefits of each of these methods to get the same
result.
Which is more performant?

I have two XML files that a generated from a database.
Presently I have to go into my admin section to click a link that
loads the pages that in turn create the pages.
As my database is updated (new entries relating to property sales)

"Active Server Pages error 'ASP 0113'
Script timed out"
I am still getting this error, and I am not sure how I could fix this.
When I execute the query at SQL 2005, it only takes 8 seconds.

I use a MySQL DB with my ASP classic web app.
I've been asked if I can create a routine whereby I get a random number of
products (records) from the DB and display these on the site.  Basically
every time a visitor hits the home page, they want the site to display a