Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Anywhere Version 5.0 Database Conversion To iAnywhere 8.0 Issue

5 posts in General Discussion Last posting was on 2003-11-12 23:11:28.0Z
Bob Melcos Posted on 2003-11-12 19:13:00.0Z
Sender: 6a03.3fb28785.1804289383@sybase.com
From: Bob Melcos
Newsgroups: ianywhere.public.general
Subject: SQL Anywhere Version 5.0 Database Conversion To iAnywhere 8.0 Issue
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fb28785.6a03.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 12 Nov 2003 11:18:29 -0800, 10.22.241.42
Lines: 11
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Nov 2003 11:04:00 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Nov 2003 11:13:00 -0800
X-Trace: forums-1-dub 1068664380 10.22.108.75 (12 Nov 2003 11:13:00 -0800)
X-Original-Trace: 12 Nov 2003 11:13:00 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2060
Article PK: 4275

We currently have a vertical market application that uses
SQLAnywhere 5.0 database at it's backend. The application is
installed as a standalong app or as a client server app
depending on the client needs. We are now upgrading the
database engine to 8.0 and mirgrating the database as well
to 8.0. However, when we install the ASA 8.0 on the client
machine it destroys the 5.0 client libraries and so we are
unable to connect to the old database that needs to be
converted. The database conversion fails. Version 8 client
libraries do not seem to connect to version 5. Does any one
know the fix? Thanks.


Stephen Rice Posted on 2003-11-12 20:25:08.0Z
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere Version 5.0 Database Conversion To iAnywhere 8.0 Issue
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3fb28785.6a03.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns94319B5443375sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: srice-pc.sybase.com
X-Original-NNTP-Posting-Host: srice-pc.sybase.com
Date: 12 Nov 2003 12:25:08 -0800
X-Trace: forums-1-dub 1068668708 172.31.141.106 (12 Nov 2003 12:25:08 -0800)
X-Original-Trace: 12 Nov 2003 12:25:08 -0800, srice-pc.sybase.com
Lines: 44
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2062
Article PK: 4278


Bob Melcos wrote in news:3fb28785.6a03.1681692777@sybase.com:

> We currently have a vertical market application that uses
> SQLAnywhere 5.0 database at it's backend. The application is
> installed as a standalong app or as a client server app
> depending on the client needs. We are now upgrading the
> database engine to 8.0 and mirgrating the database as well
> to 8.0. However, when we install the ASA 8.0 on the client
> machine it destroys the 5.0 client libraries and so we are
> unable to connect to the old database that needs to be
> converted. The database conversion fails. Version 8 client
> libraries do not seem to connect to version 5. Does any one
> know the fix? Thanks.
>

In version 6 we changed the communications protocols between the client
and the server. Full details are available in the v6 documentation set
available on ianywhere.com

A couple of comments that may lead to a solution in your particular
circumstances:
- v5 databases can be loaded onto v8 servers. It may be possible for
you to do all of your operations using v8
- v8 installs in its own directory and both versions can co-exist. This
means you can connect to a v8 server using the v8 libraries and a v5
server using the v5 libraries.

Are you the developer of the application or a user? If you are a user
you should speak to your vendor for advice before proceeding. There are
a number of changes to v8 that may cause an application written for v5
to stop working correctly.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

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


Bob Melcos Posted on 2003-11-12 21:57:12.0Z
Sender: 18c6.3fb2acb7.1804289383@sybase.com
From: Bob Melcos
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere Version 5.0 Database Conversion To iAnywhere 8.0 Issue
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fb2acb8.18c6.1681692777@sybase.com>
References: <3fb28785.6a03.1681692777@sybase.com><Xns94319B5443375sricenospamianywhere@10.22.241.106>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Nov 2003 13:57:12 -0800
X-Trace: forums-1-dub 1068674232 10.22.241.41 (12 Nov 2003 13:57:12 -0800)
X-Original-Trace: 12 Nov 2003 13:57:12 -0800, 10.22.241.41
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2064
Article PK: 4283

Steve, thanks for your insight. We are the developers of the
application but the original software engineering team who
built the application is no longer with the company since
they were contractors.

We installed V8 on the same machine that has V5 installed.
But for some reason, the DSNs for V5 are being replaced by
the DSNs of V8 and the database fails to connect. On a
different machine, we installed V8 only and loaded have
successfully loaded the V5 database on V8 server. However,
the server gives out error messages saying that we should
rebuild the database for V8. Any thoughts about this will be
appreciated.

