SQL Anywhere 9 32bit, 64bit installs

[former_SQLA_member1694871]

Have a quick question on this that I'm sure could be relatively easy to answer.

I'm setting up a new machine and it's my first 64bit machine. I'm going back and installing SQL Anywhere 9 - 12 on it. When I installed 9, I just by habit placed the 32bit install CD in the drive. Immediately it came up and asked me if I was sure I wanted to install the 32bit version on a 64bit OS. I told it go ahead because I need access to the 32bit components. However, I thought, I'll just install the 64bit version after that.

Well, I may not have thought it through completely. Long story short, I applied the EBF's to the 32bit install before I started trying to install the 64bit version. Dumb move on my part since I'm thinking "Oh crap!! Now I'm possibly downgrading components."

From what I can see, it looks like it tried to install the majority of components in the standard 64bit directory, but then it tried to install some others in the x86 (32bit) directories.

Everything started going downhill after that. Started getting some errors with some of the Java components. I didn't jot them down at the time. I ended up uninstalling everything due to the issues I was seeing.

I guess my question is.... Should I be able to install both the 32bit and 64bit versions of SQL Anywhere 9 on the same box? If so, is there anything I should be aware of before I start this over? I'm thinking for one thing that I shouldn't apply any EBF's until both base versions are installed.

Any thoughts would be greatly appreciated.

TIA

Jeff Gibson
Intercept Solutions - Sybase SQL Anywhere OEM Partner
Nashville, TN

[johnsmirnios]

If I recall correctly, the initial release of SQLAnywhere 9 didn't have 64-bit components: those were added in an EBF. Also, some things in version 9 were only 32-bit such as the Java GUI components, perhaps Mobilink, etc.

[VolkerBarth]

AFAIK, 9.0 GA was delivered with a 64-bit install for "IA64" (Itanium) but not for "X86_64", so that won't be installable on a X86_64 system. I guess the 9.0.1 or 9.0.2 maintenance releases contain a true X86_64 setup...

[former_SQLA_member1694871]

I should have been more specific. Both the 32 bit install and the 64 bit install are 9.0.2 installs. If it looks like components are going to step on each other, I'll probably just aim at the 32 bit install (at least for now).

At what point did Sybase start giving you the option to install both the 32bit and 64bit tools and components?

[VolkerBarth]

FWIW, on the question "How can I add components if I have already installed the latest EBF", see this FAQ... - I guess it should also allow to add 64-bit components if only 32-bit components have been installed so far. - However, I can't tell on the particular v9.0.2 situation...

[Breck_Carter]

I can't test this, but IMO the 64-bit install should put everything in the win64 subfolder, and it should not step on what's in win32 (the "I can't test this" is particularly frustrating, but I just don't have the download files and can't find them).

[Breck_Carter]

I agree on the "should also allow..." part, but this was early on in the history of shipping x64 as well as x32, so...

[Former Member]

Jeff: The 9.0.2 64-bit install basically contained the server and a few tools. Everything else was still 32-bit. You could get into trouble if the target directory for the 64-bit install is the same as the one you used for the 32-bit install. But if you keep them in separate locations, you should be able to EBF them independently.