I have learned about Windows 64-bit:
- On a 64-bit Windows machine, there are two different locations for programs to be installed:
- Programs
- For 64-bit programs
- Programs (x86)
- For 32-bit programs
- There are two different ODBC managers:
- the 64-bit version is accessed from Control Panel / Administrative Tools
- the 32-bit version may be found under [SysDrive]:\Windows\SysWOW64
- Oracle 10g had a problem with the parentheses in the “Programs (x86)” folder name, for which there were released a patch.
- The BI Development Studio (VS2008) which comes with SQL Server 2008 is 32-bit, and does not have easy access to 64-bit drivers. This goes also for the SSIS Package Designer.
- If you build for “Any CPU” it might still work.
- Or you could install both, and define ODBC connections with the same names using both of the ODBC managers.
- (more info coming soon…. maybe)
No comments:
Post a Comment