Devart Forums

Hi

I am using dbForge for Oracle version 3.1.219 with windows 64 bit operating system and I have configured oracle instant client of 64 bit as mentioned at http://blogs.devart.com/dbforge/how-to- ... lient.html

But I am getting this error message while creating new connection when I use Conncet as : Default (OraHome)
Unable to load C:\oracle\instantclient_11_2\oci.dll. Please check that you use 64x version of Oracle client with 64x application.

And when I select Connect as : OraHome then I am getting error message
Can not find tnsnames.ora file

Could anyone please help me to resolve this issue?

Many thanks in advance.....

Sorry I have used

Connect as : Normal and
Home : Default (OraHome) or OraHome

Please make sure you have installed a 64-bit Oracle client but not a 32-bit one in case you are running a 64-bit operating system.

Yes you was right.

Now I have installed Oracle client of 64 bit, but now I am getting error
"ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

Oracle is installed on some remote machine.

I had edit registry as below.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"ORACLE_HOME"="C:\\oracle\\instantclient_11_2"
@=""
"ORACLE_HOME_NAME"="OraHome"
"ORACLE_GROUP_NAME"="Oracle - OraHome"
"NLS_LANG"="NA"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
"HOME_COUNTER"="1"
"DEFAULT_HOME"="OraHome"
"LAST_HOME"="0"
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
"NAME"="OraHome"
"PATH"="C:\\oracle\\instantclient_11_2"
"NLS_LANG"="NA"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"ORACLE_HOME"="C:\\oracle\\instantclient_11_2"
"ORACLE_SID"="srvc1"
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome"
"ORACLE_HOME_NAME"="OraHome"
"NLS_LANG"="NA"
"ORACLE_HOME_KEY"="Software\\ORACLE\\HOME0"

I have installed Oracle client of 64 bit, but now I am getting error
"ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

There is either not correctly specified server connection details in the tnsnames.ora file or this file is missing. In case it's missing, you would need to create it in the following path C:\\oracle\\instantclient_11_2

Hi Devart,

I'm having the same problem: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA!

Will I REALY have to change the tnsnames.ora file in ALL the computers that my company and my clients use?

Please make sure the server connection details in the tnsnames.ora file are specified correctly or create this file if needed.

I'm having the same problem



_____________
NOOR

Could you please provide us the following information:

1. Version of your operating system. Is it of x32 or x64?
2. Version of your Oracle client. Is it of x32 or x64?
3. Version of dbForge. Is it of x32 or x64?