x86_64 - installing SQL Anywhere 9 on W2k8 Small Business Server

[James]

We recently upgraded our server from W2K SBS (Small Business
Server) to a new box running W2008 Small Business Server
Standard. The new edition of MS Exchange requires a 64 bit
environment, which has delayed our migrating our
POS/Inventory
system which relies on SQLAnywhere 9 (originally running in
a 32
bit mode). Our software partner sent us a 64 bit install
version of the SQLanywhere software and the EBF for 9.02.
However, we cannot get this to install correctly. As I
understood from previous posts, SQLAnywhere 9, the 64 bit
version will only run on the Intel Itanium. Our
configuration
is as follows: Processor, X3323, 2.5/1.3, 6M, XUPE0, with
16GB
RAM.

A post on the board mentioned:

The solution is usually just to start over (after
uninstalling and rebooting just to be sure you're
safe) and install the X86 one before applying your
EBF. Your platform is an X86_64 one and that
only became supported with a 9.0.2 EBF.

I tried reinstalling our original x86 version, but never saw
the
option or ability even with the EBF to create or opt for the
x86_64 version.

Is there something I am missing? What do we need to do to
get
SQLanywhere 9 running on our new server?

[Unknown]

James,

Your software partner may need to be involved here
but you have the 'formula' correct with

> The solution is usually just to start over (after
> uninstalling and rebooting just to be sure you're
> safe) and install the X86 one before applying your
> EBF. Your platform is an X86_64 one and that
> only became supported with a 9.0.2 EBF.

You seem to just be missing the EBF files for that last
step. With our standard installation, our (later released)
EBF can patch all the required file to give you the 64 bit
files for the x86_64 platform.

The caveat being, you need to download that EBF from
our downloads site. Either that, or have your vendor do
that for you and ship you the files.

If your vendor's installation does not follow our full install
methods our EBF installer may not detect any existing
installation and may not do anything useful. If that is your
issue, your vendor may need to send you a replacement
set of already 'patched' files.

Our technical support desk can assist you or your vendor
in making that happen.

<James> wrote in message news:49a438c6.216...@sybase.com...

[James]

Nick

I was given 9.0.2 EBF by our partner, but it does not seem
to change anything - which raises the question (possibly a
dumb one), are there two versions of the EBF - one for x86
and one for x64? The EBF they sent me, they sent me at the
same time we tried (unsuccessfully) to install the 64 bit
version of SQLAnywhere 9 (before we realized this would not
work due to the processor issue).

Thank you very much for your help!

[Unknown]

It sound like you have the wrong one. It could
be the one for the Itanium processor. There EBFs,
currently, for Itanium that would update an installation
for that processor to either build 3508 or build 3480.
Either of those would behave exactly the same way.

On the other hand, if you happen to have the right
EBF for this, then you may have the 64 bit software
installed and are just not using it. Did your EBF
create a x64 subdirectory? And if so are there
.EXE and .DLL files in there (server etc)?

That would typically be found in

c:\program files\sybase\Adaptive Server Anywhere 9.0\X64\

though your vendor's original installer could have put that
some other place.

Again your vendor should be able to identify what
they sent you and if they should have sent something
else. There are seperate EBFS for all 3 platforms
x86, x86_64 and Itanium and you will need to get the
correct ones.

<James> wrote in message news:49a5648f.3da...@sybase.com...

[James]

I think I have the wrong one. The EBF would not install as
it said it could not find the program.

I have forward your answer to our software partner.
Hopefully, now we can sort it out.

I will post here news of success or failure!

Thank you again.

[Unknown]

Maybe I can identify what you have.
What was given to you?
File name:
File size:
Any build/EBF information provided:

Are there win32 and x64 subdirectories inside that zip file?
Did you run the setup.exe from the x64 subdirectory?

You would need to have an ebf with a build number
of at least 3381. There was no x64 support before
that.

"Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@> wrote in
message news:49a5776d@forums-1-dub...

[James]

Nick

Our software partner checked your site and did not find an
EBF for x86_64 for 9.0.2 They did see x86 and x64. Are we
overlooking something?

[James]

We are all running out of ideas and wondering if there is
something in the configuration of Windows 2008 Small
Business Server that is disrupting the install.

Here are the two EBF's I have tried:

SA9_FULL_WIN_X64.902_EBF_3762
SA9_FULL_WIN32.902_EBF_3778

The original software we are hoping to use installed with
SQL Anywhere Studio 9.0.1 x86

We also tried to install

SQAnywhere 9.0.2 X64

I did check this folder:

And if so are there
> > .EXE and .DLL files in there (server etc)?
> >
> > That would typically be found in
> >
> > c:\program files\sybase\Adaptive Server Anywhere
> 9.0\X64\ >

I found no .EXE or .DLL files here (I did see some in the
ia64 folder). But the EBF for X64 will not install - it
tells me it cannot locate SQL Anywhere installed on the
computer - when we install the x64 program. Plus the x64
install version of SQLAnywhere wants to default install into
an x86 folder

[Unknown]

> The original software we are hoping to use installed with
> SQL Anywhere Studio 9.0.1 x86

That would be your problem. An EBF for 9.0.2 will
never patch a 9.0.1 install. We were assuming you had
some level of 9.0.2 first.

You will need to go 1 step to get to 9.0.2 first. That
called a maintenance release and the download is
identified on the web site as

SQL Anywhere Studio - Maintenance Release(English), Upgrade of 9.0.x to
9.0.2 (Software Only)

which whas posted Nov. 5th 2004. Getting that
and applying it first will get you to 9.0.2 at the first
release level (sometimes called GA).

After that your ebfs should apply.

<James> wrote in message news:49a5c0c5.48e...@sybase.com...

[James]

Nick,

I kinda feel like I am in the middle, playing a game of
broken telephone, so I want to make sure of a few things:

1). Will the 9.0.2 x64 SQLAnywhere run on a non Intel
Itanium system? (We are running Windows 2008 Small Business
Server with XEON processors in 64 bit mode. We have tried
to install this version and it does not work - and the EBF
for this version will not install - it claims not to be able
to find a valid install)

2) Do we need to install 9.0.2 SQLAnywhere for x86 (even
though we are running x64) and install the 9.0.2 EBF for
this version to get the magic x86_64 version?

So, I guess the 10 million dollar question is: which version
of the 9.0.2 SQLAnywhere do we need to install: x86 or x64?

[Unknown]

I understand. In fact I would have recommended that
you vendor contact our technical support. You may
want to suggest that yourself.

A1 - Yes. You just need to get the non-itanium stuff
to install. In fact it doesn't matter so much that
you get a 32bit or 64bit install, both should run;
only if you need the 64bit server will it be critical
to get the x64 stuff installed.

A2 - Yes. There was no 9.0.2 x64-only installer because
the x64 support did not come into being until a little
later on. [there was never any x64 in 9.0.1 at all]
So, for your purposes, your only option is to start
with a 9.0.2 x86 installation. That is your first step.

<James> wrote in message news:49a6c57e.661...@sybase.com...

[James]

The last email cleared it all up. We are now up and
running!

Thank you very much and have a nice weekend. I will now!

> I understand. In fact I would have recommended tha