Upgrade from SQL Anywhere 9.02 to SQL Anywhere 10
This is my first question asked in this forum.
I have been developed both Window and ASP.Net applications using Visual
studio 2003 with C#.Net. It still uses .Net 1.1 with SQL Anywhere 9.02.
Products need to be released for beta test very soon.
I would like to use 'ClearPool' for database connection which I can remove a
specific connection from .Net connection pool when I use the connection
string as POOLING=TRUE. I cannot do this in .Net 1.1 and SQL Anywhere 9.02.
I believe that this feature just added into .Net 2.0 and SQL Anywhere 10.
I am using .Net Data ...TrendMicro PCCelin and SQL Remote with SQL Anywhere 9,02
Sometimes the consolidated Database sais there are corrupt messages while
After stopping the antivirus on remote side pc it works fine.
The SQL Remote works with SMTP. So we deaktivated the scan of smtp outgoing
However the same problem will occur sometimes.
Is there a temporary folder where sqlremote creates the outgoing messages?
May be that the antivivirus software
modifies these temporary files ??
For any help - thanks in advance!
Greetings Frank Steinmann
There should be no storage of smtp based message ...SQL Anywhere 9 / SQL Anywhere 11
Using Mobilink we are looking to synchronize a SQL Anywhere
22.214.171.12434 db with a SQL Anywhere 11 consolidated db, are
there certain arguments I need to add to the server and
client execution lines?
Also, will SQL Anywhere 9 db work with SQL Anywhere 11 db
via Remote Servers? Are there special parameters required?
To synchronize a 9.0.2 client with an 11.0.1 MobiLink server you will need to use the -xo switch.
-xo switch: http://dcx.sybase.com/index.html#1101en/mlserver_en11/ml-syncserver-xo.html
The remainder of the MobiLink switches will be specif...SQL AnyWhere 9.02 very slow
I'm fighting with performance problems here. We have a
customer that uses an ERP-Software that's based on Sybase
SQL Anywhere 9.02. The database "weights" is about 5GB.
When searching large tables (> 1 mio. records) it takes a
long time until the resultset is available. We checked all
the indexes and I think thay are correct (all searched
values are in the index).
One problem may be that the ERP-software uses two CHAR(10)
fields for the primary key. But I cannot change this because
I'm not the autor of the software...
Any Ideas on how or where I can inc...SQL Anywhere 9.02 and connection Pooling
I am using an ASA 9.02.3599
I downloaded and am using the latest J-Connect driver (don't
know build number) jconn3.jar
I am using this in conjucntion with the SUN Application
Server. I set up the connection pool, and it initializes
fine, however the connections never get released back into
the pool. nThe end result is that my pool maxes out and I
run out of connections.
Is there anything specific to this setup that I should know
that could be causing this hangup.
ANything special that I need to do to release the connection
back into the pool?
Any special database opti...SQL Anywhere 9.02 vs 10 information?
Is there an online document someone can point me to that describes the
primary differences between SQL Anywhere v.9.0.2 and v.10.0 ? We are
adding a new location (identical client software, LAN setup, etc),
therefore a new server (the other 2 locations use 9.0.2) and I know both
versions are still available, but I hate to buy an old version.
The most thorough description is the What's New section of the V10
Help, which you can get for free by downloading the Developers
There is also an opinionated article Top 10 Cool New Feature...Upgrade SQL Anywhere 5.0 to SQL Anywhere 9.0
Does anyone know of any scripts that can be used to prevent
DB errors when upgrading a V5.0 database to a V9.0
What error messages are you receiving?
<fd1smith> wrote in message news:firstname.lastname@example.org...
> Does anyone know of any scripts that can be used to prevent
> DB errors when upgrading a V5.0 database to a V9.0
...SQL Anywhere 9.02
Sybase runs slower on our new web server. We've upgraded
from a singe cpu server with 1 hard drive to a 2 dual-core
xeon system with 5 hard drives on RAID (same OS - Win 2003,
SP1). Sybase now takes 30 to 40 mins to rebuild the
database, compared to 12 mins on the previous machine. In
fact, the web site that accesses the Sybase database runs so
slowly that we've migrated back to the previous server.
There must be a conflict or constraint of some kind, but
apartment from hardware the new server has been configured
in the same way as the old one to the best of my knowledge.
Any...SQL Anywhere 9.02 authentication failure when creating a new dbspace
Can anybody help me please? I installed the SQL Anywhere
Studio 9.0, upgraded to 9.0.2 (Windows XP) and I have this
error: authentication failure (SQLCODE = -98) when creating
a second dbspace in a new database. Same error occurs when
trying to create a user.
Does anybody have an idea what's wrong?
Have you implemented the changes to saopts.sql as indicated in the "Readme
First Authenticated Edition"?
<raducriveanu> wrote in message news:email@example.com...
> Hi there,
> Can anyb...Missing files for Embedded SQL Programming in SQL Anywhere 9
We have SQL Anywhere 9 Developer Edition installed.
Previous version was ASA 6 and we worked with Embedded SQL.
Now we need few files to rebuild our C++ project ( dblibtm.lib and *.h ) and
can't find them (.
According to Online Book "...All import libraries are installed in the lib
subdirectory, under the operating system subdirectory of the SQL Anywhere
installation directory. For example, Windows import libraries are stored in
the win32\lib subdirectory..."
but the files are missimg.
Any suggestions ?
Victor Rolnikov wrote:...PowerBuilder 9.01 and SQL Anywhere Studio 9.0
Will PB 9.01 applications work with SQL Anywhere Studio 9.0
on Windows 2003 server? Documentation says is was tested
with SQL Anyhwere Studio 8.02.
I haven't had any issues with that combination.
<Dan Schuster> wrote in message news:firstname.lastname@example.org...
> Will PB 9.01 applications work with SQL Anywhere Studio 9.0
> on Windows 2003 server? Documentation says is was tested
> with SQL Anyhwere Studio 8.02.
ASA9 is support on Win2003 (
Chris Kea...any difference between sql anywhere and sql anywhere studio
Is there any difference between sql anywhere and sql anywhere studio?
>Is there any difference between sql anywhere and sql anywhere studio?
The answer depends upon the context of the question. Years ago, "sql anywhere" referred to the DBMS
that is now known as Adaptive Server Anywhere. Now, "sql anywhere" can mean a general reference to
a set of products that includes ASA, as well as some other things. "sql anywhere studio" is a
particular bundling of these products.
Still, sometimes when people refer to "sql anywhere" t...SQL Anywhere 9
How can I install the SQL Anywhere 9 in a pocket builder
I use "c:\Sybase\SQL Anywhere 9\ce\arm.30\asa_ce.ARM.30.CAB", which I
copy to my device and then I use cabinstl.exe (a free tool) to install
it wherever I want to, but you can also just click on the .CAB so that
it will install to its default folder.....
On 23 Mar 2004 08:48:30 -0800, Def wrote:
>How can I install the SQL Anywhere 9 in a pocket builder
...SQL Anywhere, ASA and SQL Anywhere Studio.
I will want understand the history of the products names SQL
Anywhere, ASA and SQL Anywhere Studio.
Is an evolution of same product?
Previously these exists Sybase SQL Server?
Sybase SQL Server is the product what has been involved in
project with Microsoft, what result in MS SQL Server?
Thanks very much.
<Renato Cramer> wrote:
> I will want understand the history of the products names SQL
> Anywhere, ASA and SQL Anywhere Studio.
Watcom SQL -> Sybase SQL Anywhere -> Sybase Adaptive Server Anywhere.
> Is an evolution of sa...