SQL Connection Troubles
-
Hi, I'm using VC++ to connect to a SQL Server. At first there was no problem. But the program has grown and there are now 13 threads accessing the database. Some too retrieve the data they need, while others put there data in it. My question is the following: What is the best way to let this work? a. use a single connection by all threads. b. let every thread make its own connection. c. some other solution ... Can solution (a) give problems when using the same connection pointer in multiple threads. Solution (b) seems logical but further investigation showed that u must make sure that there are enough concurrent user session on the SQL server. But does that mean that you need 13 CAL's or can you use a single CAL for the whole applications. I can't seem to find any answer to that question? Thanks in advance Kurt Pattyn
codito ergo sum