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