Board index » delphi » Ms-sql(SBS) and D3 : Opening more tables

Ms-sql(SBS) and D3 : Opening more tables

I have 2 kinds of problems
    1 .when I open more than 20 tables at the same time, I don't get any
data in the DBGrid.
    2.When I try to open a certain number of tables at runtime, the
program get stuck on the opening.

I have tried to configure the server. But I always keep those problems

Any Idea ?
Thanks
Alain

 

Re:Ms-sql(SBS) and D3 : Opening more tables


You should check the number of connections which SQLserver is configured
for.
I don't know about SBS, but previously MS SQL had a default number of
connections
of 20...

regards
Petter Skjolden
pet...@intrinsic.no

Alain van den Hove wrote in message <3559AF55.9071C...@mail.dma.be>...

Quote
>I have 2 kinds of problems
>    1 .when I open more than 20 tables at the same time, I don't get any
>data in the DBGrid.
>    2.When I try to open a certain number of tables at runtime, the
>program get stuck on the opening.

>I have tried to configure the server. But I always keep those problems

>Any Idea ?
>Thanks
>Alain

Other Threads