using 32 bit SQL server ODBC on 64 bit system

Microsoft has a SQL server either as 32 bit or 64bit, however the 64bit contains both 32bit AND 64 bit.

are there any MSI packages containing the 32 bit AND 64 bit version of the ODBC connector ?

i.e. the install package decides by itself which version to ins开发者_如何学Gotall`?

Unfortunately, MSI is not very good at providing a single installer that works for both 32-bit and 64-bit systems. The 32-bit installer will not be able to write to the locations where the 64-bit files should be stored, and the 64-bit installer will not start on a 32-bit system.