Re: upgrade from ASA6 to ASA9

#1

But I will still be able to experience the performance of v9 which is said
to be much better than v6.
I might be able to use the Index Consultant.

And, more important, will I be able to leave my sourcecode unchanged by
using the V6 odbc client?

"Chris Keating (iAnywhere Solutions)" <FightSpam_keating (AT) iAnywhere (DOT) com>
wrote in message news:3fcbbabd$1 (AT) forums-2-dub (DOT) ..

Quote:

Yes but you would not be able to access any of the new features for ASA9
that are dependent on the ODBC driver.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************
*

"Jan van Veldhuizen" <jan (AT) van-veldhuizen (DOT) nl> wrote in message
news:3fcbb66b$1 (AT) forums-2-dub (DOT) ..
Will it be possible to use the version 6 odbc client to get connected to
a
version 9 database?

"Nick Elson" <no_spam_nicelson (AT) sybase (DOT) com> wrote in message
news:3fcb65f9$1 (AT) forums-1-dub (DOT) ..
Possibly the biggest change for you will be seeing is the
choice of ADO driver.

With ASA 6 there were no OLEDB or ADO.Net drivers
available from iAnywhere. That started to change with
version 7.

You may find things better since you are currently using
Microsoft 'bridge' technologies but you could have coded
to some limitation of those.

"Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom> wrote in message
news:3fcb5616$1 (AT) forums-1-dub (DOT) ..
We went from ASA7 to ASA9 recently...
All we found was that the query parser was "tightened up", so
certain
queries that got through the parser in 7 got
flagged with "invalid syntax" in ASA9. These included things like
poorly
formed LEFT OUTER JOIN chains (PB is notorious
for painting these incorrectly...)

Select *
from
A LEFT OUTER JOIN B,
B LEFT OUTER JOIN C
...

This is acceptable in ASA7, but not in ASA9. You have to rewrite
these
as:

Select *
from
A LEFT OUTER JOIN B
LEFT OUTER JOIN C
...

Also, if you take advantage of User-defined functions, they now can
be
classified as DETERMINISTIC or NOT DETERMINISTIC.
That helps the database engine know whether it must re-invoke the
function
for each row, or whether it can cache and
reuse the result for each set of unique inputs.

--
Paul Horan[TeamSybase]

"Jan van Veldhuizen" <jan (AT) van-veldhuizen (DOT) nl> wrote in message
news:3fcb1f09 (AT) forums-1-dub (DOT) ..
Has anyone done an upgrade from ASA6 to 9?

I think the database will be no problem, but what problems can I
expect
in
upgrading my application? It's VB6, using ADO and passthrough
queries
to
handle the database.

#2

The index consultant will only support 9.0 database files, or files
which have been upgraded to 9.0 (making the database unusable thereafter
by older server software). I do NOT recommend an upgrade of the
database; you should unload/reload so that the version 9 engine can
exploit table page bit maps and column histograms as it was designed to do.

Glenn

Jan van Veldhuizen wrote:

Quote:

But I will still be able to experience the performance of v9 which is said
to be much better than v6.
I might be able to use the Index Consultant.

And, more important, will I be able to leave my sourcecode unchanged by
using the V6 odbc client?

"Chris Keating (iAnywhere Solutions)" <FightSpam_keating (AT) iAnywhere (DOT) com
wrote

Yes but you would not be able to access any of the new features for ASA9
that are dependent on the ODBC driver.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************

*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************

*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************

*

"Jan van Veldhuizen" <jan (AT) van-veldhuizen (DOT) nl> wrote in message
news:3fcbb66b$1 (AT) forums-2-dub (DOT) ..

Will it be possible to use the version 6 odbc client to get connected to

a

version 9 database?

"Nick Elson" <no_spam_nicelson (AT) sybase (DOT) com> wrote in message
news:3fcb65f9$1 (AT) forums-1-dub (DOT) ..

Possibly the biggest change for you will be seeing is the
choice of ADO driver.

With ASA 6 there were no OLEDB or ADO.Net drivers
available from iAnywhere. That started to change with
version 7.

You may find things better since you are currently using
Microsoft 'bridge' technologies but you could have coded
to some limitation of those.

"Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom> wrote in message
news:3fcb5616$1 (AT) forums-1-dub (DOT) ..

We went from ASA7 to ASA9 recently...
All we found was that the query parser was "tightened up", so

certain

queries that got through the parser in 7 got

flagged with "invalid syntax" in ASA9. These included things like

poorly

formed LEFT OUTER JOIN chains (PB is notorious

for painting these incorrectly...)

Select *
from
A LEFT OUTER JOIN B,
B LEFT OUTER JOIN C
...

This is acceptable in ASA7, but not in ASA9. You have to rewrite

these

as:

Select *
from
A LEFT OUTER JOIN B
LEFT OUTER JOIN C
...

Also, if you take advantage of User-defined functions, they now can

be

classified as DETERMINISTIC or NOT DETERMINISTIC.

That helps the database engine know whether it must re-invoke the

function

for each row, or whether it can cache and

reuse the result for each set of unique inputs.

--
Paul Horan[TeamSybase]

"Jan van Veldhuizen" <jan (AT) van-veldhuizen (DOT) nl> wrote in message

news:3fcb1f09 (AT) forums-1-dub (DOT) ..

Has anyone done an upgrade from ASA6 to 9?

I think the database will be no problem, but what problems can I

expect

in

upgrading my application? It's VB6, using ADO and passthrough

queries

to

handle the database.

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: upgrade from ASA6 to ASA9

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: upgrade from ASA6 to ASA9 - 12-04-2003 , 04:07 PM

Re: upgrade from ASA6 to ASA9 - 12-04-2003 , 04:16 PM