Hi,

I have a weird issue here.

In windows 2000, if I login as a console user and try to
open a sql anywhere 11 DB file in Sybase Central, it fails
("Unable to start/stop database..."). I'm not using ODBC,
instead I directly connect to the DB using the Database File
property on the Database Tab.

However, if I login as a remote user (RDP) with the same
credentials (login/password) as console user, I'm able to
open the DB without any issues.

We current have version Sql Anywhere 11.0.1578 installed on
the machine.

Any idea what's going on?

Niroshan
Apex Systems Integrators

It sounds like you are trying to start the database when it is already
running.

What is the connection string you are using and can you confirm if the
server is already running? You could use dblocate to find all running
servers.

If it is running remove the use the ENG=servername instead of
dbf=databasefile.


Niroshan wrote:

The DB is not running. I've even tried rebooting the server
and than trying to start the DB. It all fails on the
console.

This issue actually cam up when I was trying to use the
following command to open the DB:

dbisql.exe -c "DBF=FS.db;uid=dba;pwd=sql" "update
DatabaseVersion_nosync set CurrentVersion='1.0.1'"

When that didn't work, I tried opening the DB in sybase
central.
Which failed with the same error ("Unable to start/stop
database...").

However, if I login with the RDP user(same login),
everything works. I'm not sure why it doesn't work on the
console user.

It's a very strange error.

What is the connection string for the RDP user?

Are you running dbisql from the folder containing FS.db? Can you provide
a full path?


Niroshan wrote:

I'm executing the following in the db folder:

C:\Program Files\SQL Anywhere 11\Bin32\dbisql.exe -c
"DBF=c:\dev\Applications\FieldService\V3.1\FieldSe rviceMobileSolution\\FieldServiceMobileInstall\FS. db;
uid=dba;pwd=sql" "update DatabaseVersion_nosync set
CurrentVersion='1.0.1'"

I'm using the same command via rdp as console, so I'm dont
think it's a command issue.

What about if you try to start the database by doing:

dbsrv11
c:\dev\Applications\FieldService\V3.1\FieldService MobileSolution\\FieldServiceMobileInstall\FS.db

Then connect with:

C:\Program Files\SQL Anywhere 11\Bin32\dbisql.exe -c
"ENG=FS.db;uid=dba;pwd=sql" "update DatabaseVersion_nosync set
CurrentVersion='1.0.1'"



Niroshan wrote: