473,320 Members | 1,977 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,320 software developers and data experts.

Network is Busy Error

Hi All,

Im running a ASP & Access DB application that im developing off my local
Windows 2000 Pro machine (i.e. not server)

Im starting to hit loads of "The Network is Busy" errors when i do a few DB
updates in succession. Does anyone know why it does this? I have a feeling
its cos MS has put some protection in Win2K Pro to stop people using it as a
server?

Any thoughts of how to stop it, since i need to to help me develop this
applications?

Thanks in advance,

Cheers

CM Barnett
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: 04/07/2003
Jul 19 '05 #1
2 2922
CM,

Are you 100 percent sure that you are are releasing your database resources
and do you have connection pooling enabled?

Dan

"news.microsoft.com" <ch*****************@hotmail.com> wrote in message
news:OF**************@TK2MSFTNGP11.phx.gbl...
Hi All,

Im running a ASP & Access DB application that im developing off my local
Windows 2000 Pro machine (i.e. not server)

Im starting to hit loads of "The Network is Busy" errors when i do a few DB updates in succession. Does anyone know why it does this? I have a feeling its cos MS has put some protection in Win2K Pro to stop people using it as a server?

Any thoughts of how to stop it, since i need to to help me develop this
applications?

Thanks in advance,

Cheers

CM Barnett
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: 04/07/2003

Jul 19 '05 #2
In the control panel under administrative tools there is an applet for "Data
Sources (ODBC)" you will see a tab for connection pooling. Select the
access driver and double click then enable pooling by selecting "Pool
Connection to this driver"

BTW, is that really the only code you are using to access your DB? In
general make sure you are completing all transactions, closing and setting
to nothing all recordset, connections and commands.

Dan
"news.microsoft.com" <ch*****************@hotmail.com> wrote in message
news:es**************@TK2MSFTNGP11.phx.gbl...
Im pretty sure i am, this is the code im calling:

Set objComm = CreateObject("ADODB.Command")
objComm.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="&Server.MapPath("mydb.mdb")
objComm.CommandText = updateSQL
objComm.Execute intNoOfRecords
Set objComm = Nothing

How do i enable connection pooling?

Cheers for the speedy response!

Chris

"solex" <so***@nowhere.com> wrote in message
news:Oj**************@TK2MSFTNGP11.phx.gbl...
CM,

Are you 100 percent sure that you are are releasing your database resources
and do you have connection pooling enabled?

Dan

"news.microsoft.com" <ch*****************@hotmail.com> wrote in message
news:OF**************@TK2MSFTNGP11.phx.gbl...
Hi All,

Im running a ASP & Access DB application that im developing off my local Windows 2000 Pro machine (i.e. not server)

Im starting to hit loads of "The Network is Busy" errors when i do a few
DB
updates in succession. Does anyone know why it does this? I have a

feeling
its cos MS has put some protection in Win2K Pro to stop people using

it as
a
server?

Any thoughts of how to stop it, since i need to to help me develop

this applications?

Thanks in advance,

Cheers

CM Barnett
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: 04/07/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: 04/07/2003

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bernd Bugomir | last post by:
Hi out there, our Webserver stops working with 'HTTP Error 500-13 - Server too busy'. The Server has at this time over 3000 connections, but the Server isn't busy at all. (The IIS runs with...
1
by: QQ | last post by:
Hello I am a beginner for network programming. Now I am trying to implement some function like this I am keep listening to a port, when I get some message, I will have some corresponding...
3
by: Raymond | last post by:
Dear all, We ran into very strange situation recently with our ASP.Net applications running on Windows 2003 servers. After running for a couple of days, the .Net application begin to reject...
0
by: aartinawani | last post by:
Hi I have an asp.net application running under Windows 2003 Server, IIS 6, for 2 years. Today, suddenly, the site went down at 3:38 pm and the application raised an error entitled "Server too...
0
by: roninkaiser | last post by:
Good Evening, I've a Dts in my sql server 2000 that contain 8 packages. If I fire the dts from local packages all ok If i try to fire the package step by stem I've this error: server busy-this...
31
by: damacy | last post by:
hi, there. i have a problem writing a program which can obtain ip addresses of machines running in the same local network. say, there are 4 machines present in the network; , , and and if i...
7
by: DC | last post by:
Hi, there is a 500;13 page one can configure in the website properties, but ..Net Framework 1.1 also delivers the "server too busy" message sometimes and the IIS custom error page does not seem...
7
by: Marc Bartsch | last post by:
Hi, I have a background worker in my C# app that makes a synchronous HttpWebRequest.GetResponse() call. The idea is to POST a file to a server on the internet. When I call HttpWebRequest.Abort()...
2
by: SunshineInTheRain | last post by:
I'm trying to modify a long long code within a button click by make the insert/update/delete/select using the same transaction. Purpose is to make sure every operation can be rollback instead of some...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.