Connection failed: Too many connections to the database

Posted on 2003-03-28
Medium Priority
Last Modified: 2008-02-01
I'm running a windows 2000 server with 5 CAL and the sybase adaptive server anywhere 6.0

during setup, I chose the per network seat license. but when i try to connect to the database, it only allows one user at a time.

I have another PC running windows NT and the sybase adaptive server anywhere 6.0 but this setup allows the database to be used by several users at the same time.

If possible, I prefer to use the windows 2000 as the my server to run my database.

Can someone please explain/tell me what should i do.
Question by:Sandy Kalugdan
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

Accepted Solution

DaniPro earned 500 total points
ID: 8237025
You can try to use "dblic" command-line utility that allow you to change the number of user license but i think than on Win 2000 O.S. this ASA 6.0 utilities non work.
Otherwise you can reinstall the server!

dblic { switches } executable-name user-name company-name
-l type = License type. Allowed values are perseat or concurrent
-o filename = Log output messages to a file
-p operating-system = Target operating system. Allowed values are NetWare, UNIX, WIN32, WINNT
-q = Operate quietly—do not print messages
-u license-number = Total number of users for license
dblic -l concurrent -p WINNT -u 50 dbsrv6.exe "Sys Admin" "My Con"

Expert Comment

ID: 8239515
It makes a difference whether you're starting the database with the dbsrv or dbeng commands.  dbeng is limited to five connections, regardless of licence limits.  dbsrv uses the licensing information to determine the number of allowed connections.  The OS used is irrelevant to this issue.

If you are actually exceeding the number of licenses you've bought, you might as well get the number you actually need.  Extra licenses are incredibly cheap.


Expert Comment

ID: 8799707
DaniPro is right this one is almost certainly because you need to run dblic

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

The top devops trends for 2017 are focused on improved deployment frequency, decreased lead time for change and decreased MTTR.
"Any files you do not have backed up in at least two [other] places are files you do not care about."
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 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