user621292 wrote:If SQLPlus is working, you do have a working Oracle client. Is that 11g R2 client the only Oracle software on the system? If so, ODBC should be able to connect to anything that SQLPlus can, provided you're using the right ODBC connection manager (the control panel one for 64 bit Oracle clients, and c:\windows\syswow64\odbcad32.exe for 32 bit Oracle clients).
I have the exact same problem - my system details are
OS: Windows 7 Enterprise 64-bit
Oracle: 11g R2 (Client) [Oracle home C:\ora11g\product\11.2.0\client_1]
Other +ve details
- Oracle home defined in Registry path "Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1\ORACLE_HOME with value C:\ora11g\product\11.2.0\client_1
- ORACLE_HOME (manually) defined at the OS level as "C:\ora11g\product\11.2.0\client_1"
- TNS ping working properly and sqlplus connection working appropriately.
Could anyone tell me what could be the issue?
user621292 wrote:My oracle client is installed in c:\oracle\client\11gR2, and my path looks like this:
What should that be set to - the path where the TNSNAMES.ora file is residing?
[Another fact for my system - the TNSNAMES.ora file contains a single line pointing to ifile (on a network device) --> "ifile=p:\oracle\ADMIN\tnsnames.ora". I guess it would still be fine to put the path of the local TNSNAMES.ORA file (C:\ora11g\product\11.2.0\client_1\network\admin). correct?]
989585 wrote:It's possible that Oracle 10.2 client doesn't work properly on Windows 7 x64, as it was never released for that OS. That said it did work in Vista x64. The simplest thing to test might be to try installing an 11g client instead and see if that works. You can use a 32 bit client on an x64 OS, provided it's 32 bit applications that are using it.
I have the same issue on Windows 7 64 bit machine (Oracle 10.2.0 Client) - basic test just use the odbc 32 bit admin (C:\Windows\SysWOW64\odbc32.exe)
to connect to Oracle - fails with a ora-12154. I have read other posts regarding the PATH statement and they say
you cannot have ( ) in it as in the installed directory for software on 64 bit, for example: "Program files (x86)"
I don't have that in my path statement - I am not yet trying to use MS Access via the oracle driver - I am only trying to do the 'test' function in ODBC 32 client.
Any suggestions - TNS names is located in ADMIN folder as it usually is for Oracle 10.2.0 Client
I am reading that Oracle 10.2.0 client is 32 bit and won't work with network layers on 64 bit windows - This makes some sense to me since the Oracle 10.2.0 drivers are not available or showing in the OS supplied 64 bit version of ODBC. I will search for a compatibility statement regarding this client and the 64 bit OS but any suggestions are helpful as well.
Found one common reason for that: especially on Windows 7 64 bit Environments.
The problem is that the Oracle Client for some reason reacts badly if the full path (path + filename) contains round brackets.
This is usually the case, if you install a 32 bit application, because the Default Directory contains round brackets:
On Windows 7 it is for example: c:\program files (x86)\...
Solution: Install the executable of your application in a different path without round brackets. Ensure that the filename of your executable does not contain round brackets.