Question Re: SQL Anywhere 32 bit in Technology Q&A

SQL Anywhere 32 bit

Former Member — Thu, 25 Apr 2019 23:18:51 GMT

Will SQL Anywhere 32 bit server run on a 64 bit server. Will the client 32 bit work on a 64 bit client.

Re: SQL Anywhere 32 bit

VolkerBarth — Fri, 26 Apr 2019 01:37:26 GMT

Yes and yes.

For more details, see this FAQ on why it is usually more reasonable to run the 64-bit server on a 64-bit OS.

As to the client software: You will need the according bitness the client applications require, so if you are using, say, a 32-bit ODBC application, it will require the 32-bit ODBC client software. Therefore running 32-bit clients on a 64-bit OS is absolutely common.

Re: SQL Anywhere 32 bit

BudDurland — Fri, 26 Apr 2019 08:00:07 GMT

What Volker said. Plus, it's also common to have the server running 64 bit and clients 32 bit.

Re: SQL Anywhere 32 bit

Breck_Carter — Fri, 26 Apr 2019 08:44:34 GMT

server running 64 bit and clients 32 bit

Slightly-off-topic, but... For proxy connections from SQL Anywhere 17 to V9 and earlier remote servers running on 32 bit SQL Anywhere engines, ODBC connections via DRIVER=SQL Anywhere 17 don't seem to work; try using an older driver, e.g., DRIVER=SQL Anywhere 16.

In this case, it's hard to define who's the client and who's the server, but the annoyance is clear 🙂

Re: SQL Anywhere 32 bit

chris_keating — Fri, 26 Apr 2019 10:28:30 GMT

There was a problem starting SQL Anywhere 17 on 32 bit platforms. The engine would report "Unable to initialize AddressSpaceManager" during startup. The fix was made in build 4962 or newer. You could workaround the issue by setting a -ch around 3G.

Re: SQL Anywhere 32 bit

Breck_Carter — Fri, 26 Apr 2019 14:05:03 GMT

SQL Anywhere 17 on 32 bit platforms

Is that specific to actual 32-bit platforms, as opposed to the 32-bit version of SQL Anywhere 17 on a 64-bit copy of Windows?

FWIW SQL Anywhere 17.0.9.4882 seems to run OK when you start it via C:\\Program Files\\SQL Anywhere 17\\Bin32\\dbsrv17.exe on Windows Pro 64-bit.

Re: SQL Anywhere 32 bit

VolkerBarth — Fri, 26 Apr 2019 14:37:24 GMT

Hm, I have also used several v17 versions on 32-bit Windows without issues... I guess starting with 17.0.0 up to 17.0.7...

Re: SQL Anywhere 32 bit

Breck_Carter — Fri, 26 Apr 2019 15:09:02 GMT

> on 32-bit Windows

Same question for you: actual 32-bit Windows, or bin32\\dbsrv17.exe on 64-bit Windows?

Re: SQL Anywhere 32 bit

chris_keating — Fri, 26 Apr 2019 15:30:06 GMT

Correct, it is specific to running 32 bit engines on 64 bit operating systems. Thanks for catching that. We were never able to reproduce the behavior but had a least one deployment environment where this issue would occur frequently.

Re: SQL Anywhere 32 bit

VolkerBarth — Fri, 26 Apr 2019 15:33:26 GMT

As stated, a 32-bit OS... Old hardware, y'know, just for tests.

Re: SQL Anywhere 32 bit

VolkerBarth — Fri, 26 Apr 2019 15:35:37 GMT

There was a problem starting SQL Anywhere 17 on 32 bit platforms.

Correct, it is specific to running 32 bit engines on 64 bit operating systems.

Hm, Chris, now I'm puzzled - do you relate to a 32-bit or 64-bit OS w.r.t that particular issue...?

Re: SQL Anywhere 32 bit

Breck_Carter — Sat, 27 Apr 2019 12:38:49 GMT

OK, for your information: I test and support the Foxhound database running on 32-bit SQL Anywhere engines, and have never had any problems with V16 (previously) or V17 (now).

However, for several years Foxhound has only supported running in Windows 64-bit environments.

( so why support 32-bit engines? because it's a handy Dead Chicken Solution for legacy ODBC connectivity 🙂