> Bob Melcos wrote in
> news:3fb28785.6a03.1681692777@sybase.com:
>
> > We currently have a vertical market application that
> > uses SQLAnywhere 5.0 database at it's backend. The
> > application is installed as a standalong app or as a
> > client server app depending on the client needs. We are
> > now upgrading the database engine to 8.0 and mirgrating
> > the database as well to 8.0. However, when we install
> > the ASA 8.0 on the client machine it destroys the 5.0
> > client libraries and so we are unable to connect to the
> > old database that needs to be converted. The database
> > conversion fails. Version 8 client libraries do not seem
> > to connect to version 5. Does any one know the fix?
> > Thanks.
>
> In version 6 we changed the communications protocols
> between the client and the server. Full details are
> available in the v6 documentation set available on
> ianywhere.com
>
> A couple of comments that may lead to a solution in your
> particular circumstances:
> - v5 databases can be loaded onto v8 servers. It may be
> possible for you to do all of your operations using v8
> - v8 installs in its own directory and both versions can
> co-exist. This means you can connect to a v8 server
> using the v8 libraries and a v5 server using the v5
> libraries.
>
> Are you the developer of the application or a user? If
> you are a user you should speak to your vendor for advice
> before proceeding. There are a number of changes to v8
> that may cause an application written for v5 to stop
> working correctly.
>
> /steve
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere
> Developer Community at www.ianywhere.com/developer
>


Glenn Paulley Posted on 2003-11-12 22:55:28.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere Version 5.0 Database Conversion To iAnywhere 8.0 Issue
References: <3fb28785.6a03.1681692777@sybase.com><Xns94319B5443375sricenospamianywhere@10.22.241.106> <3fb2acb8.18c6.1681692777@sybase.com>
In-Reply-To: <3fb2acb8.18c6.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpn-dub-190.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-190.sybase.com
Message-ID: <3fb2ba60$1@forums-1-dub>
Date: 12 Nov 2003 14:55:28 -0800
X-Trace: forums-1-dub 1068677728 10.22.120.190 (12 Nov 2003 14:55:28 -0800)
X-Original-Trace: 12 Nov 2003 14:55:28 -0800, vpn-dub-190.sybase.com
Lines: 101
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2066
Article PK: 4281

I cannot help with the connect/DSN problem, however I can offer some
insight into the message about rebuilding the database.

V8 (and V9) contain a number of significant performance enhancements
that are data-store related, including but not limited to:

- table page bitmaps and (much) faster sequential scan support
- new compressed B-tree indexes
- column histograms for selectivity estimation
- clustered indexes (8.0.2 and up)

It is true that a V8 server can run with a V5 database file. However,
without an unload/reload of the database, these performance enhancements
will not be there, and moreover performance may *suffer*, sometimes
significantly, because the V8 query optimizer relies on accurate
histogram statistics in order to make choose the access plan for each
individual query.

Glenn

Bob wrote:
> Steve, thanks for your insight. We are the developers of the
> application but the original software engineering team who
> built the application is no longer with the company since
> they were contractors.
>
> We installed V8 on the same machine that has V5 installed.
> But for some reason, the DSNs for V5 are being replaced by
> the DSNs of V8 and the database fails to connect. On a
> different machine, we installed V8 only and loaded have
> successfully loaded the V5 database on V8 server. However,
> the server gives out error messages saying that we should
> rebuild the database for V8. Any thoughts about this will be
> appreciated.
>
>>Bob Melcos wrote in
>>news:3fb28785.6a03.1681692777@sybase.com:
>>
>>
>>>We currently have a vertical market application that
>>>uses SQLAnywhere 5.0 database at it's backend. The
>>>application is installed as a standalong app or as a
>>>client server app depending on the client needs. We are
>>>now upgrading the database engine to 8.0 and mirgrating
>>>the database as well to 8.0. However, when we install
>>>the ASA 8.0 on the client machine it destroys the 5.0
>>>client libraries and so we are unable to connect to the
>>>old database that needs to be converted. The database
>>>conversion fails. Version 8 client libraries do not seem
>>>to connect to version 5. Does any one know the fix?
>>>Thanks.
>>
>>In version 6 we changed the communications protocols
>>between the client and the server. Full details are
>>available in the v6 documentation set available on
>>ianywhere.com
>>
>>A couple of comments that may lead to a solution in your
>>particular circumstances:
>>- v5 databases can be loaded onto v8 servers. It may be
>>possible for you to do all of your operations using v8
>>- v8 installs in its own directory and both versions can
>>co-exist. This means you can connect to a v8 server
>>using the v8 libraries and a v5 server using the v5
>>libraries.
>>
>>Are you the developer of the application or a user? If
>>you are a user you should speak to your vendor for advice
>>before proceeding. There are a number of changes to v8
>>that may cause an application written for v5 to stop
>>working correctly.
>>
>>/steve
>>
>>--
>>Stephen Rice
>>Technical Services Manager
>>iAnywhere Solutions
>>
>>- Please Post-
>>Whitepapers, TechDocs, and bug fixes are all available
>>through the iAnywhere
>>Developer Community at www.ianywhere.com/developer
>>

