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.

Changing 64bit database to 32Bit

4 posts in General Discussion Last posting was on 2010-02-03 20:56:56.0Z
Aron Posted on 2010-02-02 21:33:24.0Z
Sender: 23a.4b6899a2.1804289383@sybase.com
From: Aron
Newsgroups: ianywhere.public.general
Subject: Changing 64bit database to 32Bit
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b689a24.246.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Feb 2010 13:33:24 -0800
X-Trace: forums-1-dub 1265146404 10.22.241.41 (2 Feb 2010 13:33:24 -0800)
X-Original-Trace: 2 Feb 2010 13:33:24 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7880
Article PK: 6912

BH

Hi, we have a database file that was built on a 64bit
computer. Now we've moved it to a 32bit computer, and when I
test connection in the ODBC, it gives me a message that the
file was created on a different version. Is there a way to
rebuild it to a 32bit?

Thanks
Aron


Jeff Albion [Sybase iAnywhere] Posted on 2010-02-02 22:15:40.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Changing 64bit database to 32Bit
References: <4b689a24.246.1681692777@sybase.com>
In-Reply-To: <4b689a24.246.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b68a40c$1@forums-1-dub>
Date: 2 Feb 2010 14:15:40 -0800
X-Trace: forums-1-dub 1265148940 10.22.241.152 (2 Feb 2010 14:15:40 -0800)
X-Original-Trace: 2 Feb 2010 14:15:40 -0800, vip152.sybase.com
Lines: 37
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7882
Article PK: 6913

Hi Aron,

The "File was created with a different version" is a database server /
database file version incompatibility, not a 32-bit/64-bit
incompatibility. In general, our database is cross-platform compatible
across 32-bit/64-bit and even big-endian/little-endian systems, for the
same major database server version.

This error message will be displayed for instance if you try and run a
version 9 (or previous) database on a version 10 or 11 database server.
Instead, you must rebuild the database file for it to be compatible:
http://dcx.sybase.com/index.php#1101en/sachanges_en11/unloading-reloading-upgrading-newjasper.html*v10upgrade-b-3548731

1. Which version of the software was used to create the database?
2. What version of the software is installed on the new machine?

Regards,

On 2/2/2010 4:33 PM, Aron wrote:
> Hi, we have a database file that was built on a 64bit
> computer. Now we've moved it to a 32bit computer, and when I
> test connection in the ODBC, it gives me a message that the
> file was created on a different version. Is there a way to
> rebuild it to a 32bit?
>
> Thanks
> Aron

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Aron Posted on 2010-02-03 20:56:56.0Z
Sender: 23a.4b6899a2.1804289383@sybase.com
From: Aron
Newsgroups: ianywhere.public.general
Subject: Re: Changing 64bit database to 32Bit
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b69e318.2ca1.1681692777@sybase.com>
References: <4b68a40c$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Feb 2010 12:56:56 -0800
X-Trace: forums-1-dub 1265230616 10.22.241.41 (3 Feb 2010 12:56:56 -0800)
X-Original-Trace: 3 Feb 2010 12:56:56 -0800, 10.22.241.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7883
Article PK: 6915

BH

Thank you very much. Yes this was the issue. Different SQL
version.

> Hi Aron,
>
> The "File was created with a different version" is a
> database server / database file version incompatibility,
> not a 32-bit/64-bit incompatibility. In general, our
> database is cross-platform compatible across
> 32-bit/64-bit and even big-endian/little-endian systems,
> for the same major database server version.
>
> This error message will be displayed for instance if you
> try and run a version 9 (or previous) database on a
> version 10 or 11 database server. Instead, you must
> rebuild the database file for it to be compatible:
>
http://dcx.sybase.com/index.php#1101en/sachanges_en11/unloading-reloading-upgrading-newjasper.html*v10upgrade-b-3548731
>
> 1. Which version of the software was used to create the
> database? 2. What version of the software is installed on
> the new machine?
>
> Regards,
>
> On 2/2/2010 4:33 PM, Aron wrote:
> > Hi, we have a database file that was built on a 64bit
> > computer. Now we've moved it to a 32bit computer, and
> > when I test connection in the ODBC, it gives me a
> > message that the file was created on a different
> > version. Is there a way to rebuild it to a 32bit?
> >
> > Thanks
> > Aron
>
> --
> Jeff Albion, Sybase iAnywhere
>
> iAnywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals SQL
> Anywhere Patches and EBFs :
>
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case :
> http://case-express.sybase.com/cx/


"Kory Hodgson (Sybase iAnywhere)" <khodgson Posted on 2010-02-02 22:11:44.0Z
From: "Kory Hodgson (Sybase iAnywhere)" <khodgson@A_SPAM_FREE_sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Changing 64bit database to 32Bit
References: <4b689a24.246.1681692777@sybase.com>
In-Reply-To: <4b689a24.246.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b68a320$1@forums-1-dub>
Date: 2 Feb 2010 14:11:44 -0800
X-Trace: forums-1-dub 1265148704 10.22.241.152 (2 Feb 2010 14:11:44 -0800)
X-Original-Trace: 2 Feb 2010 14:11:44 -0800, vip152.sybase.com
Lines: 21
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7881
Article PK: 6914

Aron,

SQL Anywhere databases are fully portable across platforms on the same
version. Likely you are trying to start a database created with a
different version of SQL Anywhere than the one you are using.

Thanks

Kory

Aron wrote:
> BH
>
> Hi, we have a database file that was built on a 64bit
> computer. Now we've moved it to a 32bit computer, and when I
> test connection in the ODBC, it gives me a message that the
> file was created on a different version. Is there a way to
> rebuild it to a 32bit?
>
> Thanks
> Aron