I have a system which has an asp.net front end and a SQL Server DB.
I get a file in the form of an excel spreadsheet every few weeks that contains a number of fields. I want to load it into the DB and the appropriate fields in the excel spreadsheet would go into the corresponding field in the DB tables.
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
i have requirement of running my application over wan hence i used a fixed ip addres in browser i.e(fixed ipaddress//hostmachineip address//mk(virtual directory)/xyz.aspx(cs file))...and m getting follwing error while accessing my app over wan
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
i infact googled for this n made changes according to the experties advice but not able to overcome this issue ...what's wrong i am doing here?please anyone suggest me best oible solution to overcome this issue.
one more doubt when m accessing my application using fixed ip adddress then i should type in browser as follwow
fixed ip adrees//ip address of host machine??
when i did so then got follwing message in
404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.
since i have installed iis in my host machine in this way if i access my application with above entry then it should show me iis page not the 404 instead?...please correct me if i am wrong....n do help me with solutions.
For your site to be accessible via just the IP the site has to be mapped accordingly so that all requests for the IP go to your site (or all requests in general by leaving the "hostname" empty in the bindings). At the end of the day your site is wrongly configured, we can't access your IIS settings, we don't know how you've set it up. I'd spend some time learning how you configure sites and how IIS works, as just repeatedly saying that your site doesn't work is like phoning a mechanic and saying "My car doesn't work, what's wrong?"
i have already configured my host machine ip address to my router with which host machine is connected with ...hence i just need to type a publice ip address on the browser of remote machine and ip addres of host machine like below
public ip address//host machine ip address configured to the router
in this way once i type above in remote machine my iis page should be displayed ....but its giving error that serever not found....which is not the case when i am doing the same in LAN ....infact my app is working fine....only while making it work over WAN m getting the issues....please let me know where i am going wrong
I am following this tutorial: http://www.w3schools.com/aspnet/mvc_models.asp, to get data from SQL CE using Entity Framework. There doesn't seem to be much code. The tutorial is for MVC3 but my project is MVC4, but I think major steps should be same.
I created a SQL CE database, and a table with needed columns.
Added data to the table.
On the C# side I have
public ActionResult Index()
var c = db.employees.ToList();
That sample is for movies database, I changed all relevant info to employees.
I added the connection string as in that tutorial too.
But when I navigate to the Index page of above controller, the empty list is returned. What did I miss?
It seems I gave correct meaning to table columns too (e.g. similar to Employee class properties)
PS. This is how the DB looks after I stop running the app image