Multiple Calls With Inet Object Causes Site To Lock Up
I developed a website that posts data to another url via the Inet object.
I should mention that the posting code is wrapped in a VB 6 dll, and that
dll is called from ASP. Code:
I developed a website that posts data to another url via the Inet object.
I should mention that the posting code is wrapped in a VB 6 dll, and that
dll is called from ASP. Code:
set inet = createobject("InetCtls.Inet")
inet.requesttimeout=20
inet.url = "http://www.lorddog.com"
s = Inet.OpenURL
I found this code a site.but it doesn't work.I get "Class is not licensed for use "who knows how to use inet with asp ?
I want to create some pages using .net, and have others using regular asp with vb. Just wondering? I know you can have Java within the same pages, but didn't know if using asp, and then wanted to do some .net things if the site would have problems.
View Replies View RelatedI've got three small photos integrated into the top bar of my web site. I'm searching for a way to rotate these three photos every time a new link is selected or the page is refreshed (the same top bar is on every page).
My ASP skills are a bit weak, so I was wondering if anyone had done something like this before (using include files or a basic Access database).? I've done this at work using ColdFusion & Access, but unfortunately I don't have CF on my lowly home web server (just ASP). I've searched all of the free-script web sites, but can only find banner ad rotators that hyperlink images.
The object I have is a barcode:
<%
RMABarCode = Session("rmaID")
IF Len(RMABarCode) Then
response.write "<img src='barcode.asp?code=" & RMABarCode &
"&height=25&width=1&mode=code39'>"
End If
%>
But I need to be able to display that barcode multiple times.
Say the user needs 4 displayed, he/she will enter the number and it
shows that many.
Im trying to detect multiple logins...
Im using a application object in my global.asa, for some reason it doesnt seem to work. here is my code
<script language="vbscript" runat="server">
Sub Session_OnStart
Session("LoggedIn")=0
End Sub
sub Application_OnStart()
Application("Logged")=1
End sub
</script>
In my pages if i print the Application("Logged") value, it does not show....
I have implemented a logic for my requirement with a recursive call. The logic is I need to get IDs from database for a scenario. There are corresponding records for each ID.
I need to store these IDs in an array variable. Then I need to get (dependent)IDs for the fields in each ID. There may be morethan one dependent per each ID. I append these IDs to my array. Like this it goes.
The problem is if there are many levels like this, the number of database cursor count is reaching to maximum and I'm getting the error
{Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded }
each recursive call runs a SELECT query.
Can any one suggest me an alternate solution for this ?
I'm terribly sorry if this has been asked before, but I need a clear explenation without having to sift through other bits of information.
Can somone explain how functions work in asp (not asp.net)? I need to call a function that returns a value, and I get an error when I have a return statement in there. If there is no "return" statement, then what do you use to get this value back?
I am using WindowsXP and a book to try to learn ASP.
The book instructed me to install IIS & .Net Framework v1.1 (which I did)
In the book they gave me the following code:
I'm very interested in finding out what ways you experts out there have made your data dips more efficient in your asp (not asp.net) code.
I have a wizard-type application that dips into the database with each page, I know there's a better way to do this out there, just pressed for time and can't think right now.
I need to implement an application that receives http calls from a remote
client, do something with it and returns some feedback. I want to use IIS
(version 6) as my front end http server (with https and ssl services) which
will facilitate all the requirements of a http server and then foreword the
incoming call to my application and will return the process result to the
client at the end.
Does IIS support this? And if yes - what are the requirement from my application to use it (built in .net if anyone interested)?
Is there a way I can see how many database calls were made from my script to the db server to check how well my SQL queries are formed?
I get the time taken to execute the queries, but in that time taken, I want to know how many calls were made to the DB server. Is it possible?
..:: The Specs:
MS Access 2000 (host charges extra for SQL/MySQL)
MS Windows Server 2003 (prod) / MS XP SP1 (dev)
..:: The setup:
The database has been setup with two tables;
tblDownloads
tblCatagories
Each "download" consists of a catagory field that corresponds to fldID in
tblCatagories. Each catagory, where the catagory is a parent, has a parent
field of value: 0 and each child, has a field with a value corresponding to
the fldID of it's parent. Code:
I'm developing web surveys where users logon to a web survey and answer up
to about 50 questions, one after the other, shown only one question at a
time. The answers are saved in a database.
A fellow developer and I are discussing when is the best time to save the
answers. We have two approaches in mind:
Approach 1:
After each question is answered, the answer is saved in the database.
Sessions are only used to store the User ID.
Approach 2:
After each question is answered, the answer is saved in a session variable.
When the user has finished the entire survey, all the answers are saved at
once in the database. Also, if the user logs out, or if the session times
out, the answers answered so far are all saved in the database at once.
The amount of actual data sent to the database is the same in both
approaches, but Approach 1 have much more frequent calls to the DB, thus
creating an overhead of opening and closing connections. I'm not sure how
significant that is. On the oter hand, Approach 2 store a lot of data in
sessions. I'm not sure how bad a thing that is.
Which approach is better and for what reasons? I'd be happy to supply more
information if needed.
I am looking for a tool/product (commerical or shareware) to correlate
classic ASP pages (not ASP.NET) with timings of ADO calls made from
each ASP page. The information I am looking for are
T1, url = http://..../product.asp,
DB Server=SQLSvr1, DB Name=products
ADODB.Connection.Open 10ms
ADODB.Recordset.Open 189ms
...
T2, url = http://.../search.asp,
DB Server=SQLSvr2, DB Name=productindex
ADODB.Connection.Open 15ms
ADODB.Connection.Execute 350ms
...
It would be nice if the tool can automatically rewrite existing ASP
pages if necessary.
This would be a good performance monitoring tool for classic ASP
pages.
I'm using the following function, which uses a recursive call. every time when I get a conf it opens a record set. So increases the cusor count. Some times I'm getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded.
How can I avoid this ? Code:
Any body know of a resource that compares/benchmarks the expense (in terms of milli seconds, or server load) of using various programing options?
I know a lot of articles and forum posts reccomend best practices between functions and programming options, but I would be interested in some type of definitive benchmark to decide between various prgramming options, depending on the need.
For example, I can call a Recordset and quickly write it into an array, so that the connection can be closed even before I write the data to the HTML page. This would save conection time and server resources, but I'd like to be able to judge the worth when considering coding it.
Every time I do a Server.Transfer how expensive is it to the server? How much am I loading the server with Session varaibles? If I store some info in a cookie, but have to call it, how long will that take? Am I using up server resources by creating large arrays?
I have a site that I need to distribute to various locations around the country. Each of these sites has they're own developers so I want to lock the code to prevent them from seeing it. Is there anything I can do?
View Replies View Relatedwhat I need to do is the following:-
1) Open a table to insert a new record
2) Lock this table so there is no new entries in it
3) get the maximum call number and add 1 to it
4) insert the new record
5) Unlock the table again.
How can i do it? I know how to insert the record and get the maximum call number. What i do not know is how to lock and unlock the table.
I have a web site that I need to distribute to different sites around the country. Problem is each site has its own developers and I dont want to allow them access to the code, is there anything I can do to lock them out?
View Replies View RelatedI am working on a redesign of an old site and have come across a situation where I will need to use Application variables. Recently I have heard that using Application.Lock() and Application.Unlock() on a Windows 2000 server offers no real benefit.Here's my question: Is what I just said true? If so, is there a performance hit when using the Lock and Unlock methods on a Windows 2000 server?
View Replies View RelatedHow to lock table while inserting a new record in table? My site has multiple users. Every user can insert new value in table. But when a user inserts a new value he should be able to see previous max value from the table. So I want to lock table while inserting new value. How to do that? Will table locking work or have to do something else?
View Replies View Relatedwhat I need to do is the following:-
1) Open a table to insert a new record
2) Lock this table so there is no new entries in it
3) get the maximum call number and add 1 to it
4) insert the new record
5) Unlock the table again.
How can i do it? I know how to insert the record and get the maximum call number. What i do not know is how to lock and unlock the table.
I have a single asp page that interacts with the client via the post method. Four arrays are created and passed back to the client when the form is submitted.
Question, when the form is being processed server side, should I be locking and unlocking aplication variables and arrays? or can I declare ordinary variables and arrays because its a single page? will ordinary variables get changed by multiple clients on a single page? Im confused what has to be locked down! and what does not.
Is there any way to get a file lock in ASP so that no one else can write to file at that particular time and when I call releaseLock, the lock will be released? I would appreciate any help in this regard.
View Replies View Relatedi m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record. That can person at site B cannot use record until lock or cursor is released.
View Replies View RelatedHow can i lock a textbox in a form !?
so no body can change its value
<input type="text" name="adddate" size="20" value=<%response.write(date())%>>
<input type="text" name="name" size="20" value=Killerpm>
how to lock down a text field so that data displayed within it cannot be altered?
View Replies View RelatedI am using Application.lock to protect a reference to a COM+ object while calling Server.Execute() to another ASP page. I am doing this to pass the object's reference to the other page, and I CAN'T rely on the session object.
Is this a safe way to protect the object reference? i.e. does the Application object remain locked when calling Server.Execute()? .....
i m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record .That can person at site B cannot use record until lock or cursor is released.
View Replies View RelatedI would like to create an auto-lock out module where users are unable to continue login attempt after 3-5 unsuccessful logins. In addition, the user account are automatically suspended after stipulated unsuccessful logins. Is there any sample coding in ASP or Javascript for me to refer to??
View Replies View Related1. How do I create my asp in a way where it does not allow the user to key in wrong password for more than 3 time. It will lock the account once three times has exceeded.
View Replies View RelatedI have signature part in my page (which include signature,name and date). This signature part should be lock together. Let say if the information in the page is about 2 pages, automatically the signature part will be in the 2nd page.
But the problem is, the signature on the 1st page while the name and date on the 2nd page. Is there a way to move the signature to the 2nd page? I've tried make it as a footer and include in the end of the page but doesn't work. Any idea?