Question Re: SQL Anywhere 9 32bit, 64bit installs in Technology Q&A

SQL Anywhere 9 32bit, 64bit installs

former_SQLA_member1694871 — Fri, 08 Feb 2013 19:33:54 GMT

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

Re: SQL Anywhere 9 32bit, 64bit installs

johnsmirnios — Fri, 08 Feb 2013 21:14:13 GMT

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.

Re: SQL Anywhere 9 32bit, 64bit installs

VolkerBarth — Sat, 09 Feb 2013 07:47:03 GMT

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

Re: SQL Anywhere 9 32bit, 64bit installs

former_SQLA_member1694871 — Sat, 09 Feb 2013 19:05:35 GMT

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?

Re: SQL Anywhere 9 32bit, 64bit installs

VolkerBarth — Sun, 10 Feb 2013 10:05:10 GMT

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

Re: SQL Anywhere 9 32bit, 64bit installs

Breck_Carter — Sun, 10 Feb 2013 10:48:55 GMT

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

Re: SQL Anywhere 9 32bit, 64bit installs

Breck_Carter — Sun, 10 Feb 2013 10:50:31 GMT

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

Re: SQL Anywhere 9 32bit, 64bit installs

Former Member — Tue, 12 Feb 2013 11:18:32 GMT

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.