Could not allocate a new object descriptor? 1

[Ruairi]

I am adding records to a table in SQL server 6.5 from a visual basic app. I just started getting a run time error returned when trying to add a row. The error description is:
"[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate a new object descriptor for required system catalog in database '6'. Another database must be closed or objects in another database dropped in order to open this database."
Does anyone know what this means? database '6' doesnt mean anything to me. Some kind of a temp DB? The visual basic code where the error is arising from is shown below. I typically have about 50 - 100 of these inserts inside a transaction, because the user needs to be able to roll back the whole thing depending on errors or warnings. This was working fine. Any help greatly appricated. TIA.

speciesrec = Val(subs.GetCode(sortsrec, cbospeciessort))
If speciesrec = allspeciesrec Then
speciesrec = defaultspeciesrec
End If
sql = "select * from loads where rec = " & loadsrec
OpenSubs.OpenRecordset rs, sql
If rs.BOF And rs.EOF Then
rs.AddNew
End If
rs("statusrec&quot = statusrec
rs("dag&quot = dag
rs("paiddag&quot = OpenSubs.NoDate
rs("paidflag&quot = subs.CheckToChar(vbUnchecked)
rs("brandname&quot = BrandName
rs("brandsrec&quot = brandsrec
rs("sortsrec&quot = sortsrec
rs("invoiceddag&quot = OpenSubs.NoDate
rs("invoicedflag&quot = subs.CheckToChar(vbUnchecked)
rs("destinationrec&quot = destinationrec
rs("vbdpricerec&quot = vbdpricerec
rs("deck&quot = ""
rs("vendorrec&quot = vendorrec
rs("vc&quot = 0
rs("vpfr&quot = 0
rs("sc&quot = 0
rs("spfr&quot = 0
rs("fallerrec&quot = nonefallerrec
rs("fc&quot = 0
rs("fpfr&quot = 0
rs("truckerrec&quot = nonetruckerrec
rs("tc&quot = 0
rs("tpfr&quot = 0
rs("hc&quot = 0
rs("cc&quot = 0
rs("cpfr&quot = 0
If blankyardticket Then
yardticket = ComSubs.GetDefaultYardticket()
End If
rs("yardticket&quot = yardticket
rs("scaleticket&quot = scaleticket
rs("weightticket&quot = weightticket
rs("supplierticket&quot = supplierticket
rs("certificate&quot = certificate
rs("othergl&quot = ""
rs("gross&quot = 0
rs("pieces&quot = 0
rs("voucher&quot = 0
rs("net&quot = 0
rs("penalty&quot = 0
rs("invoice&quot = 0
rs("utility&quot = 0
rs("averagelength&quot = 0
rs("mtflag&quot = subs.CheckToChar(mtflag)
rs("weight&quot = weight
rs("averagediameter&quot = 0
If weight > 0 Then
rs("weighedflag&quot = subs.CheckToChar(vbChecked)
Else
rs("weighedflag&quot = subs.CheckToChar(vbUnchecked)
End If
rs("customerrec&quot = nonevendorrec
rs("enet&quot = 0
rs("eutility&quot = 0
rs("pgross&quot = 0
rs("subst&quot = 0
rs("scu&quot = 0
rs("scun&quot = 0
rs("xp&quot = 0
rs("mism&quot = 0
rs("cu&quot = 0
rs("hbamount&quot = 0
rs("adamount&quot = 0
rs("udamount&quot = 0
rs("hbdag&quot = OpenSubs.NoDate
rs("uddag&quot = OpenSubs.NoDate
rs("transferflag&quot = ""
rs("sequence&quot = 0
rs("bureaurec&quot = bureaurec
rs("glcode&quot = glcode ' "" added 2/9/2001
rs("speciesrec&quot = speciesrec
rs("cutdag&quot = OpenSubs.NoDate
rs("processdag&quot = subs.FormatDate(subs.FormatShortDateText(Now))
rs("samplescaledflag&quot = subs.CheckToChar(vbUnchecked)
rs("scaletyperec&quot = enuScaleFlag.BureauScaled
rs("loggerrec&quot = loggerrec 'added 10/23/00 logger rec added to load file
rs("cdatabaserec&quot = OpenSubs.Cdatabaserec
rs("ddatabaserec&quot = OpenSubs.Ddatabaserec
'On Error GoTo cancel_AddLoad '**** removed for debugging, put it back
rs.Update 'error occurs here
Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com

 

[tlbroadbent]

Execute sp_configure and look at Open Objects and Open Datasbases settings. You can increase the number of open objects and open databases and see if that eliminates the problem. Don't increase them too much because open objects use memory.

I believe you'll need to restart SQL Server after changing the options.

You can use Performance Monitor to check the current number of Open Objects and Open Databases. Terry

http://members.home.net/tlbroadbent/index.htm

 

[Ruairi]

Terry,
That was the problem. Open Objects was set to 500. I changed the setting to 1500 and that took care of the problem. Thank you for your fast response. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com