tritium

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

__________________
Blah.

tritium

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

__________________
Blah.

kel

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

__________________
"It better be funny"

insidious_machinae

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

tritium

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?

__________________
Blah.

arch13

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.

__________________
Seen on an employer evaluation:

"The wheel is turning but the hamsters dead"
____________________________
Is arch13 really a porn diety ? find out after the film at 11.
-Nanofever

rubicon

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.

__________________
How you do anything is how you do everything.

tritium

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.

__________________
Blah.

tritium

Any generalized recommendations on hosts that support ASP?

__________________
Blah.

rubicon

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.

__________________
How you do anything is how you do everything.

f00sion

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.

__________________
Tell me what we’re fighting for— I don’t remember anymore, only temporary reprieve.
And the world might cease if we fail to tame the beast;
from the faith that you release comes an atheist peace.