Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 19, 2007 02:28 AM by Sonia25
Mar 10, 2007 07:40 AM|LINK
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.
Mar 10, 2007 10:00 AM|LINK
Did you find this in your searching?
Mar 10, 2007 11:45 AM|LINK
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?
Mar 10, 2007 11:56 AM|LINK
Mar 10, 2007 01:49 PM|LINK
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.
Mar 10, 2007 02:27 PM|LINK
Mar 10, 2007 03:35 PM|LINK
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 :-(.
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.
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.
Mar 10, 2007 04:40 PM|LINK