sqlanywhere and sqlanywhere server
Currently i am using sqlanywhere and powerbuilder tool as my system
development. And i am developing a standalone system. Let say, if i want to
migrate my standalone system to client-server system, how do i do that? I
heard that i need to have sqlanywhere(server engine) to deploy my system as
client-server system. If so, do i need to install sqlanywhere(server engine)
into window NT or just normal pc(treat as server).
For client-server system, do i need to install sqlanywhere server at server
and sqlanywhere client as normal pc where my program is installed?
Could someone tell me where...sqlanywhere vs. sqlanywhere.generel
What is the difference between the newsgroups sqlanywhere and
There is no difference.
We are working on consolidating the duplicate newsgroups. Watch for
notices, it will tell you where the combined newsgroup will end up.
Markus KARG wrote:
> What is the difference between the newsgroups sqlanywhere and
Director, Sybase Developers Network (SDN)
in order to clarify:...Migration from SQLAnywhere 10 to SQLAnywhere 11
Do I need to migrate the database file if i want to migrate my application
from SQLAnywhere 10 to SQLAnywhere 11? or a databse file created by
SQLAnywhere10 will run fine under SQLAnywhere 11?
Upgrading version 10.0.0 and later databases
If you are upgrading from version 10.0.0 or later, you can either use
the Upgrade utility or rebuild your database. Upgrading or rebuilding is
an optional step because the version 11 software ...SQLAnywhere fails from service
I have an NT service that tries to connect to a SQLAnywhere v5.0.2 database
that is local. It fails with a "[Sybase][ODBC Driver]: db_init() failed" --
anybody know why this is? The service is logging in as a user with
Administrative rights and the ODBC data source is a System DSN.
I assume that the database is already created and it is also started as an
NT service. Besides checking the command line parameters you might
look at the dependencies for the service that is failing. It should be
on the database engine and start after ...About SQLAnywhere...
Hello, I�ve developed a program with PowerBuilder 6.5 and the Sybase SQL
Anywhere engine. I have a question: Can I distribuit my application with
these engine?, or I have to obtain a license por each machine for
Thanks in advance
On Thu, 26 Nov 1998 17:45:30 -0600,
Oscar Miranda <firstname.lastname@example.org> wrote:
>Hello, I�ve developed a program with PowerBuilder 6.5 and the Sybase SQL
>Anywhere engine. I have a question: Can I distribuit my application with
>these engine?, or I have to obtain a license por ea...Starting SQLAnywhere as a service
I can't seem to start SQLA.. as a service. If I fire it up by hand
everything is fine, when I try to start it as a service, it does not start,
and if I try to start it from the services utility of NT, I get a error 1058
and a message that says that it has been disabled, but of course it is
marked as auto. Any ideas?
...SQLAnywhere Shut down and REstart
Please, what command is used to shut down and restart ASA ?
Typically what directory is the DB stored in on a RedHat
box? Is there a graphical interface I can search for in the
Jim R wrote:
> Please, what command is used to shut down and restart ASA ?
> Typically what directory is the DB stored in on a RedHat
> box? Is there a graphical interface I can search for in the
> file system?
There is a "SQLAnywhere on Linux/Unix/OSX" newsgroup:
How you start/stop the database on a Unix (or Linux) s...Sqlanywhere.general missing?
I have not been able to get to the sqlanywhere.general news group in a
couple of weeks now. Has something changed?
The newsgroups have moved to a new server. You will need to reset your
Joshua Savill , SYBASE
iAnywhere Solutions - Technical Support
"James L. Blackburn" <email@example.com> wrote in message
> I have not been able to get to the sqlanywhere.general news group in a
> couple of weeks now. Has something changed?
Same name, different IP address. It co...Starting SQLAnywhere as a service
I can start the engine, server, and client as services and they run fine.
But if I add DBREMOTE to the mix I invariably get an error because NT tries
to run DBREMOTE before the engine.
Sybase Central allows me to indicate that the DBENG50 should be run before
DBREMOTE to get around this.
My problem is that I don't want to ship Sybase Central with the product. I
would rather just have the installation program make the appropriate
registry entries itself.
Does anybody know what registry entries need to be made?
HKEY_LOCAL_MACHINE\SYSTE...getting error after upgrading from sqlanywhere 7 to sqlanywhere 9
i'm using sybase sql server any where 7 and by using
dbsrv7.exe i'm able to create db.
it's working fine. no issues.
now i'm upgrading to sybase sql server any where 9 and by
using dbsrv9.exe i created
db. this time when i'm using sysindexes table of sybase i'm
Table name 'sysindexes' is ambiguous exception
because ASA Error -852: Table name 'sysindexes' is
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -852: Table
name 'sysindexes' is ambiguous
at com.sybase.jdbc2...Starting SQLAnywhere Service automatically
Does anybody know how I can start a NT-Service I created
with dbsvc <params>. I don't want to start it by the Service-Manager
but with ShellExecute(...,...) within a Programming Language.
Is there command from Sybase or is it an API-Call?
I don't know what API call I'd use, but from a command prompt, I'd just use
NET START and NET STOP.
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choo...Running SQLAnywhere *from* a System Service
I am trying to open an ODBC Data Source from within a System Service
(using SQLAnywhere). I created a System Data Source and it
works fine when opening it from a normal application. But when my System
Service tries to open the database, I get "Driver's SQLAllocEnv
failed". I get the same problem when I run SQLAnywhere as a System
Service. What exactly is SQLAnywhere trying to do that the System
Service doesn't like? What is the best solution?
thanks for any pointers!
Need to add sqlany50\win32 to your system path.
Yuval Zalkow <firstname.lastname@example.org&...XP SQLAnywhere 5 Service
We keep getting errors when trying to start a service under Windows XP.
Downloaded and installed the latest EBF but that didn't help still getting
the same errors. Anyone successfully starting SA5 as a service under XP ?
If so what is the trick ?
Disregard. We uninstalled sybase and reinstalled and all went well, service
is up and running.
"Mark Soukup" <email@example.com> wrote in message
> Hi everyone,
> We keep getting errors when trying to start a service under Windows XP.
> Do...Update Fails to SQLAnywhere, but PB/ODBC/SQLAnywhere returns Success...
I recently dropped a reply in the SQLAnywhere Newsgroup regarding the
question of "Death
by Curly Brackets" and am not even sure the problem we're experiencing is
related, BUT basically, if we have a variable in an SQLA table of type
"char" and then declare an internal host variable in Powerbuilder 6.0, and
execute an Insert or an Update against the table, PB and/or SQLA both
return success, but the table DOES NOT get updated... here's futher
details... Check out the ODBC dump below, is this a bug in PB, ODBC,
SQLAnywhere or ALL of the above
ANY HELP IS ...