I believe it's optimized for *5* or less.
>>How many simultaneous connections can you have with MSDE? Do I need a full blown SS7 to test with multiple connections?
>
>MSDE is optimized for 15 or less. After that, performance really takes a nose dive.
>
>>
>>I'm testing an app I developed with MSDE that will be upgraded to SS7 when it goes into production. When I run only one instance everything is fine, if I try to run a second, it waits for the first to be released, then it runs. This applies to 2 instances running on the same machine.
>
>How are you connecting to it?
>
>>
>>Using 2 machines, I can get 2 instances to start up, but once one has run a query, the second will fail returning ODBC errors from all stored procedures. In case it matters, all inserts, updates and deletes are driven by stored procedures.
>>
>>Thanx,
>>Charlie
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05