Improve company productivity with a Business Account.Sign Up

x
?
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
?
42 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
  • 2
4 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 72

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 72

Expert Comment

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

606 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