I am using asp.net 1.1 On one of my applications page i am showing 3000 records in a datagird(from db). it takes 3 to 5 mintues to render these records in datagrid.
I have monitor the memory usage of asp_wp.dll process in the task manager. when it is rendering it takes max of 102 mb of memproy ram.
In the datagrid i have a check box column. User selects all checkboxes(by clicking on Check All(it is by javascript) and works fine). Enter value in the textbox and clicks the update button to update all selected values of the datagrid in the db and show updated values in the grid again.
for that i update in all the selected values in the db and get all the records from db again and bind these updated records agian to the datagrid. I carefully debug my application it update all the records successfully. and when it is updating the aspnet_Wp.dll process takes max of 70 memory uage. i get records from the db it is also fine.
But when i bind that records to the datagrid again it througs an exception and take more memory usage about 140 mb of ram. "Server unavailable" and my aspnet_wp.dll process also restarts. Exception also indicate me to see the event log for the resone of this particular error there i an error that aspnet_wp.dll exceds the memory usage that is allowed to it which is set to 154Mb.
I am using using stored procedure to get data in from the db into the dataset using SqldataAdapter i bind the datagrid to the dataset returned table. Code:
IN VS.NET: The web server reported the following error when attempting to create or open the web project located at the following URL: 'http://localhost/webapplication1. 'HTTP/1.1 500 Internal Server Error'.
IN BROWSER: Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
I had service pack 2 installed. Tech guy uninstalled it (said it conflicted with Novell) and then I reinstalled Framework 1.1 now I get these errors. I set show friendly HTTP messages in the browser unchecked to show error messages. Also got show error messages in IIS.
I have a site hosted on IIS6 by an ISP. When my page loads, it saves some information from a form into an Access DB, then reads the entire record, including the new data
Set Conn... Conn.Open... set RS... Conn.Execute UPDATE mytable WHERE... RS.Open... read data RS.close - set = nothing Conn.close - set=nothing Response.write data
The page is actually 20 pages, the text selected to display is chosen by Select Case request.querystring("p"). It's size is 70k.
It works fine on LocalHost, but "The page cannot be found.The page you are looking for might have been removed, had its name changed, or is temporarily unavailable." appears about 1 time in 10 on the web site.
It then appears OK if the Refresh button is clicked. Any ideas why? (only 1 user logged on, so not too much traffic).
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _ "Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
I'm just about to start a project that needs to combine the results of a SQL Server query with the results of an Index Server query. The basic idea is that the user enters/selects a bunch of search criteria on a form.
Most of the criteria selected by the user will be used to select records from the database - standard WHERE clause stuff - but the user can also enter free-text that should be searched for in associated uploaded documents.
The documents are sitting in the file-system with file-name pointers only stored in the database (not the document). Only records where the associated free-text is found in the documents should be returned. I'm new to Index Server and am wondering how is this done. Any good references/tutes?
I have an application that needs to pull files from an internal server. This is the setup. The web server is external facing, meaning exposed to the internet. I then have a file server that sits inside our domain. I created a COM object that can impersonate a user to retrieve files from that server. However, I cannot get the application to pull files from the internal server.
I first tried a domain account that could reach both servers. This did not work. I then had the network team create the same account on both machines. This is not working either. I can impersonate the user (I am able to get the user/users authenticated), but the script keeps coming back with and access denied. Code:
I'm stumped by one single thing when using Msxml2.ServerXMLHTTP.4.0. I'm sending an XML-formatted text string to a foreign server and getting a response back (using Windows 2000 Server and IIS). The problem is, when they send any special characters in the response string, my application chokes. Code:
I'm incharge of updating the stats on a chl hockey teams Web Site. I would like to know if there is a way to be able to save the content of the CHL Statistics WebPage on our Server and using it to update our Microsoft Access 2000 database.
If it possible, then I would take the content of that page. Execute some code that will take this information an place it in our database on our server. By doing this, our Team WebSite would be update automaticaly at a time that I specify on our server.
At this time, I have to open the CHL Statistics WebPage. Then Save the HTML page as a txt file, upload it on our server via FTP, then execute my my code that places it in our database.
I have a server that we installed a Web Application (ASP) and It works with a few clients that we tested, IE 5.5, and it does not work on the server machine itself. So we've tested a few thing.
Created a simple file with the contents of <html> <body> Hello World </body> </html> Made one with .HTM extension and one with .ASP.
I can see the HTM file from all machines. I can only see the .ASP file on the machine running IE 5.5 The server itself cannot see the .ASP page. We places the files in the root of the server web and in the Application folder with the same results.
Any one has Idea, How to use Server.Transfer and Server.Execute, When I tried to use these methods I got an eror:
Server object error 'ASP 0230 : 80004005' Server.Transfer Error /SISWeb/portal_logon.asp, line 40 The call to Server.Transfer failed while loading the page.
anybody is there who can respond to this problem. Do I need to change any setting at IIS?
How do you use server.mappath to update a access database on a completely different computer? One of my websites needs to update a database on a completely different website. Code:
I've recently uploaded a site to a new ISP, which is on a Win2003 platform. I've had a problem in that the existing ASP scripts handling email form submissions all experience the following error:
Microsoft VBScript runtime error '800a0046' Permission denied
From what I can gather this is due to moving from Win2000 to Win2003, and specifically the problem lies in this line of code: ....
I fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs .....
Previously I have canvassed a few way to get a registration code from one server to another - checking the results of the search and returning a function in a string tro be executed at the end. Well that worked until one of my beta testers decided that he would fiffle and get around the syste mmm...
i'm using a model, view, control architecture for a group of .asp pages.
i can't decide whether to use Server.Transfer or Server.Execute to pass posted data from my control to my model. are there security implications for using Server.Execute?
just wanting some advice on pros/cons to each of these since this is the first time i'm attempting to use these methods.
I accept a few user inputs and a file from the user, post it to my ASP page. I'm able to receive the data as well as the file properly in Receiver.asp. In my receiver.asp, I need to process the user inputs and subsequently POST this data and the file again to a different server. I would like to use ServerXMLHttp. Now, how do I simulate Form creation in receiver.asp.
I use the following code to post to the second server MyXmlHttp.open "post", myTargetURL,false MyXmlHttp.setRequestHeader "Content-Type", "multipart/form-data"
Now here's where I get stuck.
1) How do I construct the form data? How can I put together the data i received (which is text) as well as the received file (which is Binary) in the same Send statement for the Post? -- I assume that if HTML forms do it in some format, I should be able to simulate the same through ASP, but how???
2) The received file will not be stored anywhere in my server. It has to be forwarded in memory.
my prob is i have 2 different computers, one that runs my asp pages and the other my database server (mySQL). im working on my local and trying to connect my remote database with my remote webserver using DSNless connection string as more advisable. Code:
I have a website and use server.execute quite extensively. The website was put into production and at first all worked great.
but some users were getting to my site but an error message would pop up stating page was not loaded properly. TO many users it looks like the website simply does not exsist.
What happens is that when the web page (www.cheapbatterypacks.com/main.asp) gets executed it will fail for "some" people at the server.execute point.
Here is a good example of the problem. In my shop I have 3 computers on the same network. connected to a dsl connection etc. All have internet access all run IE6 etc. 2 will pull up www.cheapbatterypacks.com just fine. but 1 will not. maybe some of you will see the same error.
if you type www.cheapbatterypacks.com/loosecells.asp it will pull up fine but that file is supposed to be loaded by the server.execute function and not run on its own.
so now I am pulling my hair out to try and get these other folks on board and working.
How would something be so selective like this. COuld it be me webserver settings? And even if it was how come it appears to only affect some people.
This is a public website so there are no logins/passwords etc meaning they come in a anonymous and have only read/execute permissions.
I am still running windows 2000 server with all Sp's patches etc. IIS 5.0.
I am not an expert but I am trying to create an application where I need to connect my website to the user's(basically my client) database in access and then I will read the values from the database in the local drive and upload all the values in the database at my webspace. I will have everything like the database name and the password....so how can I do this
if there's a way to copy image files from one server to another using ASP and FSO? Or perhaps some other way to do it? I'm trying to collect information on books, and want to have a picture of the book associated with the description, but I want to be nice and host the pictures myself, not just link to other people's pictures. Is there a way to do this?
