Host that supports ASP
 

Anyone know of a good website host that supports ASP and its associated databases?

BTW, what's the difference between MySQL and the MS SQL?

They are different database implementations, different features, different performance, different everything.
SQL is just the general structure for query languages.

If I knew how to set up ASP support I'd do it.

Does ASP use both implementations? Which is better -- as in, easier... :)

That and I was kinda under the impression that ASP used MS Access databases. How does that fit into the bigger SQL picture?

Mysql's support in php is amazingly well thought out. ASP can use MySql but it's obviously optimized for access and MSSql use.
MYSql is also my preference because the wealth of free php code that allows for easy data managment far outstrips the amount of free asp code for the same function with SQL databases.
If you can find a well thought out asp code for data managment, use MYSql simply because it's a more widley used implamentation for small to medium scale data throughout the web.
Try sourceforge for asp code to use both and find what suites you best in the end.

ASP is the technology Microsoft uses for server-side scripting. ASP can use VBScript, JScript, or whatever is implemented within IIS (MS's web server).

VBScript (the most common language used in ASP) is easy to use with ODBC, and thus, MS Access and MS SQL databases.

OTOH, PHP is server-side and is used mostly with MySQL.

As arch13 stated, there are implementations of PHP and MySQL on Windows hosts so you could mix and match. However, it seems the implementation of PHP has some restrictions on the file system level with Windows that is easier to deal with in Linux because of Linux shell access.

As well, CPanel contains a wealth of GUI tools for using MySQL databases, managing file system security, shell access, and so forth.

Personally, I stick with ASP/VBScript and Access/MS SQL on Windows. I go with PHP and MySQL on Linux. I've converted most of my web sites from ASP to PHP and moved them to Linux hosts. Way more free tools.

I'm just getting started learning ASP some a lot of this seems pretty foreign to me. I knew a little Cold Fusion, and primarily used access databases with that. So, things aren't completely strange to me... I never had to deal with MySQL vs. MS SQL though...

May I see your website, rubicon? Perhaps an ASP site too?

Thanks.

Any generalized recommendations on hosts that support ASP?

For ASP hosting I've been using Best-Machine.com. Inexpensive with a good number of features.

I'd be happy to show you some of the ASP code I've written based on what you're looking for. I'll PM you.

you can also connect to a mySQL server through odbc and use it just like it were access or ms sql... odbc makes it so you can switch between multiple database platforms and not change any of your code.. as long as the db supports the sql syntax you can pipe any commands through the connection and get back records.

I like www.lunarpages.com for hosting... the use linux servers with mysql databases and the chilisoft asp implementation...plus it has the nice cpanel interface.