PB 9.0.2 ebf 3044

We attempted to move out database to a new server and can see that the
server engine is running on the server. We can connect to the database
while on the server. We can also open our application and view and edit
data in the database.

However On the Client Computer(s) when we change the odbc connection to
reflect the new server name, and the host ip address, it says database not
found.

We've shared the database directory on the new server with everyone. While
on the client we can see the server (successfully mapped a drive).

I'm sure we've missed something simple, but can't figure it out. Any advice
would be greatly appreciated.

Thanks,
Loya

Loya Kelso wrote:
Can you ping the ip address from the client machine?
How about dbping?
(http://dcx.sybase.com/index.php#http...utilities.html)

Does this mean you are trying to start the database engine when the
client connects? We don't recommend accessing the database across
network shares as they do not guarantee everything will be written as we
need it to be. (See this for details:
http://www.sybase.com/detail?id=1034790)

What you should do is have a database server (dbsrvXX) running with the
database already loaded, then you can connect with tcpip.

We have tried the dbping and it is not successful, however a ping sees the
server. I think my error is in my batch file to set up the database server
name and start the engine running. The reason I say that is becasue even
though I can access my database while on the server, I don't have the option
to stop my database on the services tab while in Sybase Central. So to me
that makes it appear as though it's running as the client and the server,
like when I set it up on my labtop to be both, not a server. Hopefully that
makes sense.

Below is the batch file I ran from the sybase\....\win32 directory to set up
the database server name and start the engine running. After I run the code
below, I set up the odbc connection and am able to connect to the db while
on the server, but still not anywhere else.

REM
REM Creates server name for the database to CareTrak V4.0. and starts the
database server
REM Need to update the host to their host number
REM
REM creates server named lebanonisprit
REM
dbeng9 -n lebanonisprit c:\isprit_caretrak\Isprit_Lebanon_1.db -n
caretrak_serv2
REM

Thanks in advance for any advice.

Loya


"Kory Hodgson (Sybase iAnywhere)" <khodgson (AT) A_SPAM_FREE_sybase (DOT) com> wrote in
message news:4a9f1446 (AT) forums-1-dub (DOT) ..

You are using dbeng9 which is the personal server (no network
capabilities) you should use dbsrv9 this is the network server and
should allow you to connect.


Loya Kelso wrote: