Just a couple of quick questions regarding the deploying of a site from VWDE to a remote host.
Firstly, I clearly understand that one has to enable the ASP.NET functionality on the remote host server, but, as VWDE features its own built in database, is it possible to upload the whole site without enabling a database on the server? I ask this as I'm
curious to know whether the ASP.NET framework will configure the database itself once uploaded along with the web site. (I'm further led to think this as the bundled in database carries a 4GB restriction).
Secondly, along with using the 'copy' method to deploy the site, if the database requires setting up on the server, how should this be done? I've looked around extensively on the net but have found very little information on these topics.
Thank you for responding. In answer to your question, no I didn't funnily enough; it was exactly the kind of information I had set out to find.
The piece states, "Your application will continue to run as long as the SQL Server Express Edition is installed on the target server."
From that, I gather that the web site can be uploaded 'as is', and it'll function in the same fashion as it had been whilst testing locally.
The article then states, "Because SQL Server Express Edition uses the same file format as other versions of SQL Server 2005, you can copy the .mdf and .ldf files to a server running SQL Server and then attach the files as a database."
Again, to me it's clear that if the host server's not running SQL Server Express, I'll then have to initiate a database (which will cost money) on the server and then copy the database files to it.
Unfortunately it will cost money as the host server does not support SQL server express. I believe either SQL Server 2000 or 2005 is supported, or both.
The host has just informed me that, "At present, we don't offer SQL Server Express Edition."
So I suppose I can assume that they're running SQL Server 2000. Of course, that's also assuming the person who sent the mail is knowledgeable as regards SQL Servers. No choice then but to extract the mdf and ldf files from the project and incur the cost
of uploading an extra database :-(.
The only thing that is required to make mdb files accessible to a web site is the Jet 4.0 driver. Since that comes as part of MDAC, it is pretty much guaranteed to be available on any Windows server.
Ok, but it isn't just accessibility I'm concerned about; it's 2-way binding. Data is inputed by user A, from where it's stored and then filtered accordingly by, and displayed to, user B.
When the hosting support acces or SQL then it is always possible to add data, it's op to you to make the correct code and make also the correct security. I'm working with an access databas where a few people can add data and they must firt login before they
come to the page for adding and edit data to the access database
Max01
Member
21 Points
33 Posts
Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 07:40 AM|LINK
Hello,
Just a couple of quick questions regarding the deploying of a site from VWDE to a remote host.
Firstly, I clearly understand that one has to enable the ASP.NET functionality on the remote host server, but, as VWDE features its own built in database, is it possible to upload the whole site without enabling a database on the server? I ask this as I'm curious to know whether the ASP.NET framework will configure the database itself once uploaded along with the web site. (I'm further led to think this as the bundled in database carries a 4GB restriction).
Secondly, along with using the 'copy' method to deploy the site, if the database requires setting up on the server, how should this be done? I've looked around extensively on the net but have found very little information on these topics.
Thanks in advance for any response.
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 10:00 AM|LINK
Did you find this in your searching?
http://msdn2.microsoft.com/en-us/library/ms228037.aspx
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
Max01
Member
21 Points
33 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 11:45 AM|LINK
Hello,
Thank you for responding. In answer to your question, no I didn't funnily enough; it was exactly the kind of information I had set out to find.
The piece states, "Your application will continue to run as long as the SQL Server Express Edition is installed on the target server." From that, I gather that the web site can be uploaded 'as is', and it'll function in the same fashion as it had been whilst testing locally.
The article then states, "Because SQL Server Express Edition uses the same file format as other versions of SQL Server 2005, you can copy the .mdf and .ldf files to a server running SQL Server and then attach the files as a database." Again, to me it's clear that if the host server's not running SQL Server Express, I'll then have to initiate a database (which will cost money) on the server and then copy the database files to it.
Am I right?
Thanks.
sgroenen
Member
128 Points
73 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 11:56 AM|LINK
Hamont, Belgium
www.stefagro.eu
Max01
Member
21 Points
33 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 01:49 PM|LINK
Hello,
Unfortunately it will cost money as the host server does not support SQL server express. I believe either SQL Server 2000 or 2005 is supported, or both.
Thanks.
sgroenen
Member
128 Points
73 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 02:27 PM|LINK
Hamont, Belgium
www.stefagro.eu
Max01
Member
21 Points
33 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 03:35 PM|LINK
Hello,
The host has just informed me that, "At present, we don't offer SQL Server Express Edition." So I suppose I can assume that they're running SQL Server 2000. Of course, that's also assuming the person who sent the mail is knowledgeable as regards SQL Servers. No choice then but to extract the mdf and ldf files from the project and incur the cost of uploading an extra database :-(.
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 03:52 PM|LINK
The only thing that is required to make mdb files accessible to a web site is the Jet 4.0 driver. Since that comes as part of MDAC, it is pretty much guaranteed to be available on any Windows server.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
Max01
Member
21 Points
33 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 04:16 PM|LINK
Ok, but it isn't just accessibility I'm concerned about; it's 2-way binding. Data is inputed by user A, from where it's stored and then filtered accordingly by, and displayed to, user B.
Thanks for responding.
sgroenen
Member
128 Points
73 Posts
Re: Deploying a site from Visual Web Developer Express (VWDE) - Basics.....
Mar 10, 2007 04:40 PM|LINK
Hamont, Belgium
www.stefagro.eu