--
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


Breck Carter [TeamSybase] Posted on 2003-11-12 23:11:28.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: SQL Anywhere Version 5.0 Database Conversion To iAnywhere 8.0 Issue
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <3ke5rvcsf6b9bmmcppl8a8dfgqior1i0io@4ax.com>
References: <3fb28785.6a03.1681692777@sybase.com><Xns94319B5443375sricenospamianywhere@10.22.241.106> <3fb2acb8.18c6.1681692777@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 12 Nov 2003 15:16:55 -0800, bcarter.sentex.ca
Lines: 86
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Nov 2003 15:02:27 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Nov 2003 15:11:28 -0800
X-Trace: forums-1-dub 1068678688 10.22.108.75 (12 Nov 2003 15:11:28 -0800)
X-Original-Trace: 12 Nov 2003 15:11:28 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2067
Article PK: 4284

Yes, you should unload the database, dbinit a brand new one (4K page
size :), and then run the reload.sql file through dbisql.exe to reload
it.

Make sure you're using 8.0.2, not some 8.0.earlier version.

Use all-version-8 software to do the steps above, including dbunload.
You may have some issues on the reload step depending on whether there
are schema or data "idiosyncracies" to deal with... V5 to V8 is
crossing many years, after all :)... these issues can usually be dealt
with by edits to the reload.sql file.

After the new db is up and running check the OPTIMIZATION_GOAL
setting. 99% of the world's applications want 'all-rows', and
'first-row' can have a hugely bad effect on some queries.

Breck

On 12 Nov 2003 13:57:12 -0800, Bob Melcos wrote:

>Steve, thanks for your insight. We are the developers of the
>application but the original software engineering team who
>built the application is no longer with the company since
>they were contractors.
>
>We installed V8 on the same machine that has V5 installed.
>But for some reason, the DSNs for V5 are being replaced by
>the DSNs of V8 and the database fails to connect. On a
>different machine, we installed V8 only and loaded have
>successfully loaded the V5 database on V8 server. However,
>the server gives out error messages saying that we should
>rebuild the database for V8. Any thoughts about this will be
>appreciated.
>> Bob Melcos wrote in
>> news:3fb28785.6a03.1681692777@sybase.com:
>>
>> > We currently have a vertical market application that
>> > uses SQLAnywhere 5.0 database at it's backend. The
>> > application is installed as a standalong app or as a
>> > client server app depending on the client needs. We are
>> > now upgrading the database engine to 8.0 and mirgrating
>> > the database as well to 8.0. However, when we install
>> > the ASA 8.0 on the client machine it destroys the 5.0
>> > client libraries and so we are unable to connect to the
>> > old database that needs to be converted. The database
>> > conversion fails. Version 8 client libraries do not seem
>> > to connect to version 5. Does any one know the fix?
>> > Thanks.
>>
>> In version 6 we changed the communications protocols
>> between the client and the server. Full details are
>> available in the v6 documentation set available on
>> ianywhere.com
>>
>> A couple of comments that may lead to a solution in your
>> particular circumstances:
>> - v5 databases can be loaded onto v8 servers. It may be
>> possible for you to do all of your operations using v8
>> - v8 installs in its own directory and both versions can
>> co-exist. This means you can connect to a v8 server
>> using the v8 libraries and a v5 server using the v5
>> libraries.
>>
>> Are you the developer of the application or a user? If
>> you are a user you should speak to your vendor for advice
>> before proceeding. There are a number of changes to v8
>> that may cause an application written for v5 to stop
>> working correctly.
>>
>> /steve
>>
>> --
>> Stephen Rice
>> Technical Services Manager
>> iAnywhere Solutions
>>
>> - Please Post-
>> Whitepapers, TechDocs, and bug fixes are all available
>> through the iAnywhere
>> Developer Community at www.ianywhere.com/developer
>>

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com