Solved

SQL connection using VB and DSN

Posted on 1998-02-17
1
197 Views
Last Modified: 2011-09-20
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
Comment
Question by:ny971181
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
cymbolic earned 0 total points
ID: 1090315
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 56
Display SQL maintenance plan SQL Code 3 44
Call to SQL server times out 5 50
semaphore timeout period has expired 1 23
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question