AdLockOptimistic Hangs Up MySQL
This line:
rstUpdate.open "SELECT * FROM Events WHERE EventID=2", db, adOpenKeyset, adLockOptimistic, adCmdText
in my page give me an error that says:
ADODB.Recordset.1 error '80020009'
Unsupported Lock Type.
Can anyone offer a suggested cause?
View Replies
ADVERTISEMENT
please some one help me Sometimes ASP hangs, and ASP pages aren't served anymore. I have to reboot. Is there some workaround so I don't have to reboot every time this happens?
View Replies
View Related
I have a number of clients running an ASP applcation on iis6.0 and windows server 2003 web edition. Occasionally IIS seems to hang and has to be restarted. I have seen in other messages mention of a known Jet engine bug in ws2003. What is this, What does it do and how can I clearit?
View Replies
View Related
We have an application which uses Crystal Reports, FireBird and dynamic
views to display reports. When in a short period of time a lot of reports
are displayed IIS hangs. Stopping and starting IIS does not help. The only
solution to get IIS working again is a reboot. One time I got a message that
there are to many users. But only once. All the other times it just hangs.
The to many users I do not understand, because at the moment I am the only
one using (testing) the application. Anyone an idea what could be the
problem and how to solve it?
View Replies
View Related
I am using JSRS
I have 3 select boxes(on an ASP page)..country,city and zipcode.When user selects a country,city select box is filled for chosen country using JSRS.but I am facing a problem..for some countries after select the browser hangs like Australia.for which there r 11,000+ cities..but same thing works in Netscape
View Replies
View Related
I'm struggleing for months with one problem. I have created one COM (dll) object. When I call it inside IIS (ASP/VB) it works fine for a while and then IIS hangs. Then I have to restart my PC (Win 2000 Server) using (hardware) tower button, because Windows can't turn off IIS either.
As much as I could, I insured there were no uncought exceptions thrown and dialogs displayed by my COM object. How can I find out what causes IIS to hangs? I'm totally beginner with IIS. Is there some ATL/IIS guide which explains what ATL settings (threading model...) should be used when deploying COM object to the IIS?
View Replies
View Related
I'v Windows 2000 , IIS4 and SP3 as WebServer.I use ASP 3
there. In an interval of 4-5 days the system stpos
working, just request for a page and it doesnt work. I
just terminate the process of dllhost.exe and it starts to
work file but upto 4-5 days only.
For information I use
COM written in VB6, that opens the connection for me and i
close it once my i get data. And only asp page stops, a
simple htm page still works in that situation. I would
have liked to send the IIS logs of the day when it hanged
but i think i cant do that.
View Replies
View Related
My site was working well but when I restarted the computer after having a automated virus update, My IIS stopped working with ASP, I've restarted, re-linked with other directories, changed the IP address, and I've tried all the other usual methods.
What I've found out so far is that with HTML it is working perfectly, but when I hook on asp, I have problems. First It gave me the error message: 500.2
now the browser is just hanging.
View Replies
View Related
Does anyone have a suggestion how I could debug this
problem:
1. Data is collected from database and displayed in a form.
2. User updates data and submits it.
3. Submitted data is compared with old data.
4. SQL is generated for changes and put into an array.
5. SQL in the array is executed line by line.
I've copied the code which does the update from a working
page that does something similar. And tested it with a
basic update to be sure. But for some reason when I
submit this sql:
update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and
invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At
this point the whole site becomes unusable until I restart
the IIS Admin service.
I've pasted the sql into Toad and tested it there and it
works fine. Could anyone suggest what the problem is, or
how I could go about debugging it. Normally when I get
errors thet are written to the screen. But in this case,
I dont get anything back at all. Code:
View Replies
View Related
I've a server which hosts couple of hundreds sites. From time to time I can't access some of the websites, all of them are ASP. HTML ones are fine.
I've tried to use iisstate, but I can't seen any errors in the log, not even a warning. Also, there is nothing in the Event Viewer. The server is 2003 standard.
If I will restart IIS service, all is back to normal. I know this doesn't say much, but do you have any ideas where should I go from here?
View Replies
View Related
I have an ASP script that is called from a PDF form to process form data.On the last line of the script I have a Response.Redirect "webpage.asp" that leads to another target page with actual HTML. However when I start this process (by submitting form data) even when I comment out the processing code, the address bar shows the desired page, but the page never appears and the flag keeps spinning indefinitely and doesn't stop even after 15 minutes.When I finally press Escape to stop it and then I press Refresh
the page appears immediately.
I've found that if I remove all the HTML code that has links to other files images, javascript,stylesheets that the target page loads promptly from the same Redirect method.
Does anyone know what could be causing this?It seems IE or IIS gets lost looking those other files.
View Replies
View Related
I am having the form elemetns for "FILE upload" 4 nos. and 4 "textarea" elements. I am keying the UTF-8 text in the textarea. The storing mechanism for the "images" and "text" are done in a separate file. The problem is here:
While submiting the form to the storing page, the browser (IE)gets hang & closed. But the data stored properly in the database.
View Replies
View Related
When calling an ASP from within a Perl script to perform a query against a web-enabled database (don't ask how we arrived at this architecture), the first query almost always times out with an Timer_EntityBody error.
Our timeout is currently set at 300 seconds. We can see that the worker thread
(we only have one for compatibility purposes) gets kicked off when the query arrives. Successive queries do not time out. Has anyone had any experience with this type of issue? What did you do to troubleshoot it? Did applying SP 1 help?
View Replies
View Related
This code works fine local with PWS on win98 and also on the Internet:
Set emailLog = Server.CreateObject("Scripting.FileSystemObject")
But on a local XP computer, the IIS hangs. The message is that too many are
trying to access the page.
View Replies
View Related
I'm using IIS on W2k, using ODBC access to the database (which is on the
same server as IIS).
The system is designed to generate reports from users after they have walked
thru a few pages, supplying report parameters. The actual creation of the
report is done on another server, accomplished via a COM object that the web
server creates. This all works wonderfully.
However, after going thru this process, it seems the database connection
from the web server 'hangs', meaning any subsequent page requested from the
web server that has anything to do with the database will never complete,
and at this point never timeout either. My only solution is to reset the
IIS service.
At the point that the hanging occurs, I am still able to access the database
from other programs. I am able to access static pages on the web server. I
have looked at a number of performance counters under the ASP, IIS Globals,
and Web Service objects, but all show zero activity. Even the lowly Task
Manager shows nothing going on in the web server at all.
Is there anything I can check to see what is going on, what is being held
up?
View Replies
View Related
When I submit my form to the same page its on, the browser hangs up with lengthy strings in my "textarea field."
It won't take anything over about 200 - 250 chars.
Right now I have Request.Querystring for each element of the form. I've tried just Request and it does the same thing. I also tried Request.Form and it doesn't capture the values.However, as far as the database field, i have a VARCHAR(8000), the max the datatype can hold, so that I can post, if necessary, giant news articles.
View Replies
View Related
The asp script uses the WSHSHELL run method to launch a local application on the web server but The application process hangs each time when this is called from the web.
If the application is manually run from the command line or through a bat script (by double clicking on it), the application process launches and executes the batch file successfully.
If either of these actions are called from the .asp script, the application process.exe is seen running in the task manager and hangs.
View Replies
View Related
We are facing a situation here related to rendering of IFrames in Internet Explorer. The situation is as follows:
We have an ASP that contains some data along with three IFrames in it. The 'sources' for each of these IFrames are set after the ASP page is loaded in the browser using a Javascript function. Basically, this JavaScript function checks if the rest of the page has finished loading and then sets the "<IFrame>.src" attributes for the three IFrames one after another.
Now, each of these IFrames contains separate ASPs. These ASPs call one Web-Service each to get some data and then render it in the IFrames. The problem arises when one of the Web Services in any one of the ASPs fail to respond and hangs up without returning any error message. We are expecting that if one web-service fails for a ASP, then the other two ASPs should execute and get rendered in the corresponding IFrames in the browser. But it does not happen. All the three IFrames hang up together.
Could you please suggest us anything to solve this ?
We want to get the corresponding data loaded in the three IFrames asynchronously, so that even if one fails, the others are not affected. Can IFrames load asynchrounously when called from the browser through a Javascript function ?
View Replies
View Related
I installed SP4 for Windows 2000.
Prior to the upgrade my system was at SP3 and I was able to run ASP
scripts from my browser just fine. For exmaple: Code:
View Replies
View Related
I have a content management system with a html editor embedded in a page (uses a text area tag) within the tag I use Server.Execute(pageToExecute), it works for some pages but others it hangs the browser.
If I remove the ServerExecute line the page loads fine. Theres no error messages nothing and the page it is executing is simple html in an asp file. Any reasons why this would happen? Im using Windows Server 2003. All browsers.
View Replies
View Related
I have a problem with a win 2003 server Standard edition.
Sometimes when I'm working in my web application the session hangs
(but not the ASP-application). In the application log I find the
following error:
Event Type: Error
Event Source: COM+
Event Category: Unknown
Event ID: 4689
User: N/A
The run-time environment has detected an inconsistency in its internal
state. This indicates a potential instability in the process that
could be caused by the custom components running in the COM+
application, the components they make use of, or other factors. Error
in d:
tcomcomplussrccomsvcs hreadsstawork.cpp( 156), hr =
80010108:
Callback failure handled by IAsyncErrorNotify
I have installed the "Network DTC-Access" and started the "COM+ System
Application process". After i did this it worked a lot better,
unfortunately the problem still remains (however not in the same
extent)
The ASP-application is built in VB and uses four different dll-files
for things like uploading files etc.
When I run the application on a win 2000 server everything worked out
perfect.
View Replies
View Related
My server hangs for a really long time after I run the following code...
It is to serve up 3 types of files: a picture, a word document, and an mp3 file from a directory "/uploads" that is not accessible through the URL. The script works perfectly for the picture and doc file, but nothing loads when it is used for the audio files. The files are a few megs large, but after I run it I can't access ANYTHING on the site for quite some time.
What's wrong? Is it something wrong with M@rco's script? Did I impliment it wrong?
I don't mind if it simply takes a long time for it to load the audio file, but it is killing the entire server it seems like. Code:
View Replies
View Related
I am trying out the ShadowUpload script for the first time for uploading photos etc. I place the ShadowUpload script, upolad page that goes with the script in the wwwroot and then made a folder with full read/write permissions enable called uploads. When I tried to upload a large picture, it gives me the expected error Code:
View Replies
View Related
I am using an asp script that uses rptserver.asp to display some reports over http. It worked fine previously but now the webpages with the report display just hang. I tried switching from the activex viewer to java viewer and still the same. I don't know what changed, except I do the Windows updates. Can anyone tell me the best way to trouble ASP
problems. The page just stays blank forever and that status bar slowly progresses. No errors in the event log on the server. The HTTPerr log has the following errors:
2006-09-14 19:13:14 x.x.x.133 30531 x.x.x.5 80 HTTP/1.1 GET
/webreport/reports.asp?Report=Project%20List%20Detailed%20w%2 0Client(P).rpt
- 1 Connection_Dropped ReportsPool
No entries for this in the W3SVC log.
This started hanging my other web app on the server, until I put it in
a separate Application pool.
Here is the reports.asp code: .....
View Replies
View Related
I am trying to create a file on my server / localhost but when I run the script below the page starts loading and then eventually times out. Code:
View Replies
View Related
I am experiencing a web site "hang" after a bot is crawling it, there is no evidence of a particular bot as it has happened with 3 or 4.
I have not found much help from google support or any others that can advice me or point me towards a solution. I wondered if anyone else has experienced this issue, and if so, how they resolved the situation, as this has started to become "annoying".
View Replies
View Related
I am trying to connect to a Mysql database in the following manner:
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=myserver;PORT=3306;DATABASE=mydatabase; USER=myusername;PASSWORD=mypassword;OPTION=3;"
however I am getting an error:
visual basic run-time error microsoft [odbc driver manager] data source name not found and no default driver specified.
View Replies
View Related
How do you add data to the tables from asp website using C# (for mysql)
View Replies
View Related
Our website is currently developed in ASP/Mysql 4.
The dedicated servers on which it is currently hosted arrive at saturation.
Here is their configuration:
- 1 server PIV 2,8Ghz 1GB RAM with IIS 5 on Windows 2000
- 1 server Bi-xeon 3Ghz, 512 MB with MySQL 4 on Windows 2003
The website makes approximately 10.000.000 of pages seen and 310.000
visits each month (given by an external statistics tool), increasing by
10% each month.
The database is approximately 60 MB.
I made, I think, most of the optimizations on the database (cache,
indexes...).
According to our current web hoster, this saturation is due to a bad
management of connections between ASP and MySQL and recommends to us:
1/ to put the site on Windows 2003/IIS 6.
2/ to change our database from MySQL to SQL Server.
3/ to change our PIV to a second Bi-xeon.
View Replies
View Related
er...i dont know if this belongs in here, so apologies if it shouldnt...
Im working on a programme in VB6 that allows people to add news to my site. I was just wondering how can you connect to MySQL with VB and how can you add records
View Replies
View Related
i need to compare against the database if the user input the correct username and password otherwise to send the user to another page.. but still lets sign in even if the username and password does not match.. here's an example of my code:
View Replies
View Related
I was having trouble with access because it was far too slow and the site kept crashing as too many people were accessing the database at the same time (servers errors because of the lock file kept cropping up).
So, I converted the Access Database to mySQL, used the connection string:
Conn.Open "DRIVER={MySQL ODBC 3.51 Driver};database=dhsweb;server=localhost;uid=root;password=chadwick;option=3;"
And it connects ok. However, I get the following error on the main page: Code:
View Replies
View Related
How can i make ASP read a table and view its content from mysql ?
any xamples or a site i can refer to ?
1 more thing .. how to view the Database entries as URL or Links ?
View Replies
View Related