SQL Database Questions

SQL Database Questions

am 12.08.2005 22:07:01 von Jonathan

I am looking to replace an Access database on my web site with an SQL
database. I am running IIS to host the web site and I have a few basic
questions:

1) How do I create the database file? Do I need some kind of editor like the
Access program?
2) What connection string do I use?
3) Do I need to install anything on the computer running IIS?
4) Do I need any type of liscense to use SQL databases?

Re: SQL Database Questions

am 12.08.2005 22:28:04 von reb01501

Jonathan wrote:
> I am looking to replace an Access database on my web site with an SQL
> database. I am running IIS to host the web site and I have a few basic
> questions:
>
> 1) How do I create the database file? Do I need some kind of editor
> like the Access program?
> 2) What connection string do I use?
> 3) Do I need to install anything on the computer running IIS?
> 4) Do I need any type of liscense to use SQL databases?
No offense, but it sounds to me as if you need to hire a consultant to get
you over the "hump". In the meantime, there's a lot of information available
at http://www.microsoft.com/sql/default.mspx as well as at www.aspfaq.com

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"