We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to setup SQL Anywhere for multi-user access?

rarvindb
rarvindb asked
on
Medium Priority
1,300 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
Comment
Watch Question

Commented:
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 .

Author

Commented:
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.
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.