473,402 Members | 2,050 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,402 software developers and data experts.

System Resources Exceeded ?

55
Hello !

At times I get an error i.e. "System Resources Exceeded" and then the database (.dbf) stops responding. I have to start system to make it work again. I searched on the internet regarding this problem and found that it could be related to the connection spooling or bad coding practices. Could anyone please check my code below n lemme know if i m using doing the rite thing with the connection...

<Code removed>

Thanks & regards,
Jan 9 '08 #1
4 2245
kenobewan
4,871 Expert 4TB
The coding practices usually refers to keeping the connection open longer then necessary. Try closing the connection around line 50. However, optimizing your database performance can be more important. HTH.
Jan 9 '08 #2
hash4sp
55
The coding practices usually refers to keeping the connection open longer then necessary. Try closing the connection around line 50. However, optimizing your database performance can be more important. HTH.
Hi kenobewan !

According to your suggestion I did closed the connection at the specified line no., but still the problem exists. The database stops responding once evey week & then I restart the system. Definitely there might be some proper solution to this problem What do u mean by optimizing database performance. I am using the .dbf from the shapefiles.

Will be thankful for ur suggestions.

Kind regards,
Hash
Feb 16 '08 #3
hash4sp
55
How do i remove the code which i pasted in the first post above???
Feb 26 '08 #4
r035198x
13,262 8TB
How do i remove the code which i pasted in the first post above???
You can edit the post if the edit time has not expired.
If you can no longer edit the post then send me a PM and I'll do it for you.
Feb 26 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Roberto Ortolano | last post by:
Hello one of our servers (win2k adv server, IIS5, MDAC 2.8, full patched), once a day in the afternoon starts giving this error on every site that uses asp: Microsoft OLE DB Provider for ODBC...
2
by: mark | r | last post by:
Microsoft JET Database Engine error '80004005' System resource exceeded. /webutils/include_webstats_weeklycount.asp, line 23 Anyone know what this means and how to fix it. Mark
1
by: aj | last post by:
DB2 WSE 8.1 FP 5 Red Hat Linux AS 2.1 (LUW) I am having ongoing issues w/ FMP processes in my DB2 server, and thought I would ask for opinions. My dbm cfg KEEPFENCED is set to YES, and I use...
1
by: Manuel Lopez | last post by:
I get a run-time error 3035 ("system resources exceeded") running DAO code in XP x64 that works fine under 32-bit XP. It updates 405,000 records. Dim dbs as DAO.Database If dbs=Nothing Then Set...
1
by: mattias192 | last post by:
I cannot make sense of the ODBC error messages my VBA application throws at me. I connect to an Access database of about 500MB in size. First, there is the "Not enough space on temporary disk"....
6
by: chengsi | last post by:
Hi guys, I get the "System Resource Exceeded" error when I run a report, but the query which it is based on runs ok (take about 1.5 mins to run tho). Anyone have any suggestions on how to avoid...
3
by: forest demon | last post by:
for example, let's say I do something like, System.Diagnostics.Process.Start("notepad.exe","sample.txt"); if the user does a SaveAs (in notepad), how can i capture the path that the user...
23
by: Rogiecrockett | last post by:
I am new to this site. I have searched and found similar posts but don't think they are answering my question. I have a basic and simple DB. 4,170,000 records each record being 6 fields. File...
2
by: Jx4 | last post by:
Hi, I'm working a database that uses a lot of queries. I need to calculate different interest rates each month and different transactions. Everything is working for the first 4 months fine, but when...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
marktang
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,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.