SQL connection using VB and DSN

hi,
I have SQL backend, VB frontend, VB coonection using ODBC (DSN). In SQL database. I have 6 tables, I have 3 users,(CL, BL, DL).
1. I know that connections to SQL are limited to 14 connection at a time. Is this true? If yes, in what condition?
2. Is it true that 1 connectino is limited to 1 table?
If CL connect to the database, It takes 6 connectin, is it right, If not, what's wrong? and DL connect to the database, It takes another 6 connections. If BL wants to connect, will I get a error msg because there are 2 connections left?
How can I solve this kind of problem?

Thank you and have a nice day!

sorry, I got only 5 points left.

Chris
LVL 1
ny971181Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cymbolicCommented:
SQL server is licensed by number of connections.  That is you are limited to the number of active connections you have open simultaneously.  The maximum number is determined by how many licenses you purchased.  A single program can have more than one connection open at once, and in fact, using the Microsoft Access methods, you sometimes need more than one connection to get acceptable performance from the server and to avoid locking problems - neat deal for Microsoft, wouldn't you say?)

Connections are not limited to a single table.  Generally, you will see a connection to a single database that acesses many tables in a database application.

Really, the number of connections is determined by how they wrote the program, and to a lesser extent, how the database(s) are configured on your server (if you normalize the data aggressively so it's spread out in many tables on multiple databases, you may force your applications to open multiple connections to get their jobs done)

You can either buy more licenses, or find your programmers and give them an attitude adjustment (perhaps they can pay on a monthly basis for the additional connection licenses their wasteful programming practices are causing you to buy)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.