I've searched the manual and this newsgroup, but as yet I've failed to find
a property which identifies the server as being 32-bit or 64-bit. Is there
one?

TIA,

Dave.

Hi Dave,

Try either:

SELECT PROPERTY('NativeProcessorArchitecture');

or

SELECT PROPERTY('ProcessorArchitecture');

Regards,

On 1/12/2010 1:50 PM, Dave Foulkes wrote:
--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

Look in the docs (link below) for the "ProcessorArchitecture" and
"NativeProcessArchitecture" properties:

http://dcx.sybase.com/index.html#110...s-perfapp.html

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Dave Foulkes wrote:

Hi Jeff,

Thanks for this. I'd looked at these in the documentation and hadn't quite
understood what they meant. Using 32bit SA on 32bit Windows I had:-

NativeProcessorArchitecture X86_64
ProcessorArchitecture X86

.... and with 64bit SA on 64bit Windows:-

NativeProcessorArchitecture X86_64
ProcessorArchitecture X86_64

I presume therefore that it's the ProcessorArchitecture that's telling me
that I'm running 32bit or 64bit SA; I'd read the documentation as meaning
that it was telling me what the physical processor architecture was.

Dave.

"Jeff Albion [Sybase iAnywhere]" <firstname.lastname (AT) ianywhere (DOT) com> wrote in
message news:4b4cc7e3 (AT) forums-1-dub (DOT) ..

It looks like it's the processor architecture that I require. I'd read the
documentation and hadn't realised what it meant.

Dave.

"Graeme Perrow [Sybase iAnywhere]"
<ReplyToNewsgroupOnly-gperrowNO (AT) SPAMianywhere (DOT) PLEASEcom> wrote

Just to be clear, ProcessorArchitecture is the processor type for which
the executable was built (i.e. whether it's 32-bit or 64-bit software).

NativeProcessArchitecture is the processor type on which the software is
running (i.e. whether it's a 32-bit or 64-bit processor). Note that you
will see X86_64 if you are running a 32-bit OS on a 64-bit processor.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Dave Foulkes wrote:

Ah - thank you - that explains it perfectly. Your explanation is far clearer
(to me) than the documentation.

Dave.

"Graeme Perrow [Sybase iAnywhere]"
<ReplyToNewsgroupOnly-gperrowNO (AT) SPAMianywhere (DOT) PLEASEcom> wrote