Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing database blocks other users

Status
Not open for further replies.
riksweeney

riksweeney

Programmer
Nov 4, 2002
17
GB
If a user runs a query that takes a long time no other user can run a query until the first one returns. Is there something I need to do in SilverStream's setup to allow more than one user to access the database at a time?

Thanks

Richard Sweeney
 
Sort by date Sort by votes
What are your database settings?
If you have set too small a number of allowed database connections either in Silverstream (check the SMC) or the database engine itself clients may have to wait for connections to be freed before they can use them.

Another possibility might be that you have set the class performing the query to be static in which case only one client at a time can use it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kzhao2000
  • Locked
  • Question
Database relationship not showing
Replies
1
Views
197
kzhao2000
kzhao2000
liuyude
  • Locked
  • Question
after restore to a new database, how to add it in sliverstream?
Replies
1
Views
193
jwenting
jwenting
nikkos
  • Locked
  • Question
accessing HTML controls from SilverStream
Replies
2
Views
185
Guest_imported
Guest_imported
beryx
  • Locked
  • Question
Removing a non-existent database 1
Replies
2
Views
171
beryx
beryx
Rajesh1974
  • Locked
  • Question
Getting the Handle to a database from an ordinary class
Replies
1
Views
202
Viper0313
Viper0313

Part and Inventory Search

Sponsor

Back
Top