ASP Server Calls
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:
ADVERTISEMENT
Database Calls, Server Transfers, Sessions, And Cookies
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?
Recursive Calls
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 ?
Function Calls
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?
Optimizing Asp Database Calls
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.
How To Use IIS To Redirect Http Calls?
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)?
Database Calls Made
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?
Database - Recursive Function Calls
..:: 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:
Session Storage Vs. Frequent DB Calls
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.
Correlate ASP Page With Timings Of Its DB Calls
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.
Cursor Count Problem In Recursive Calls
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:
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:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL Server Does Not Exist Or There Is No Permission
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?
Server Object Error 'ASP 0177 : 800401f3' Server.CreateObject Failed
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;
View Replies View RelatedServer Object Error 'ASP 0177 : 800401f3' Server.CreateObject Failed
I'm getting the error,
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/pdf_project/form1.asp, line 19
Invalid class string
I'm trying to submit the data in my pdf form to the web server.I've written the .asp code for it but it has been giving me this error.
How To Read An SQL Server Into A ASP Page And Then Change, Add, Delete And Write It Back To SQL Server
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.
Server.CreateObject Error: Server Object, ASP 0177 (0x800401F3), Invalid Class String
What do I need to do to enable CDONTS om my macine to make it working
I'm testing the code:
Dim objCDO
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.To = "xyz@xxxxx.com"
objCDO.From = "zyx@zzzzz.com"
objCDO.Subject = "TESST CDONTS MAIL"
objCDO.Body = "SOME TEXT TO SEND OVER"
objCDO.Send
Set objCDO = Nothing
It gives me an error after Set objCDO =
Server.CreateObject("CDONTS.NewMail")
Server object, ASP 0177 (0x800401F3)
Invalid class string
Sending Email By Using Corporate Exchange Server Instead Of Local Server
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.
P.S. I’m using Dreamweaver MX2004.
The code that sends email is shown below ....
Server.execute/response.redirect/server.transfer
Real quick, please refresh my memory which one of the following preserves the information that was posted from a form?
server.execute
server.transfer
response.redirect
I need to have a page execute if an error occurs while processing a page that a form was submitted to and have the data preserved.
HTTP 500 Internal Server Error Online Server
I have made a site in ASP and I can navigate the site fine locally. However once I get to the product page I get:
"HTTP 500 - Internal server error Internet Explorer"
Does anyone have any idea as to why this may be? ....
Server.Mappath() To Include Files For Other Domains On Same Server?
If I have multiple websites on the same server,can I use the #include directive to reference include files elsewhere on the server? I tried this -
<!--#include file="C:InetpubvhostsATRAMEMBER.COMhttpdocsheader.asp" -->
But no dice...
Combining Index Server And SQL Server Search Results
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?
External Server Pull Files From Internal Server
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:
Problem With Special Characters In Server-to-server Communications
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:
View Replies View RelatedGetting HTML Content From One Server And Saving It On Another Server
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.
Could you send your suggestions to Join Bytes!?
Copy Or Upload File From Server To Ftp Server
I want to copy or upload a file from server say some lanserver to ftp server through ftp. Is it possible.
View Replies View RelatedServer Not Serving ASP To Some Clients? Including Server Itself!
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.
Error Server.Transfer / Server.Execute ()
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?
HOWTO: Server.MapPath To A Different Server Computer
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:
View Replies View RelatedServer.createobject On Shared Win2003 Server
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: ....
Index Server & Site Server + PDFs
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 .....
View Replies View RelatedUser Registration From One Server To Another Server
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...
View Replies View RelatedTransfer Files From One Web Server To Another Web Server
How can i transfer files from one web server to another web server. Is it possible?
View Replies View Related