Sql

Do I have to buy it?

[kris]

To preface this statement I have to tell you I am fairly new to database driven sites. I am looking to develop an ASP site with a SQL database. Do I need to buy a version of SQL, or should my web host "license" me to have access and administer my database to their SQL Server?

[weisinator]

You should be able to get SQL Server from your host.

Heh, you could make an Access DB and use that. I don't remember how you have to word the connection string to use the raw DB instead of ODBC, but it's fairly simple.

Don't expect lightning-speed, especially if you begin generating large amounts of traffic, or if you use the DB to collect data.

[hasbeen]

Definitely check with your host. The don't "license" you per se, but usually charge a bit extra per month/year for its use, and may put size/bandwidth restrictions on you. It will all depend on your needs.

[txbakers]

It all depends on the web host. Some will allow ODBC, some won't. Some have a DB, some don't.

Access will work if it's not that big a file.

If you plan on hosting it yourself you can get a copy of MySql for free.