I crated an app with asp.net mvc using entity framework 4 and sql server 2008.
Everything works well on localhost but when i move to iis i get this exception:
Cannot open database "Template" requested by the login. The login failed.
Login failed for user 'IIS APPPOOLDefaultAppPool'.
I am doing the MVC Music Store on VS 2010 and I get this expection: System.Data.EntityException was unhandled by user code Message=The underlying provider failed on Open.
Source=System.Data.Entity
StackTrace:
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source).....
It happens at the Album ablum line above. I checked and SQLExpress is running with login to Local system.
Complete code for Controller is:
[Code]....
I have an application which works well on a single server. My customer now wants to move it to a load-balanced environment. Which things are likely to bite me when doing this?Currently I know ofSession state, andMachine key.Both of these are described here, for example, so I'm looking for things additional to this.These similar questions, but the first addresses load balancing in general, and I'm looking for a migration guide, and the second addresses a specific problem.
View 2 RepliesI have an app that works fine . I build up a new iis box and the settings is similar to the existing iis box. however, my application is not working anymore. althought I created similiar environment, but not working,I get access denied from the Database for some pages and other pages it hit the database. is there anything I can do to make it work.
View 4 RepliesWe have a web site with pages written in both vb and c#. We wish to move from a web site to a web application. As a web application cannot mix languages, my thought was to build two separate applications within the same solution and have the main(c#) reference the secondary(vb) and (somehow) copy the vb pages into corresponding places in the c# directory structure at build time.
View 1 RepliesI have recently been working on my first ever SQL/ASP.net project and Have been building the database/web pages on my laptop, what I am wanting to do now is copy the database over onto a PC that is currently being used as a server....
On my laptop I am using SQL Server Express 2008 R2, and im guessing the first stage is to install this on the server PC. Now in terms of copying over all the tables, stored procedures etc for the database so tha it would function in the same way as it does on my laptop how do i go about this...what do i need to do? I ahve tried looking at a few articles/posts on the net and it all seems a little confusing.
i know ASP.NET and i would like to learn and make a new project in ASP.NET MVC. Is it easy to move from asp.net to asp.net mvc? Will the knowledge i have so far be helpful? Im asking because i will have only few days to learn asp.net mvc and i want to know whether it's possible.
View 4 RepliesNot sure if this is the right forum area for this question, so feel free to move it where it needs to be.I have a client that has asked to move an existing ASP-based website to a new web host. I've done host transfers before, but never an ASP-driven one.
So my questions are:
- Is there a way I can download the whole site as it exists and "test" it on my local machine somehow? (without having to install IIS preferebaly, it might already be installed to be honest)
- I'm sure the website uses a database back-end as it uses a CMS. What issues will I run into with regards to getting an identical database created on the new web host?Thanks all. I'm not feeling good about this transfer for some reason, mainly because I'm not that fluent with ASP, so if something doesn't transfer smoothly, I'm scared I may not be able to "fix" it in a timely manner.
Because of firewall issues, I have to have all of my database access on my production machine run through a wcf service. I've done this without problem throughout my site, but the issue remains for the AspNetSqlProvider provider. Is there a way to connect to the AspNetSqlProvider through a service?
View 1 RepliesI need Moving records up and down with Linq
View 1 RepliesIs there a way to easily passed around an ID between controller actions on the same controller?I.E. I have an Index action which takes an ID parameter, and when a user creates a new post I would like them to go back to the index page with the same ID.Currently I am just passing it around in my view model, but it seems real cumbersome and I was wondering if there was a better way to do this?
View 1 RepliesI have a VS2010 ASP.NET project saved on my computer that works fine. However, when I move in to my usb and attempt to check if it still works I receive this error:
One or more projects in the solution were not loaded correctly.Please see Output Window for details. The message in the output widow tells me the the file at the location does not exist which, I know because I just moved it. Also, I notices when I checked the suo file via Notepad++ that the file path was hard coded. Is there anyway, to change it so the project will open no matter where it is located.
I want to execute url but not to redirect to that page.My work should be cout. on the same page.. Eg :When i click on "Send" it should send that data to url bt page has to be same no effect should be their . .
View 3 RepliesWe have a ASP.NET application working on our staging server/DB. The application works fine. We are using ASP.NET Memebership/Roles, etc.
Now it's time to deploy the application to production. As part of the deployment, we want to copy/migrate the ASP.NET Memebership database to the production servers.
Can we simply do this via SQL Server's export/import functions? Will the applications IDs and role IDs that move to the production DB make sense when the ASP.NET application is deployed on the new boxes?
I have a data table I need to convert to XML. I know I can use datable.WriteXML but I need to rename the elements as the column names coming from the Oracle db are ugly. I found this snippet somewhere:
[code]....
It looks like what I want but when I paste it in my code it shows an error on select Cannont convert lambda expression to type 'string' because it is not a delegate type.
I am new to linq and for that matter to C# (done a lot more vb). I am going to read the books but I need to get this done pretty quick for a project.
My company has decided to copy a database from one server to another. I am concerned it will affect all the reports i have done. Will it just be a case of changing the dataset/source name in visual studios or is it more complex than that?
View 2 RepliesI have 2 servers i.e server1 and server2 .how to send file from server1 to server2 ?
View 5 RepliesI am using RangeValidator whose Minimum and Maximum vales are set in code behind dynamically. Minimum and Maximum values are exracted form the database. These values are in the range of 0 to n (integers only). Therefore user can enter values from0 to n (integers only).Now I have a situation where user can also put -1 which can't be handled by range validator. So my last option is to regular expression to handle such situation.Valid values for the user are (-1, 0-n). But I don't now how to get such regular expression , any help would be appreciated. I can manipulate expression in code behind based on values extracted from the database.Also , maximum possible value for n is 255 (Note: minimum and maximum values are extracted from the database)
View 11 RepliesI am having a strange authentication issue moving sites from IIS 6 to 7. I am still very new to IIS 7 and have not been able to find a reason for this. The site is running with form authentication and windows authentication enabled and anonymous disabled just as it was in IIS 6. I did not find any useful posts here or on the IIS site, so I am hoping someone might know the answer to this.
View 1 RepliesI moved my files from the BIN Folder to the APP DATA Folder.... cuz of some security issues and my hosting provider asked me to do so...
Now how do I import these files in my webpage....from the App Data Folder....
I have a problem with assigning string array into Datarow. Firstly, i have created the object for string array and put 2 values in the array out of 100(whole size). How many values should be placed in the array dependds on a different, which i am not showing here, though.
Then i tried converting into DataRow. But it says. "object reference not set to an instance of an object"
DataRow dr = null;
string[] strconcat = new string[100];
dr["concat"] = strconcat[i];
Edit-- Actually i was trying put these string array values into dropdown (ddchooseadeal).
[Code]....
I developed a test application using VS 2008 (ver: 9.0.30729.1. sp) and .net work (ver:3.5 sp1) using master pages,style sheets, ajax extenders etc.
I moved the whole website to another machine running VS Team System 2008 (windows xp) with the same above versions. The functionality of the application works fine, but the stylesheet seems to be affected. I have centered the whole application (fixed 960px). But when I ran the same app in new machine running windows xp the content area is getting floated or left justified. Is there anything that I need to take care when I move from one os to the other. What is causing this behavior? I tested using IE 8.
I am developing asp.net web application on visual studio 10. I want to move this project to another machine running visual studio 10. I have databases and style sheets with my project. Whats the best way to copy this project to another machine preserving all dependencies.
View 2 RepliesWhat should developers moving from ASP.NET Webforms watch out for when they move to ASP.NET MVC?
View 11 RepliesWhat are the latest and greatest ways to move ViewState to bottom of the page Can this be done in a IHttpHandler that can be specified in the web.config to intercept requests to "*.aspx"?
<httpHandlers>
<add verb="*" path="*.aspx" type="MyApp.OptimizedPageHandler" />
<httpHandlers>
Other options is that this could be done in a IHttpModule, but that is not as performant, as it will intercept all requests. Also it could be done in an a class deriving from the Page or MasterPage-class, but this is not as modular.Are there any performance penalties to this?