user620833 wrote:Yes, the entire 9i client will work. Mixing and matching might work, or it might not. The DLLs are built against a specific version of Oracle client and rely on it for its actual Oracle connectivity. Changing that can break things in unexpected an horrific ways. In some cases it just won't work at all.
So you don't see an issue with using the entire 9i client, but do see an issue with mixing and matching files with an 11g client (i.e. dropping 9i's sqora32.dll).
I'm not sure what is meant by new version of Windows? Regardless of the Windows versions, they support 32bit. What do you mean, thanx?The 9i client was never tested on Windows 7 for example. If something doesn't work in Windows 7 (and given how long it's been it's pretty likely) then you're just stuck because Oracle isn't going to fix it. XP is about to hit end of life on Microsoft's end, so it's not a platform you can stay on forever. Also I'm not sure what would happen if you tried to install 9i into a 64 bit version of Windows 7, whereas the 32 bit 11g client works in that scenario. The end of the 32 bit OS itself is coming in the near future, so that's another scenario to be concerned about.
Also, if the same dll is used for ODBC connections, i.e. same name, isn't the last client install going to "trump" that file registeration? I see 2002-2011 file dates based on 9,10,11 installs. All different file sizes.IIRC if you install two Oracle clients in two different homes, both appear as ODBC drivers for connections. Don't have that setup right now so I can't confirm it.