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
27 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
6 Comments
 
LVL 6

Accepted Solution

by:
Pedro Gama earned 250 total points
Comment Utility
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 68

Assisted Solution

by:Qlemo
Qlemo earned 250 total points
Comment Utility
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
Comment Utility
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 68

Expert Comment

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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
IIS 7.5 to 8.0 6 68
Complex SQL 10 32
SQL Server 2016 Developers Edition Install 4 55
Windows 2012 R2 PCA card driver 4 5
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now