Windows 7 / 64 bits and Oracle Explorer and Delphi RAD 2010

[fcarvalho]

How can I use DOA with Windows7/64x and Delphi 2010?

I have the following error message:

Initialization error
Could not initialize
"c:\...\oci.dll"
Make sure you have the 32 bits Oracle Client installed.

Thanks in advance.

 

[Marco Kalter]

You will need to install a 32 Bit Oracle Client. Delphi generates a 32 Bit application, so it cannot interface with a 64 Bit Oracle Client.

The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary. The 32 Bit client can coexist with a 64 Bit Oracle installation when installed in separate Oracle Home directories.

 

[fcarvalho]

OK, I instaled Oracle Instant Client Downloads
for Microsoft Windows (32-bit):http://www.oracle.com/technetwork/topics/winsoft-085727.html

and added the client path to PATH environment variable.

I have now the following error:

ORA-12154: TNS:could not resolve the connect identifier specified

What should I do?

SQL+ works fine and my TNSNAMES.ORA is:

# tnsnames.ora Network Configuration File: C:\app\Fernando\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.168.2.12)
)
)

 

[Marco Kalter]

Which client version did you install?

 

[fcarvalho]

I installed:

instantclient-basic-win32-11.2.0.1.0.zip

TNSPING is OK:

C:\Users\Fernando>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 03-MAR-2
011 12:33:35

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Ficheiros de par

 

[Mark R]

You now have 2 Oracle home directories. It is finding the x64 home for TNSPing but the x32 home is used for DOA. You can put a copy of the TNSNames.ora in the x32 home or you can try changing the Windows path to find the x32 path before the x64 path.