• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

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
0
ny971181
Asked:
ny971181
1 Solution
 
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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now