Strategy Intelligence Server Universal 9.x is certified for use with 32-bit ODBC drivers on Solaris, AIX and Linux. The use of only 64-bit drivers is certified on HP-UX. For the specifics about certified driver versions and database platforms, users should refer to the 'Certified and Supported Configurations' section in the Readme file.
Frequently, users run into connectivity problems or configuration problems with the use of incorrect driver types. The drivers shipped with Strategy are 32-bit on Solaris, AIX and Linux and 64-bit on HP-UX. However, when using drivers which are not shipped by Strategy, but supported for use (example Teradata driver), users will run into errors when an incorrect driver type is used. Example, if a 64-bit driver is used on Solaris, AIX or Linux to connect to a Teradata database.
The 'file' or 'objdump -a' commands can be used to check if a driver or library is 32-bit or 64-bit:
Example: To verify the driver type of the DataDirect Oracle driver shipped with the Strategy installation on Solaris, the following command can be used.
$ file /MicroStrategy/install/lib32/MYora22.so
The output of the above command is:
MYora22.so: ELF 32-bit MSB dynamic lib SPARC Version 1, dynamically linked, stripped
When the same command is run on a 64-bit library on Solaris,
$ file /MicroStrategy/install/lib/libM8SvrIT.so
libM8SvrIT.so: ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, stripped
Example with the objdump command:
Sample Code/Error
objdump -a libsapjcorfc.so
libsapjcorfc.so: file format aixcoff-rs6000
If a file is 64-bit, the output will be as below (note the 64 in the fileformat output):
Sample Code/Error
objdump -a libsapjcorfc.so
libsapjcorfc.so: file format aixcoff64-rs6000
