|
Home > Archive > SQL Anywhere database > July 2005 > Upgrade from Ver 5.x to Ver9.x, StandAlone to Client/Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Upgrade from Ver 5.x to Ver9.x, StandAlone to Client/Server
|
|
| Chris H 2005-07-27, 8:23 pm |
| I am looking to update an application written in VC++ with ODBC & Sybase SQL
Anywhere Ver 5.x to the current version and from StandAlone Engine to
several clients and one server. What changes should expect I have to make to
the code of the existing project?
I know that some of the ODBC functions are not the most recent but they are
still working.
Thanks
| |
| Breck Carter [TeamSybase] 2005-07-27, 8:23 pm |
| There are lots of differences between 5.5 and 9, but *no* differences
between standalone and network engines except that the network engine
allows more connections and allows connections via network
communications.
See the various "Behavior Changes" sections, plus the "Upgrading
Version 5 Applications" section, in the Help book called "What's New
in SQL Anywhere Studio"
Your application and transaction design may be affected by the change
to multiple users. You may have to deal with different connections
competing for the same rows, etc... suddenly you're in the world of
locks, blocks and isolation levels. Chapter 9 in my book is highly
recommended: "This is the chapter on crashing, bashing, and thrashing,
and the prevention thereof. In other words, it's all about protecting
your database from Very Bad Things." (from the Introduction :)
Breck
On 27 Jul 2005 12:21:33 -0700, "Chris H" <humme.chris.royalmaster.com>
wrote:
>I am looking to update an application written in VC++ with ODBC & Sybase SQL
>Anywhere Ver 5.x to the current version and from StandAlone Engine to
>several clients and one server. What changes should expect I have to make to
>the code of the existing project?
>
>I know that some of the ODBC functions are not the most recent but they are
>still working.
>
>Thanks
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|