Configuration :: Deploying A Database Driven Website?
Mar 3, 2011
On my local machine I have created a database driven website. All is working well on my local machine.
Now I want to upload it to my Arvixe Hosting. How do I do that from Visual Studio 2010 Keeping in mind I have a Database too ?
Do I need to manually create a Database on the Server ? Do I then create all the tables Manually ? Do I then populate the tables manually ? Or is it a 1 button click ?
I have just developed a website with VS 2008, ASP.NET 3.5. It contains a long range of pages and one contact page. The contact page is connected to a SQLExpress database, where details about all the visitors' requests are stored. The website works fine at the development environment, but when I deploy it to the internet host, the Contact page will not open any longer, due to all sorts of problems with the database. I have the database files located in the App_Data folder under the main directory for the website.
I have tried with all kinds of connection strings, setups, etc. - to no avail. I have also tried using the ISP's tool for creating a new database with the intention of copying the original database to it. But when I use the Publishing Wizard and generate a SQL script, then the Web Administration Tool for the remote database won't run the script. Now my question is, plainly: Is there any step-by-step procedure I can use, if I want a data-enabled website. It seems incredible that it has to be so frustratingly difficult. Basically, what I need, is:
* A database, located in the App_Data folder, to store all information received via the Contact.aspx page. * All visitors of the site should be able to post messages on the Contact.aspx page. * I have got the information from the ISP that I can connect to MSSQL via the server "host55.nethotel.ccSQLEXPRESS".
If a general procedure can be advised, and some directions about how exactly the database should be set up with authentication, rights, etc., for such a - supposedly ordinary - system, then I will be grateful for any information - or somebody who could point me in the right direction of a solution.
I have a website using .Net framework 2 on a dedicated server who's display periodically corrupts - typically after heavy traffic numbers to the server. I can correct the problem simply by uploading a batch of user-controls to the server, or recycling the memory pool.
Has anyone else seen this type of effect before, where the display of data-driven elements of a website corrupt?
I made a simple network tool using Visual Studio 2010 Express, ASP.NET C#.
When I finished, I deployed it to a Local IIS 5.1 Server. I'm running XP(BTW).
The situation right now is that every time I add/change something to suit my needs, it changes it directly on the server - which is obviously unwanted. I want to understand why this is and how to change it. I don't want every test I do to be implemented directly on save.
ps.
On Project->Properties, Web tab. I verified that under the "Servers" option, "Visual Studio Development Server" in checked and not "Local IIS Web Server"
so I have a fully functioning DynamicData website, and all works fine when debugging in VS2010But when I moved the site to a webserver (server 2008, IIS7) the default paeg comes up, but any links or pages after that are all sending 404 errors http://{IP address}/{table}/{action}.aspxdoes not work when on the server, but works fine in VS.What configuration am i missing from IIS7 to make this url work?
I'm deploying a web site to a server I've set up for testing. The website works great in development (Running in VS 2010) as well as in production on multiple client sites. I'm simply trying to test the site in a new environment. I simply copied the complete site (pages, code, directories, everything...) to my server. In IIS7 I created a new web site pointing to the directory containing my site's files and directories. I can open my site and my initial login page loads.
Database connections are made, page and buttons all seem great. Then, I log in. In the first line of code that attempts to instantiate an instance of a class contained in my App_Code folder, an exception is thrown, 'Invalid object name'. I've messed with as many settings as I could in IIS7 but to no avail. I've searched the internet on something regarding this, but nothing seemed to apply. At this point I'm about ready to install Visual Studio on my server to get it to run (this was the route one of the other developers took).
I have attempted to deploy my first WEB application and needed to include the Membership for Internet login. Application works fine when I use Visual Web Developer, but when I deploy to my provider when I attempt to Login, I eventually get the error message (this was after I turned on the debug="true" - full message is
[Code]....
When I copied the application to the WebSite, I assumed that the ASPNETDB.MDF needed to be copied too with everything that I defined for users and roles. Looked at the WEB.CONFIG and expected to see something defined here as to where it is located, etc. Do not see anything in my project with the name.
I'm about to roll out my web site soon, and was just wondering if there's a way to roll out the db I'm working with on my dev computer, or if I have to recreate everything on the production server. If I can roll out my dev db, will the uids be the same?
note that i can successfully connect to the db using the user 'SQL2008_736225_aldookandb_user' when i use a remote connection tool, such as sql server managment studio
And you can reproduce this problem, see it live and see the stack trace by doing the following:
A) :
1.go to my website [URL] 2.login as username: Teacher1 password: 123456 (Note that you have been logged in successfully) 3. go to the link in the upper right corner where it says (Teacher Page) 4. booooom!
B):
1. go to the website and create an account as a "Teacher" 2. do steps 2 to 4 from above and same problem occurs
I have a web site that has always run fine for years and years under 3.5. I converted it recently to run under 4.0, and it runs on Cassini fine. When I attempt to deploy the app to an IIS7 server that has 4.0 installed, all I get is "internal server error", and no error messages in the Event log, and nothing in the http logs.
I've double checked that the application pool I've deployed to is running 4.0.
It's an x64 web server and app (always has been while it was under 3.5.
I have developed a website using visual studio. Now i want to deploy the same on server having windows server 2008 o.s. and IIS 7. When i copy the website and paste it into wwwroot folder of iis its not working. What settings need to be done so that website can be accessed from iis.
i've written a small application using asp.net and sql server express.
my question is after checking the application in the visual studio environment how can i get it to work in a way that
users that are working on the same network as me could use it to?
i've changed the user instances option in the web.config file to false, and from the info i found so far i understand that security measures are to be applied, but i just couldn't get it to work...
i have created a website in vs 2008. and i want to deploy that website on other system. i don't want to give all the source(just like .exe file not source).
I get another error message regarding SQL database.In my project, the database for membership and roles is under App_Data, plus another DB data i created. both DBs are .mdf"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"I have my web hosting from GoDaddy, do i need to configure anything there? or is it something to do with my web application?This is my connection string in web.config:
I developed an application using VS2010 and now when i try to deploy it on windows XP maching running IIS 5.1 i get the database version error which says:
The database '<database file path>' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
<database file path> . Create is aborted.
An attempt to attach an auto-named database for file <database file path> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I am using XAMPP to publish my a .net application. The server is working fine. I created a sample login.aspx file, and it works fine. I deleted the sample login file, and I build and copy all the files to the XAMPP directory. When I tried to acces the page, it gave an error message "Access forbidden! You don't have permission to access the requested object. It is either read-protected or not readable by the server. If you think this is a server error, contact the
Apologies if this is is in the wrong place but I'm not sure where this issue fits. My issue deals with setting up an ASP.NET 64bit website on IIS6 (W2003 R2) so it could be a compiling problem or an IIS setup issue - I've read so much now I'm all tied up in knots.I have a web app which has been written on top of my company's custom framework, both have been compiled in .Net 2.0 with the "AnyCPU" option and run quite happily on my laptop within Visual Studio 2008 (on a Windows 7 Enterprise 64bit laptop). All of the code is managed code with the exception of 1 3rd party dll that I think is still 32bit.
Question 1: when running on my laptop in VS, is my web app running in 32bit or 64bit mode, given the OS is 64bit? I have both versions of .NET 2.0 installed.I have a new desktop that is to be our test server, and has been installed with Windows 2003 R2 and had IIS6 configured (same as the production environment). Again, both versions of .NET 2.0 are installed. When I copy my web app to the server and browse to the site, I get the dreaded "%1 is not a valid Win32 application", and sometimes (depending on what settings I've been playing with) "Service Unavailable" messages. If I register the .NET version to 32bit, and set the IIS 'Enable32bitAppOnWin64' to true, the app runs happliy the same as when on my laptop......but I don't want it to do that! I want to run IIS to run in 64bit mode with the 64bit .NET 2.0 Framework!Question 2: What does IIS see to make it think that my app is a Win32 app or am I interpreting that message wrong? Is the fact that I have 1 32bit dll in the in folder enough for IIS to say "32bit" and keel over?
My understanding of the "AnyCPU" option was that as long as the code is all managed code within the application, the bitness of the OS does not matter so I cannot understand why IIS6 cannot run the app in 64bit mode....and no, installing IIS7 is not an option.
I'm running windows 7, so I installed on my machine the oracle client version 11.1.0.7.0 (ODP.NET - Oracle.DataAccess version 2.111.7.20) . I'm trying to deploy an asp.net web application to a server that is running windows 2003, which has the oracle client version 11.1.0.6.0 (ODP.NET - Oracle.DataAccess Version 2.111.6.20)
Now when I compile my application and deploy it in a setup project (as pre-compiled). The start page of my web app tires to connect to Oracle and it returns the following error message:
"Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified."
Which is super weird because, cause the web.config file as shown above has Version=2.111.6.20.
Now the strange part is that if I copy the source code from the client to the server, the same code, same config file, it works just fine.
So I'm thinking that the pre-compiled version is telling the server to load Oracle.DataAccess Version=2.111.7.20, maybe in one of the dlls, not in the config file for sure.
Has anyone run into this problem?
what's the best approach to deploy to servers with different oracle client version? (I have a similar problem trying to deploy to a 64 bit machine)
I am in the process of putting a new site together which will make use of AJAX to pull through page content should the user have javascript enabled.
So, I am in the situation whereby every Action Method requires a check to see if the request was through AJAX or not, which is straightforward. If the request was through AJAX then I can return a partialview, if not then a full view can be returned.
With this pattern though, I'll need to create a View and a PartialView for every page on the site. The only real difference between them is going to the inclusion of the masterpage.
Am I missing a trick here is is this doubling up of views the only way to go?
I had a page that could get accessed through /site/test. Somewhere in my JS I would add a hash to the url like so #/site/test. JS would then watch for any hash changes and load the partial views as needed. If JS was not available though, an entire view would need to be returned.
So for each page I would need the view, which would then include a call to RenderPartial which would load up the partial view which would actually contain the page content. So, for every page there are two files. It just seems there should be a cleaner way of doing this.
First, I am new to VWD 2010 and attempting to create a data driven website.
I am attempting to return a value from an sql server stored procedure and store that value in a variable. I have searched here and online and tried to follow the examples that I found. However, I have not been successful in making it work.
Here is my stored procedure:
[Code]....
Here is my VB code behind where I am attempting to get the return value:
[Code]....
I know that I have a good connection because I am using the same connection string from my WebConfig file and it is working in other instances.
Below is the error message that is being displayed.
'The formal parameter "@monRegAmt" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output."
I'm used to developing private applications for very small amount of concurrent users (usually no more than 10) on very good servers, so I have never been pressed about stress testing my applications. That being said, this is something I want to have a better grasp on my applications.
FYI, all of my websites are based on ASP.NET 3.5 (WebForms), NHibernate (specially interested in testing it with numerous concurrent sessions) as the ORM of choice and require Active Directory authentication.
To learn ASP.NET MVC, I am thinking of creating a community forum like SO where people can rate posts, users etc. and the user can thereby gain points. I just can't figure out if the points should be added to the user profile whenever an action is done (post rated up/down, user created new post etc.) or if it should be calculated from the different activities the user has done.
I have a few pro's and con's for both ways of doing it: