?
Solved

How many ODBC 32 bit or 64 bit connectors can there be on a Windows 2012 R2 Server?

Posted on 2014-12-30
6
Medium Priority
?
34 Views
Last Modified: 2016-06-12
I have a customer with an application the requires access to SQL databases via an ODBC connector.  But, the way their databases and application design works, there is a separate database for each customer and seemingly require a separate ODBC connector for each one (without getting too deep into what the application does and why it would require this).  My question is, is there a limit to how many ODBC connectors there are on a server?

Thank you!
0
Comment
Question by:ehouser_paralleltech
[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
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
Pedro Gama earned 1000 total points
ID: 40523731
Hello! I've never had a problem with such limits. You can create as connections as you need under system dsn. But if different users will be accessing different DBs i would suggest creating the ODBC connection under User DSN for each user.

Hope it helps
PG
0
 
LVL 70

Assisted Solution

by:Qlemo
Qlemo earned 1000 total points
ID: 40523931
I don't know of any limit either, and why there should be any. The DSNs are stored as registry values. There might be a limit for open connections, but not for DSNs.

If you are not forced to use DSNs (which depends on how the application uses the connection info provided), you can try with DSN-less connections (see www,connectionstrings.com for examples). That way you do not need to set up DSNs.
0
 

Author Comment

by:ehouser_paralleltech
ID: 40523940
Basically, this is a telephony IVR application that, each customer is given a specific phone number to dial.  Then, based on that, when the call comes in to the phone system, it gets routed to a script and from there, to a specific database and in the middle, the script is what routes this customer to their own database.  This is done from I am being told, for security reasons.  So, each customer having their own database needs a way to route them to this database and done so through an ODBC connector.  Even though there are only 47 at this point, as customers increase, so do connectors.  It just seems to be a hassle to manage and we just wanted to make sure this would not cause problems on the number of connectors.
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 41649859
There is no known limit, and that's what we told.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A procedure for exporting installed hotfix details of remote computers using powershell
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
Suggested Courses

762 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