Hi Everyone,

Very new with MS SQL Server. I got the MS SQL added on the web server, and
i currently have site created in frontpage using MS access and ASP. i would
like to replace Access wiht this SQL Server...any idea on how to do that?

And web hosting created the database for me in the MS SQl...how do i add the
table in this database, which i can connect to the site?

Any help wil be greatly appreciated!!!

thanks,
Shikha

You would need to use the SQL Enterprise Manager to connect to SQL Server
and build tables in it. I think MS used to make the SQL Server
administration tools as a seperate download but I'm not sure if they still
do.If they don't, you can buy a copy of SQL Server Developer Edition for
about $40 to $50 and this includes a local copy you can work with as well as
the tools to work with any SQL Server.

Whenever you're in doubt of a connection string, check out
http://www.connectionstrings.com/ They have the format for just about every
connection string you can think as well as the variations for different
connection technologies.


--

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression

"shikha" <(E-Mail Removed)> wrote in message
news:086D5CD3-86D8-4B1A-ABBD-(E-Mail Removed)...
> Hi Everyone,
>
> Very new with MS SQL Server. I got the MS SQL added on the web server,
> and
> i currently have site created in frontpage using MS access and ASP. i
> would
> like to replace Access wiht this SQL Server...any idea on how to do that?
>
> And web hosting created the database for me in the MS SQl...how do i add
> the
> table in this database, which i can connect to the site?
>
> Any help wil be greatly appreciated!!!
>
> thanks,
> Shikha