Help with Oracle ODBC configuration

[Anonymous]

Dear community:

I'm having a real hard time setting up the oracle odbc configuration on widows 7 64bit

I have followed every step specified on this link:

Connectivity to Oracle Database

and when I try to test the connection, I'm getting the following error:

Can anybody help me please?

PS: I've tested the connection with sqldeveloper and it works just fine.

[#2]

Do you have 32 bit and 64 bit driver installed  ?   if so did you copy the TNS file in both the directory ?

Can you please let me know the folder locations of the TNS file

[Anonymous]

C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN

[Clever_Anjos]

What this command line returns?

tnsping sca

[Anonymous]

I finally could configure the windows odbc administrator, but now, when I test the connection there, I get the Following Error:
SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS: Could not resolve service name

[maxgro]

0)

open a dos prompt

1)

ping the host of your oracle db

ping 158.170.53.248

ok?

2)

tnsping the conn desc qlikview in tnsnames.ora

tnsping qlikview

ok?

3)

connect to db from the dos prompt

sqlplus /nolog

conn username/password@qlikview

ok?

[Anonymous]

Follow the steps of this Oracle ODBC connection guide