Is there a way to detect open recordset and connection objects easily? I have hundreds of pages of code making up this web application I wrote and I want to make sure I didn't leave any loose ends. Short of going page by page, connection by connection, I'd love to discover any issues a different way. Does anyone know of a strategy?
View Repliesin my main page i need to retreive record set from the database as well as search for products. but the recordsets i need to retrieve are located in a different table then the products i need to search. is this possible to do ?
View Replies View Relatedhow I might go about displaying all current open db connections in ASP, either for a particular web app/page or hopefully all of IIS ? We are having a few issues with IIS hanging and we feel that it is related to db connections that were opened and not closed. I would like to be able to write an ASP page that could show me the current amount of open db connections from IIS.
I need to do this from the IIS side not the SQL Server side. I can already see the number of sessions in SQL Server but I am more interested in trying to find asp pages which have opened a connection to some db and not cleaned up properly afterwards.
is there any ASP script that will display a list of all open connections on
a shared host
im trying to determine if my previous problem with "system resource
exceeded" can be resolved by brute force?
I've been cobbling together a rather complex web utility, and was wondering
if there is a way to monitor the number of data connections and open
recordsets currently being used by the server. I am using IIS5. I'm
essentially looking for a tool that would help identify sloppy code by
showing a list of currently open data connections or recordsets.
Many a page has ADO Connection objects that were opened but never closed. The Connection object allocates its own resources when it is opened. When the object goes out of scope without being explicitly closed, the resources ASP allocated for it are freed, but the resources it allocated on its own are not. These eventually clutter up the server and slow it down to a crawl.
My question is, is there a way to track down these orphaned resources and forcibly free them from ASP, without restarting IIS or the server? Or does one have to wait for the unused Connections to time out and release themselves? I know that good coding practice is best, but is there a temporary fix to tidy up these connections left open?
I have a set of scripts that accesses a SQL2000 database on another server. After several days of investigating an extreme slow-down on my web server I did a netstat-a command and found DOZENS of connections to the SQL server still open. Here's just a small sample of this. Code:
View Replies View RelatedI have a database with date of births stored dd/mm/yyyy (english dating
system) and =date() returns a date in the same format in my server.
how do i find the persons age using these two pieces of date.
I have a problem with DSNless connections. I used the code below but doesnt works.
An error message appears in browser...
<%
conn = Server.CreateObject("ADODB.connection");
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:path odatabase.mdb";
conn.Open;
......
I'm trying to make the following asp code work using a DNS-Less
connection on a windows 2000 server running IIS and ODBC 4.0 driver.
The Access database (odbc_exmp.mdb) was made using Access 2002. The
code works if I set up a DNS on the server under the ODBC drivers.
What I'm I doing wrong and what do I change the code to, to make it
work using DNS-Less connection? Code:
i want to make a program to find out and highlight a particular word on the browser using ASP and javascript.
View Replies View RelatedIs there something similar to PHP's php_info command to tell me all about the server? I need to find the actual path where the site resides.
View Replies View RelatedI need to create a new application in our test server. I am using VID for
that purpose. In order to set up the project in VID, it asks me 'which server
you want to use'. However, I do not have the name of the test server. Is
there any way to configure the name of the server here? I have full rights to
the server directory and is mapped on my machine as G drive.
Here is a function where you don't have to worry about the leap year.
You will have to still be aware of time differences between you and
the server, and correct your data before entering it into the
function. And of course time zones, yada yada ....
BUT I think that most people using this will just want to say if today
is there bday than they are their new age. Code:
How can I programatically ascertain what version of ASP my ISP has installed ?
View Replies View RelatedI need help to find percentages, because I missed out on a lot of basic math education, I need it to be real clear step by step instruction for instance how would I go about finding 24 out of 32 one step at a time?
View Replies View Relatedi know how to find the available server names, how can i find the ports?
View Replies View RelatedI am developing a hotel finder solution in Canada. When some one enters a Postal code, it should be able to display the hotels in 5 KM radius. (With nearer PIN numbers?) I am deleloping this application using ASP, and is there anyway I can such searches?
View Replies View RelatedI trying to find the memory occupied by the object in RAM, For Example:
Set ObjTest = Server.CreateObject("ADODB.RecordSet")
I need the space occupied by the ObjTest in RAM. Is it possible ?
I am trying to find total number of parts in the database for a user by using the COUNT function:
max = HelpDesk.Execute("SELECT count(PartRef) AS 'maximum' FROM MISC_PartInfo WHERE Username = '" username "'")
but when i try to output the result by:
Response.Write max("maximum")
I get the error:
Item cannot be found in the collection corresponding to the requested name or ordinal./Intranet/test/PartInfo.asp, line 82
if anyone can point me in the right direction or has code on this. i'm trying to display the number of occruances of an event during each week of a given month. basically, i'm looking for code that finds every monday of a given month.
View Replies View Relatedone cant do a straight division because if i have 20 per page and 22 records, that's two pages. best i've come up with so far is
Code:
iPageCount = fix(iNumRecords / iPageSize)
if( iNumRecords mod iPageSize > 0 )then
iPageCount = iPageCount + 1
end if
anyone managed it better? is there a function like fix that forces a round up?
How do I find the maximum value of a recordset column? I'd rather do it this way than open a new recordset with Max(column).
View Replies View RelatedRight, which do you use? If your using DSNless, then STOP! It's SLOWING down your code and making it UGLY!!
Why? Lets look...
UGLY!
Which looks better
[vbs]
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("./data/vote.mdb")
[/vbs]
or
[vbs]
"DSN=databaseStuff"
[/vbs]
Its also easier to manage and will cause less typing errors. Think about it, it makes sense!
SPEED
Everytime you run a DSNless connection inside an ASP page the connection string needs to be verified,but a DSN connection is only verified when it is created! Meaning the DSN connection is indeed faster.
I am not sure what is wrong with this code. I have tested it at home, used in on previous webpages, and with previous employers. But I am getting this error at my current employers server: Code:
View Replies View RelatedI've been using ASP.NET for a couple years now and I'm trying to fall back into ASP for a new position I've acquired...and I'm having a bit of trouble remembering. I'm running to a problem where the basic logic is as follows:
Query
Do While Not rs.EOF
Query based on value in rs
Another query based on value in rs
Loop
There is no explicit connection object, they all use the same connection string however. When I limit myself to one query within the Do/Loop, I don't have any problems. However, when I add another query in there, it bombs with: Operation is not allowed when the object is open.
I'm assuming it's referring to the connection string being reused, but why would it allow one additional connection, but not two. I can't really close this connection before needing to requery. Is there anyway around this, or am I missing something entirely?
i am maintaining a system that was developed using dream weaver. a lot of the asp ado code looks like this:
set sp_yellow = Server.CreateObject("ADODB.Command")
sp_yellow.ActiveConnection = MM_MHR_CONN_STR_STRING
sp_yellow.CommandText = "Sp_HPMSQ007_GetSystemConstants"
sp_yellow.CommandType = 4
sp_yellow.CommandTimeout = 0
sp_yellow.Prepared = true
sp_yellow.Parameters.Append
sp_yellow.CreateParameter("@RETURN_VALUE", 3, 4)
sp_yellow.Parameters.Append sp_yellow.CreateParameter("@P_NAME_TXT",
129, 1, 17, "MLSTN_YELLOW_DAYS")
set rst_yellow = sp_yellow.Execute
someone on another forum expressed that dreamweaver "tends to drive the programmer to creat implicit connections and their effect on performance".could someone explain this to me? a provide some better code? (we no longer are required to use dream weaver to develop code for the app).
I am programming a rather large site which will hopefully attract thousands of visits per day. I have been told by other people that MS access begins to struggle once it has about 15 active connections.
Since I am currently using MsAccess to test my scripts along with IIS 5.0 or whatever it is, I guess that at some stage I am going to have to convert all my stuff so that the data is in an SQLServer Database, and that the scripts can read and write to it. could anyone tell me what the transition is like. should I consider using SQL Server from the beginning or will I just have to change a few lines on each page.
On my website, I want to provide 3 pieces of statistics that will require 3 queries to my SQL database. As much as I'd like these to be live, they are part of a footer that will load each time for about 10 pages on my site. I am thinking that, although they are simple queries, it may be just too much.
What do you recommend? I could open the connection, run the query and then close it, each time. Would this be a recommend plan? Or, should I create a daily task that builds a simple text file with those query results and just pull those in each time the footer is loaded? This would not be live, but I can deal with it.
I get somthing like "Max Connection limit is reached" error msg when trying to access a page. I wonder it is got to do with winxp pro sp2 patch which only limit 10 tcp connections? Running ms access as database and IIS 5.1.
View Replies View Relatedhow to close all open database connections without referring to each connection by name across an entire server?
View Replies View RelatedI use a global.asa file to connect to SQL Databases. how would I go about connecting to multiple SQL Databases within a global.asa file?
View Replies View RelatedWhat's the proper syntax for determining if a connection is open before closing it?
View Replies View Related