Not Able To Access Webpage / Not Connecting To DB?
Oct 6, 2010
I've a problem with my web application. I hosted a web site in IIS and initially its working good. After sometime ( i dont know the time diff exactly ), if i try to access my page its not working and after re-starting my application only its working. Let me explain about my project.
I've only 4 pages ( ex: main, a1,b1,c1 ) in my site. In main page i used IFrame to show other 3 pages by clicking the appropriate tab. Before this main page load, i'm connecting to DB (Oracle 10g) and i used "System.Data.OracleClient" class to communicate with oracle. Every time after retrieved data from DB i'll close the connection. Then i'll display the main page and assign other page url's to the tab.
Now the problem is after sometime if i access the main page, its not connecting to DB at all then i'll show some static message like "site is unavailable at this time". And i'm not using connection pooling concept. And also this problem is not occurring all time.
I am trying to connect to a SSRS - Reporting Services Scheduler i.e. to create a SSRS subscription from a ASP .Net web page. I need to find an API which can do this.
How to create a WSDL link. I am getting an error when i am trying with adding a service reference. I gave this format as below.
or one of my project, I use Access 2007.I have application written by Access, that use database : Sql-Server 2007.I am using XP for the any company computer.The dsn file is on network, and include connectionString with username + password,ut I want to access the database from any user with automatic authentication (no need for user and password).
I have a window form app with reports that connects to an Access Database i had already build the project and every single report works fine without any problem, Here is what's stange, when i try to add a new report to the project and try to connect to the database i am getting 'Visual studio has a problem and need to close' i don't know what is the problem, i can open the database and run queries without any problem but whenever i want to connect my newly created report to the database it just failed. It does not give me a detail error so i can fix it.
I am creating a ASP.Net application in MVC architecture. I have to connect to a database on MS Access and be able to enter data into it. All examples I see use SQL Server. When I try from prject explorer Add New Item -> Data -> I am unable to find Drivers for Access Database.
From the Data Connections in Server Explrere window I was able to make a successful connection to the database.
I have a WCF service hosted on win 2008 server. I'm using WAS to expose a named pipe endpoint on the service and have a client website that consumes the service. When i hit the website from a remote machine i get the following error:The pipe name could not be obtained for the pipe URI: Access is denied. (5, 0x5)Now if i hit the website ON THE SERVER it's being hosted from, using localhost in the url, it works fine. Clearly there is something i don't understand about what the named pipe endpoint is looking for. I tried running a trace from my service, but there is no output because the call doesn't even get to the service.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'provider'
what am I supposed to do to make this connection work! I have always done it in dreamweaver with no problems, but I have to use Visual Web Developer for this project.
I have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
I am working with a client who wants to make his current MS Access 2007 Reports available on demand in his web site. Currently, as I understand it, the managers of the company are being required to actually load MS Access and the active database to run the reports which exposes all of the data and linked tables to people who have no reason to modify them. So my client just wants them to be able to log into the admin section of the company website and request a report which he has already built in Access. I am trying to figure out how to get those reports to an ASP.NET application for the website to consume.
I have already spent a day looking at the Microsoft.Office.Interop library, and I don't think that that will cut it because I can actually get the HTML for the Report directly out of the application. All I can find is an option to save it to the hard disk which is inelegant and could easily cause problems with filename changes when I try to then load the document from ASP.
What I would like to see is a solution by which I can load the mdb or accdb file into the ASP application, access the Reports as a container and select the one I want by name, and then run it and collect the output in HTML to then simply echo to the webpage. Is there anything out there that can:
// Psuedo-code Dim AccessFile As MSAccessFileOperator Dim Reports As List(Of MSAccess.Reports) Dim htmlResult As String AccessFile = New MSAccessFileOperator("myDatabase.accdb") Reports = AccessFile.Reports htmlResult = Reports("MyReportName").toHTML
I haven't found such a method yet, and I am okay with the idea that maybe it isn't possible to do it that easily, but, at the end of the day, I need the HTML result of the Report to exist in memory as a String.
Is it possible, and if so how do you access the webpage from the webhandlers?
Basically, when i button is clicked i kick off some JavaScript, which then kicks off a C# webhandler which return data from the server. What i would like to do then is rather than feed it back to the JavaScript, id like to add a GridView directly to the webpage from the webhandler.
Equally, within the handler it would be incredible useful to be able to read values of dropdowns etc from the webpage.
I have an Access db on webserver. In my ASP webpage I need to return the sum of rows which match criteria.
I am not sure where the sum needs to happen. I tried sum in the sql statement, but got an error when it tried to put it in asp page.this is what I have
strSQL = "Select * from tblApplicantCreditors where ApplicantID = '" & strApplicantID & "'"
Trying to figure out how to programmatically access the web pages in the application. Just something simple like a list of them would be awesome. I know I can create a list but I was wondering if there was something that could 'look' at the pages and add a new one to the list if you make a new page for the application.
Example with 7 pages:
Error Default Login Content Users ContactUs Admin
I am half awake so I may be a little unclear. Maybe puting it all in a single question will be easier.
How do you autogenerate a list of all webpages in your current application?
I'm building a website that just allow each person in my office to access the page from their own PC placed at the office only. It looks like I need to identify a client from within the codes on the ASP.net web server. How can I do this?
I am wanting to build a asp.net page where the user is presented with drop down boxes.
The drop down boxes contain information from an access database.
The access database contains more than 5 tables.
For example, I am going to use a customer website database as an example:
Contained in the database is:
Server Name
Server Type (Shared web or Dedicated)
Customer name
Sites the customer has.
Funtionality:
Say user one wanted to view all records by the server name:
The user would select the relevent server name which is in a drop down box.
This will automatically filter the database results and in turn will display on the webpage all the customer sites associated with that 'server'
Next I want the user to be able to filter those results again, and say the user wanted to filter the sites by "server type", the user would then select the type in another drop down box and then the data will be refreshed to show the sites that are on that sever, and server type.
I have published ASP.NET web site, using IIS7 on Win7. I can access this web site on my localhost, but it is inaccessable from other computers via internet. I have tried to disable firewall and anti-virus program, but with no success.
Does anyone know what may be causing this problem?
i am trying to update my database via a textbox on my web page.
so that when a number is entered into this textbox and the button is clicked, it goes and changes the previous value to the one u have just entered.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Try ' cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAshMyDocumentsplatypus_holidays.mdb;") 'Connection String cn.Open() str = "update holidays set holidays_left=" & CInt(TextBox3.Text) cmd = New OleDbCommand(str, cn) icount = cmd.ExecuteNonQuery TextBox4.Text = "The value was change to " & icount Catch TextBox4.Text = "The value was not Updated" End Try update_holiday_values() cn.Close() End Sub
I published my website with Visual Studio and used FTP to transfer the Default.aspx page in the root folder and the compiled file (Default.aspx.cdcab7d2.compiled) in the bin folder of an SQL server that supports ASP.NET (StartLogic). But, when I used a browser (Firefox) to access the Default.aspx web page, all that I got back was: This is a marker file generated by the precompilation tool, and should not be deleted!
What am I doing wrong? Why can't I get the page to be displayed properly?
I Have a webpage named "Test.aspx" and a web user control named "TestWebContro.ascx",..
i have a "Linkbutton" on "TestWebContro.ascx" and "Label" on "Test.aspx",.. now my query is how can we change the text value of "label" on the click event of "LinkButton",...
I am deving a webpage. For testing purposes i want to access the webpage via my VM and possibly ask a friend to mess with it remotely. The app is running in visual studios 2008. I put set my router DMZ to my IP address and i tried connecting via VM and remotely. No luck. How do i config visual studios to listen outside of the machine?
I just download XAMPP, and it is running in my local computer. I added the index pages, and it works fine. However, when I copied my pages and all related information,I tried to access the page. Then, it displayed the error message below.
Note: The <httpRuntime requestValidationMode="2.0" is required because I am using a chkeditor with a textbox to create a microsoft word like effect. I remove itfrom the web config file, but then I get a similar error. This time, it was complaining about <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
I set up a secured folder in my website. When I access this folder via web page, it pop up a windows login form to ask for user name and password. I would like to code the asp.net page or java script to access this secured folder with username and password without pop up the login form. find the method for asp.net page accessing the secured folder automatically.
