SQL Anywhere database - Upgrade from asa8.xx to asa 9.02

Author

Upgrade from asa8.xx to asa 9.02

M.Erlinger

2005-06-15, 3:23 am

Hello

i have a question to upgrade-process: if the customer want to upgrade
ASA-8-Database to ASA-9.02 - is it requisitely to upgrade all client's - or
could run the client-installation with asa-8-client-software and asa-8
client-odbc-configuration......?
if "yes" - it could run with asa-8-client - is this recommendable?? - or
could result there any problems?

thank's for helping
Michael

Chris Keating $iAnywhere Solutions$

2005-06-15, 7:23 am

Generally, there is no requirement for the client version to match the
server version (one exception is that SQL Anywhere 5 cannot be used with
ASA6 and later due to changes in the communications layer). If you use older
client software, any client dependent feature introduced in ASA9 will not be
available.

--

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

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

"M.Erlinger" <michael.erlinger@vienna.at> wrote in message
news:42afcfc8$1@foru
ms-1-dub...
> Hello
>
> i have a question to upgrade-process: if the customer want to upgrade
> ASA-8-Database to ASA-9.02 - is it requisitely to upgrade all client's -
> or could run the client-installation with asa-8-client-software and asa-8
> client-odbc-configuration......?
> if "yes" - it could run with asa-8-client - is this recommendable?? - or
> could result there any problems?
>
> thank's for helping
> Michael
>
>

Erik Anderson

2005-06-15, 11:23 am

