Solved

client connection sqlanywhere databse

Posted on 1998-08-11
1
414 Views
Last Modified: 2008-03-06
my sqlanywhere databse is on the server,i connect to databse by running the dbeng50.exe on the client machine  with the path of the network of the databse server it get started and then i run my client with the path of the server is it necessary to start dbeng50.exe  on every client machine before making the connection before running the client

after running the client on the first machine when i start my dbeng50.exe on second client machine with the path of the server then it gives error message "could not open/read databse file " and the path and name of the server databse

if i close my client on first machine then client gets started on second machine after starting the dbeng50.exe with the server path

its very urgent so plase help me out
0
Comment
Question by:lav
1 Comment
 
LVL 3

Accepted Solution

by:
dapperry earned 20 total points
ID: 1098196
You have this set up all wrong.  You don't want to be running dbeng50.exe, unless you are running a database purely locally.  You want to set up a server service on the machine with the SQL Anywhere Server set up on it.  You do this put setting up an entry in SQL Anywhere Service Manager, then clicking 'New' and then clicking on the 'Network Server' radio button, and clicking on 'Ok'.  You then fill out the next dialog box, by giving the new service a name, by giving out any parameters, and by selecting whether you want this service to be started automatically (I'd reccommend it, so you don't need to be logged on to the Server to have the service running)  You will note that the service executable is actually DBSRV50.exe.  If you run the program interactly with a ? mark you can get a list of parameters to put in the parameter box.  Heres an example parameter entry for the 'testme' service:

-x ipx
-c 50M
 c:\test\test.db

The first line specifies which network protocols you want to use, the 2nd, how much of a memory cache you want, and the 3rd is the path & filename of the database.

Anyhow, then you install the client on your other workstations.  AFter that you run "dbclient.exe -x ipx testme" from the workstation, and you are then connected.  You could also probably set up some kind of a startup program to launch the client each time a person logs in, but whatever...

Hope this helps

:) D Perry
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

What is Backup? Backup software creates one or more copies of the data on your digital devices in case your original data is lost or damaged. Different backup solutions protect different kinds of data and different combinations of devices. For e…
We have come a long way with backup and data protection — from backing up to floppies, external drives, CDs, Blu-ray, flash drives, SSD drives, and now to the cloud.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now