🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #496

MIDAS problem.

#496
From: Martin V�ronneau
Date: Mon, 10 Sep 2001 14:04
21 lines
1860 bytes
Hi, all!

I'm new in multi-tier database development, but I have a solid backgound in
desktop database dev.

I tried to develop a database server using MIDAS, and it works pretty fine.
I can send query to the server, and it returns me the dataset.

The trouble is that when I have more than seven or eight clients
applications connected to the server, and that each one has an open dataset
tied to the database, the server crashes and return a :
TDBEgineError : Insufficient memory for this operation.

I assume that I'm opening to much connections to the database, but I don't
know how to solve the problem. What am I doing wrong?

My database is of Paradox type. My server uses the Apartment threaded model.
There's a TSession, TProvider and TQuery on my RemoteDataModule.

If someone could help me, and/or supply some URLs where I could learn more
about MIDAS with BCB 5.
Technical Details
Message-ID: <3b9cc88e$1_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!btnet-peer1!btnet!newsfeeds.belnet.be!news.belnet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,28651359d2dc3678,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-09-10 07:11:17 PST
Reply-To: "Martin V�ronneau" <martin.veronneau@deuteron.net>
From: "Martin V�ronneau" <martin.veronneau@deuteron.net>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: MIDAS problem.
Date: Mon, 10 Sep 2001 10:04:37 -0400
Lines: 23
Organization: deuteron acquisition
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: 24.226.158.26
Message-ID: <3b9cc88e$1_2@dnews>
X-Trace: dnews 1000130702 24.226.158.26 (10 Sep 2001 07:05:02 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!btnet-peer1!btnet!newsfeeds.belnet.be!news.belnet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews