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.

[Clever_Anjos]

Would you mind posting your CONNECT statement?

Can you "tnsping" your server?

[Clever_Anjos]

sqldeveloper  is not a good way of testing, since it uses JDBC not ODBC

[krishna_2644]

Do the following:

[Anonymous]

I'm not sure what is the CONNECT statement, did you mean these?:

These are the files that are in the directory

and this is the tsnames.ora file

[Clever_Anjos]

Into your script there is a line beginning with CONNECT, I refer to this line

[Anonymous]

I haven't tried it on qlikview yet, because the file source doesn't appear yet. I think that it is because the odbc windows configuration isn't working

[Anonymous]

I don't get the same options that are shown in your picture, I think that the versions are different.
This is how it looks like on my computer:

[maxgro]

and when you test connection (button), what do you get?

[Anonymous]

I get this error: