Hi

I have access to a MS Sql database from my webhost.
I have used MS Acces in the past and created the tables locally then uploaded the MS Access DB.

How & what do I use to connect to the MS SQL DB on my web host and start creating tables within the DB?

I'm new to using MS Sql.

Thanks in advance for any help.

Cheers

Think big thoughts, but relish small pleasures

If you are hosting your site on third party server then they should have an interface to create database and tables. you will be given db name, username and pass that you can use in your conn string.

if you are hosting your site on local server then you can access sql same as you access for any other application.

the only difference in using access or sql server db is the connection string.
check out this link
http://msdn.microsoft.com/library/de...singadonet.asp
hope it helps