SQLDataset: can't create new thread

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Pascal and Delphi section within the Software Development category of DaniWeb, a massive community of 375,199 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,071 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Pascal and Delphi advertiser:

Thread Tools Display Modes

Views: 376 | Replies: 0

•

Join Date: Nov 2007

Posts: 22

Reputation: ecostas is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

ecostas

Offline

Newbie Poster

SQLDataset: can't create new thread

May 6th, 2008

Hi. I'm still learning how to use dbExpress, after using Zeos and Delphi 5 for many years. I wrote a small program to import data from a MySQL database to another MySQL database totally different in terms of layout. It worked all right, though I'm afraid some of my clients may have tables with tens of thousands of records and it may become slow or the system resources may be depleted. I tried to use TSQLDataset instead of the trio (TSQLDataset, TDatasetProvider and TClientDataset) but with only 82 iterations and 2 inserts per iteration I get a " can't create a new thread (errno 12)...". My computer has 2GB of RAM and I'm using Delphi 2007 Professional with MySQL 5.0.45. What am I doing wrong? Is it worth to bypass TClientdataset?

Thanks in advance.

Eduardo