?
Solved

client connection sqlanywhere databse

Posted on 1998-08-11
1
Medium Priority
?
428 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
[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
1 Comment
 
LVL 3

Accepted Solution

by:
dapperry earned 80 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This is a fine trick which I've found useful many times, when you just don't want to accidentally run a batch script or the commands needs administrator rights.
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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