Re: SV: Oracle 32-bit and 64-bit client on Windows

From: Kim Berg Hansen <kibeha_at_gmail.com>
Date: Wed, 30 Oct 2013 14:45:57 +0100
Message-ID: <CA+S=qd2TA8UvoLYAfbQOw-MH617AXoL2CJMmAb-FTWoP9TotvQ_at_mail.gmail.com>

I would say it depends on *how* your program searches for the correct client.
If you open a command prompt and type sqlplus, you will get the sqlplus of the client installation that is first in the PATH environment variable.

But if for example your program uses ODBC connections, the 32-bit Oracle client will have registered itself with windows as a 32-bit ODBC driver, and the 64-bit client will have registered as a 64-bit driver and the information is in the registry and not dependent on paths. You can then create ODBC datasources using C:\Windows\SysWOW64\odbcad32.exe or C:\Windows\system32\odbcad32.exe respectively, and when you run a 32-bit program it can only see datasources created in the 32-bit environment and when you run a 64-bit program it can only see datasources created in the 64-bit environment.

Other programs might likewise use registry information rather than the path. Or some programs might allow environment variable ORACLE_HOME to overrule and then you can set that environment variable individually at startup of your different programs.

32-bit and 64-bit can coexist - it is more a matter of how your program use the Oracle Client Software. OCI libraries? JDBC or ODBC datasources? OLE DB? (If the latter then I think I recall that OLE DB there can only be one in a windows installation, it cannot be in multiple homes.)

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Wed, Oct 30, 2013 at 2:17 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:

> Are you sure about that. Since both homes are in the "path", wouldn't
> the application find the Oracle client listed first?
> >>> Niels Jespersen <NJN_at_dst.dk> 10/30/13 3:37 AM >>>
> 32-bit and 64-bit client coexist fine. 32-bit applications only "sees"
> the 32-bit client and 64-bit apps only "sees" 64-bit clients. Have both
> in the path.
> /Niels
>
> -----Oprindelig meddelelse-----
> Fra: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] På vegne af Jeffrey Beckstrom
> Sendt: 29. oktober 2013 20:13
> Til: oracle-l-freelists; oracle-db-l
> Emne: Oracle 32-bit and 64-bit client on Windows
>
> We have a need to have both the 32 and 64 bit clients installed on a
> Windows 7 PC. In order for the 32-bit application to access the 32-bit
> Oracle client, due we have to alter the search "path" prior to invoking
> the 32-bit application or will it magically know to use the 32-bit
> Oracle dll's?
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> Information Systems
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>
>
>
>
> .
> --
>
> https://access.seg.att.com/redir/?1hKCMC--UrhKDuVEV78CM0jIvY-l9QU03w0BJ8_BoXo_OVVK_8K6zBV55BeXNKVK0z058kDO1kSCUUqejqbbPaabPyr1JxMSc1B8Qg1yeSfYQgcFBO4FCy3o86y1NwKgBcQgmfBY9Cy2I3h00IE8lckdPYfDyN-OwrhdECQrFTKqemmjoeTM
>
>
>
>
>
>
> .--
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 30 2013 - 14:45:57 CET