Can anyone give me some sugguestions here.
Connection is declared at the start of the application
Set rsFZReport.ActiveConnection = conn
Then a function repeatly opens recordsets like this -
rsFZReport.Open sRS, , adOpenStatic, adLockReadOnly, adCmdText
..
..
reporting code etc
...
If rsFZReport.State > 0 Then
rsFZReport.Close
Set rsFZReport= Nothing
endif
Using VB Watch debugger, the close and set nothing do NOT release any
memory. It just keeps increasing. The application connects to multiple
databases and many tables, so its uses about 10Mb/minute.
(I don't think its of relavance but Form.show uses memory but form.unload
doesn't release any back)
I've installed SP3a and MDAC 2.8 to no avail. Anyone have any ideas or know
what I can do?
msado27.tlb 2.80.1022.0
MSSQL Server SP3a (3 has a memory leak apparently)
VB6, SP6
Sqlsrv32.dll caused a leak on NT4 SP6, but upgrading it on my win2k SP4
server/workstation (they are both and the same) to this
Sqlsrv32.dll 2000.85.1022.0
doesn't help.
Provider=SQLOLEDB;Data Source=theServer;Initial Catalog=theDB;User
ID=uid;Password=thepwd;OPTION=3;connect timeout=240; 5 3457
pete (pe**@madpete.freeserve.co.uk) writes: Can anyone give me some sugguestions here. Connection is declared at the start of the application Set rsFZReport.ActiveConnection = conn
Then a function repeatly opens recordsets like this -
rsFZReport.Open sRS, , adOpenStatic, adLockReadOnly, adCmdText .
. reporting code etc ..
If rsFZReport.State > 0 Then rsFZReport.Close Set rsFZReport= Nothing endif
Using VB Watch debugger, the close and set nothing do NOT release any memory. It just keeps increasing. The application connects to multiple databases and many tables, so its uses about 10Mb/minute.
I don't have any experience of tracing memory leaks in Visual Basic,
but I suspect that there is a wee bit too little of information to say
anything.
MSSQL Server SP3a (3 has a memory leak apparently)
Yes, there was a memory leak in ODBC in SP3, but you are using SQLOLEDB,
so that you should not bother you.
VB6, SP6 Sqlsrv32.dll caused a leak on NT4 SP6, but upgrading it on my win2k SP4 server/workstation (they are both and the same) to this Sqlsrv32.dll 2000.85.1022.0 doesn't help.
Sqlsrv32.dll is ODBC, so again it should not bother you.
Provider=SQLOLEDB;Data Source=theServer;Initial Catalog=theDB;User ID=uid;Password=thepwd;OPTION=3;connect timeout=240;
OPTION=3 strikes me as unusual. What does it do?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"> OPTION=3 strikes me as unusual. What does it do?
-- Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
It was recommended by someone to overcome a problem with varchars not
returning variable length fields. The records are large and the were being
cut off., (only the first few thousand characters returned for a field)
fields were not being returned complete. I havn't actually found any
documentation on this, but it seemed to fix the problem
pete (pe**@madpete.freeserve.co.uk) writes: OPTION=3 strikes me as unusual. What does it do?
It was recommended by someone to overcome a problem with varchars not returning variable length fields. The records are large and the were being cut off., (only the first few thousand characters returned for a field) fields were not being returned complete. I havn't actually found any documentation on this, but it seemed to fix the problem
I can't find this in the docs either. And I have never heard any problems
with varchar(8000) being truncated.
What happens if you take it out with regards to the memory leak?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1... pete (pe**@madpete.freeserve.co.uk) writes: OPTION=3 strikes me as unusual. What does it do?
It was recommended by someone to overcome a problem with varchars not returning variable length fields. The records are large and the were
being cut off., (only the first few thousand characters returned for a field) fields were not being returned complete. I havn't actually found any documentation on this, but it seemed to fix the problem
I can't find this in the docs either. And I have never heard any problems with varchar(8000) being truncated.
What happens if you take it out with regards to the memory leak
I didn't make a differnce, but this was the problem
Global rsFZReport as new ADODB.recordset
Which is dumb.
And so is OPTION=3 . I can't find the explanation for it now. I've searched
the MSDN and the web. It might simply be wrong, its used for MySQL though.
pete (pe**@madpete.freeserve.co.uk) writes: I didn't make a differnce, but this was the problem
Global rsFZReport as new ADODB.recordset Which is dumb.
We all do dumb things from time to time.
And so is OPTION=3 . I can't find the explanation for it now. I've searched the MSDN and the web. It might simply be wrong, its used for MySQL though.
So I would conclude that Option is specific to the MySQL provider.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jack Smith |
last post by:
I am unable to connect to certain SQL servers from PHP on IIS.
I have two IIS 5 servers, both are Windows 2000 Server boxes with PHP
4.3.4 and MDAC 2.80.1022.3. I have three SQL Server machines...
|
by: scott_mcarthur2003 |
last post by:
We are running asp (not asp.net) and vb com dll web sites on a machine
which also has sql server 2000 sp3a running and uses Windows Server
2003. We recently migrated from Windows 2000 (same...
|
by: John C |
last post by:
Had an error message appear quite suddenly Friday
evening/Saturday morning without any updating of our ASP
application. Here is the technical setup
W2K Adv IIS5 server, ~ 400 sites, dual 1ghz,...
|
by: Newbie |
last post by:
We have a web application in AS. It also uses COM+ and SQL Server as
back-end.
Sometimes the size of the dllhost.exe grows unexpectedly. It is such that we
restart our IIS/ PWS. Also there is...
|
by: ErickR |
last post by:
We are experiencing a problem with Sql Server 2000 linking to an
Access 97 file. We have two machines that link to this .mdb file, and
we recently upgraded one to newer hardware, SP3a, MDAC 2.8,...
|
by: Thue Tuxen Sørensen |
last post by:
Hi everybody !
I´m maintaining a large intranet (approx 10000 concurrent users) running on
one IIS box and one DB box with sqlserver 2000.
Currently there is 2,5 GB Ram, 1 1400 mhz cpu and 2...
|
by: M. Oakley |
last post by:
We are using ODBC connection pooling with SQL Server 2000 v5 on Win 2000 v5
sp4.
Each time we get a connection, SQLConnect, we see the memory usage go
up, about 52K. When we return the...
|
by: Andrzej |
last post by:
Used to read newsgroup for answers, now have to ask for them as well.
I have an application (C#, .NET 1.1) that connects to local db on MSDE
2000 SP3a (using ADO from MDAC 2.71) on one side and...
|
by: Shane Suebsahakarn |
last post by:
Hi all,
This might be one of those things for which there is no workaround. I'm
using A2K2, and using it to perform a very large batch ouput. Both the front
and back ends are MDB files, so no...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| | |