Solved

client connection sqlanywhere databse

Posted on 1998-08-11
1
425 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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Looking for Sybase 12.5.4 EBF ESD#9.1 or 10 patch 5 803
SQL Syntax 2 457
How to install new sybase instance in Linux 4 722
SQL Left join on same table 4 319
Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
In order to fulfill our mission of inspiring learning in the technology community, Experts Exchange is launching a Course of the Month program. Premium and Team Account members will have access to one course per month as a part of their membership, …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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