[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL connection using VB and DSN

Posted on 1998-02-17
1
Medium Priority
?
200 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

656 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