Solved

SQL connection using VB and DSN

Posted on 1998-02-17
1
198 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

691 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