Second, does .Net studio support mysql/php or is it better to switch to another db and use asp. Finally, I'd like recomendations for a different setup if my setups are completely wrong headed.

I have found out that the best way to connect to a database should be this way: But I guess I can't just copy the files in MySql togheter with the ASP-app to an other computer and run? I need the ...

We have a legacy setup that runs ASP and SQL2000, each on their own servers and each are on a fully patched SP'd Windows 2000 Server. This ASP web app is well known for hammering our SQL2000 server ...