Solved

client connection sqlanywhere databse

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

One of the biggest threats in the cyber realm pertains to advanced persistent threats (APTs). This paper is a compare and contrast of Russian and Chinese APT's.
For months I had no idea how to 'discover' the IP address of the other end of a link (without asking someone who knows), and it drove me batty. Think about it. You can't use Cisco Discovery Protocol (CDP) because it's not implemented on the ASAs.…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

813 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

13 Experts available now in Live!

Get 1:1 Help Now