We've been running an ASA9 server for some time with ASA8 clients. There
are some limitations (the ASA8 iSQL doesn't recognize temporary views so any
commands using them need to be wrapped in BEGIN ... END blocks, ASA8 clients
won't receive messages sent to them from a different connection), but there
have been no major problems reported. I hope to upgrade the ASA8 clients
Real Soon Now....

"M.Erlinger" <michael.erlinger@vienna.at> wrote in message
news:42afcfc8$1@foru
ms-1-dub...
> Hello
>
> i have a question to upgrade-process: if the customer want to upgrade
> ASA-8-Database to ASA-9.02 - is it requisitely to upgrade all client's -
> or could run the client-installation with asa-8-client-software and asa-8
> client-odbc-configuration......?
> if "yes" - it could run with asa-8-client - is this recommendable?? - or
> could result there any problems?
>
> thank's for helping
> Michael
>
>

M.Erlinger

2005-06-16, 7:23 am

Thank's for answer - is there a limitation: in example with the procedure
"sa_conn_info()" with ASA-9-Server and ASA-8-clients and a Powerbuilder
(9.02)-application
i have a datawindow with this select (using sa_conn_info()) - works these
statements with the asa-8client?
--->
SELECT "mitarbeiter"."pi_mitarbeiter",
"mitarbeiter"."c_nummer",
"mitarbeiter"."c_vname",
"mitarbeiter"."c_fname",
"mitarbeiter"."c_kuerzel",
"mitarbeiter"."c_login",
"mitarbeiter"."c_passwort",
"mitarbeiter"."si_kz_mitarbeiter",
"mitarbeiter"."c_kz_aktiv",
"mitarbeiter"."c_ang_verw",
"mitarbeiter"."c_beschw_verw",
"mitarbeiter"."c_stammdaten",
"mitarbeiter"."c_off_kopf2",
"mitarbeiter"."c_land_vorschlag",
"mitarbeiter"."c_gebiet_vorschlag",
"mitarbeiter"."p_verk_vorschlag",
"mitarbeiter"."c_off_bearbeiten",
"mitarbeiter"."c_kz_statistik"
FROM "mitarbeiter", sa_conn_info()
WHERE userID = mitarbeiter.c_login ....................
<----------------

thank's and regards
Michael

"Erik Anderson" < erikba@teamworkgroup
.com> schrieb im Newsbeitrag
news:42b05606@forums
-2-dub...
> We've been running an ASA9 server for some time with ASA8 clients. There
> are some limitations (the ASA8 iSQL doesn't recognize temporary views so
> any commands using them need to be wrapped in BEGIN ... END blocks, ASA8
> clients won't receive messages sent to them from a different connection),
> but there have been no major problems reported. I hope to upgrade the
> ASA8 clients Real Soon Now....
>
> "M.Erlinger" <michael.erlinger@vienna.at> wrote in message
> news:42afcfc8$1@foru
ms-1-dub...
>
>

Erik Anderson

2005-06-16, 1:23 pm

Unless you are using something like iSQL, the client cares very little about
the SQL statements that you are sending across. I don't use Powerbuilder
and I'm not sure I've used a "mixed procedure call" like you have here
(although I do use those kinds of statements), but I don't believe that I
have had a problem like you are asking about.

The issue I have with temporary views is that iSQL doesn't recognize the
WITH clause and throws a syntax error; I have to put a BEGIN/END block
around it for it to be passed to the server. This seems to be an iSQL'ism
though (It isolates each command individually and executes them one by one),
as I have a number of reports that open up an ODBC connection and send a
query out using WITH using the ASA8 driver; there have been no problems
here. The ASA8 ODBC client driver should not be preventing you from using
these SQL commands.

"M.Erlinger" <michael.erlinger@vienna.at> wrote in message
news:42b15f78$1@foru
ms-2-dub...
> Thank's for answer - is there a limitation: in example with the procedure
> "sa_conn_info()" with ASA-9-Server and ASA-8-clients and a Powerbuilder
> (9.02)-application
> i have a datawindow with this select (using sa_conn_info()) - works these
> statements with the asa-8client?
> --->
> SELECT "mitarbeiter"."pi_mitarbeiter",
> "mitarbeiter"."c_nummer",
> "mitarbeiter"."c_vname",
> "mitarbeiter"."c_fname",
> "mitarbeiter"."c_kuerzel",
> "mitarbeiter"."c_login",
> "mitarbeiter"."c_passwort",
> "mitarbeiter"."si_kz_mitarbeiter",
> "mitarbeiter"."c_kz_aktiv",
> "mitarbeiter"."c_ang_verw",
> "mitarbeiter"."c_beschw_verw",
> "mitarbeiter"."c_stammdaten",
> "mitarbeiter"."c_off_kopf2",
> "mitarbeiter"."c_land_vorschlag",
> "mitarbeiter"."c_gebiet_vorschlag",
> "mitarbeiter"."p_verk_vorschlag",
> "mitarbeiter"."c_off_bearbeiten",
> "mitarbeiter"."c_kz_statistik"
> FROM "mitarbeiter", sa_conn_info()
> WHERE userID = mitarbeiter.c_login ....................
> <----------------
>
> thank's and regards
> Michael
>
>
> "Erik Anderson" < erikba@teamworkgroup
.com> schrieb im Newsbeitrag
> news:42b05606@forums
-2-dub...
>
>

Chris Keating $iAnywhere Solutions$

2005-06-17, 9:23 am

I have no specific problem with this. What are the specific versions and
builds of the various software involved?

"M.Erlinger" <michael.erlinger@vienna.at> wrote in message
news:42b15f78$1@foru
ms-2-dub...
> Thank's for answer - is there a limitation: in example with the procedure
> "sa_conn_info()" with ASA-9-Server and ASA-8-clients and a Powerbuilder
> (9.02)-application
> i have a datawindow with this select (using sa_conn_info()) - works these
> statements with the asa-8client?
> --->
> SELECT "mitarbeiter"."pi_mitarbeiter",
> "mitarbeiter"."c_nummer",
> "mitarbeiter"."c_vname",
> "mitarbeiter"."c_fname",
> "mitarbeiter"."c_kuerzel",
> "mitarbeiter"."c_login",
> "mitarbeiter"."c_passwort",
> "mitarbeiter"."si_kz_mitarbeiter",
> "mitarbeiter"."c_kz_aktiv",
> "mitarbeiter"."c_ang_verw",
> "mitarbeiter"."c_beschw_verw",
> "mitarbeiter"."c_stammdaten",
> "mitarbeiter"."c_off_kopf2",
> "mitarbeiter"."c_land_vorschlag",
> "mitarbeiter"."c_gebiet_vorschlag",
> "mitarbeiter"."p_verk_vorschlag",
> "mitarbeiter"."c_off_bearbeiten",
> "mitarbeiter"."c_kz_statistik"
> FROM "mitarbeiter", sa_conn_info()
> WHERE userID = mitarbeiter.c_login ....................
> <----------------
>
> thank's and regards
> Michael
>
>
> "Erik Anderson" < erikba@teamworkgroup
.com> schrieb im Newsbeitrag
> news:42b05606@forums
-2-dub...
>
>

Sponsored Links