Solved

How to setup SQL Anywhere for multi-user access?

Posted on 1998-06-02
4
1,145 Views
Last Modified: 2012-06-27
I had developed a PB application using the single user Sybase SQL Anywhere. Now we have bought SQL Anywhere (Professional) server. This was setup on an NT server, and the .db file was copied onto the server. The PB application resides on a Win 95 client. The database server was started as a NT service. How do I now connect to this database? What changes, if any, are required in the application.ini file? Is DBCLIENT required to be installed on all client machines or can it be on the database server? How can multiple users connect to this database simultaneously?
Please help....
I am stuck....
Arvind
0
Comment
Question by:rarvindb
[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
4 Comments
 
LVL 2

Expert Comment

by:Ezhil
ID: 1098034
You have to install db client in the client machine if you are going to have DSN (Data Source Name that is  ODBC) Locally.

If Your DSN is sytem DSN  that is created in the server , no need of having db client in all machines , it is enough to install in the server .
0
 

Author Comment

by:rarvindb
ID: 1098035
Hello Ezhil,
Thanks for the response. But I am still at square one.
My question is whether to install dbclient on all client machines or only on server (for multi-user access simultaneously). Obviously, it cannot be local. Secondly, what changes am I required to make to the application.ini file so that the application automatically connects to the database server by multiple users simultaneously.
0
 
LVL 1

Accepted Solution

by:
lekshmikr earned 100 total points
ID: 1098036
ODBC does not know anything about Power builder.Therfore,ODBC does not know anything about the database profiles in PB.INI and the parameters there that define a database connection.Instead ,ODBC must maintain its own set od db profiles,which go by the name Data source configurations are stored in ODBC.INI

here is a sample of the profile section of a ODBC.INI file.
[Profilename ]
Driver=c:\windows\system\wod4o.dll
UID=dba
PWD=sql
Description=anydescription
database=yourdatabasename
start=db32w
databasefile=ur .db filename(with path)
databasename=ur database name
autostop =yes
driver32=c:\sqlany50\win32\wodo50T.dll


You go do this if u go to control panel and configure ODBC.
Although the data source information in ODBC.INI may be sufficient for the ODBC driver to makethe connection,the PB program requires a DB profile for this same database in PB.INI.
Fortunately when u configure an ODBC Data source from the control panel,PB automatically creates the DB Profile for u,saving u that extra step.

Note u have to do this in every client machine.





0
 
LVL 2

Expert Comment

by:jbiswas
ID: 1098037
Yes you have to install dbclient on every machine that accesses this database. You have to connfigure a SQL Anywhere data source in the ODBC area and use this to connect to the server. Secondly oyu have to start the server as a service for multi user access..under the services choice  create a networked database server, and once you have give the protocol(TCP, IPX etc), cache size..etc..look at the dbsrv parameters.. then once you start the service.. multiple clients can connect to it.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
truncation error - math operation 6 563
Sybase SQL Syntax 2 294
Sybase environment variable 1 228
I need expert Sybase Sql help with a query 3 98
Deploying our service is a grudge match between customer benefits and customer pain. In one corner, rolling out fixes (yay!) and delivering new features (double yay!). In the other corner, training on new features (boo – sounds like work), and chan…
The goal of this blog is to: > note what has impeded us from reaching effective life on-call > provide 3 steps to mastering life on-call > highlight what will be achieved with effective life on-call
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

759 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