Tuesday, February 14, 2012

Does Visual web developer Express edition works with Ms 2000 Database Service?

I have made my website using SQL Server Express edition. It is totally database driven and manypages use databases to display data. My problem is that after paying for webhosting fees my web host told me that they do not support SQL Server express edition. Instead they have support for MySQL and Ms Access. Except that there is this MS 2000 Database service for an additional cost. Any recommendations what I should do except changing the host? If I pay for MS 2000 Database servicem, will my website work? My user management(i.e ASPNETDB database) was created by Visual Web developer and I don't want to do user management myself. Any advice?

HI Gurus,

I am also facing the same problem, i developed asp.net 2.0 application with Sql Server 2005 Express edition, with the bundled user managment facility. After completion the project, my host told, they only support SqlServer 2000 version.

In my website every pages linked with the database (connection strings). I dont know what i need to do?

This is very urgent, can anyone help? (Include Mr. Rex lim)

Sankar

|||

Hi,

Actually you can import the aspnetdb database into your SQLServer2000 by aspnet_regsql tool, backup the database file, restore it on your server-side. In this way, you can use membership, profile with SQL Server2000 database.

More detail about the tool:http://msdn2.microsoft.com/en-us/library/ms229862(vs.80).aspx

Thanks.

No comments:

Post a Comment