1. David Downes
  2. PowerBuilder
  3. Tuesday, 20 March 2018 13:22 PM UTC

I have a PB 12.6 app using a local SQL Anywhere 12 db that pipes to an Oracle db.  Client wants to move it to a Citrix environment.  I need to have the SQL Anywhere db support multi-users.  Right now, each user has a SQL Anywhere db on their PC.  What version of SQL Anywhere do I need or can I make my version handle multiple users?

Shenn Sellers Accepted Answer Pending Moderation
  1. Tuesday, 20 March 2018 16:25 PM UTC
  2. PowerBuilder
  3. # 1

SQL Anywhere 12 and other versions come with 2 instances of the DB engine.  DBENG12.EXE is for single-user login, while DBSRV12.EXE is for multiple-user login.  You need to setup your database to use DBSRV12.EXE.  I setup my DB Server by running the following batch file.  All of my SQL Anywhere 12 drivers are in the "c:\_Apps\Albatross\Bin32" directory.

cd "\_Apps\Albatross\Bin32"
dbsvc -as -s auto -t network -w Albatross_DB C:\_Apps\Albatross\Bin32\dbsrv12.exe -n albatross_00 -c 20m C:\_Apps\Albatross\albatross.db

There are no comments made yet.
  1. Tuesday, 20 March 2018 14:03 PM UTC
  2. PowerBuilder
  3. # 2


In my limited understanding you can have SQL Anywhere running on a server and all your users connect to that. The server license would need to be licensed to the number of users. You would need to talk to SAP about the licensing implications.

However, if you application is designed to use a local DB it may not be applicable to use a central server license. So you would need to have a local DB file fo each user on the citrix server. So the database files would need to be in the user environment. Your application would need to connect to that database. I do not know if that would really work in a terminal server / citrix environment or what the licensing implications would be.

Firstly I would try it and prove it works before committing to the strategy, I would create a virtual windows server and a few users and prove the each user could RDP in and run up an application connecting to a separate DB at the same time. I would look at the memory usage per user in order to understand how that might scale up.

Finally, why not more the SQL Anywhere DB tables into the Oracle DB?

Hope that helps.


There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.