topic Re: Help with Oracle ODBC configuration in QlikView

Help with Oracle ODBC configuration

Anonymous — Wed, 27 May 2015 20:25:33 GMT

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.

Re: Help with Oracle ODBC configuration

Clever_Anjos — Wed, 27 May 2015 20:38:30 GMT

Would you mind posting your CONNECT statement?

Can you "tnsping" your server?

Re: Help with Oracle ODBC configuration

Clever_Anjos — Wed, 27 May 2015 20:38:59 GMT

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

Re: Help with Oracle ODBC configuration

Qrishna — Wed, 27 May 2015 20:42:19 GMT

Do the following:

Re: Help with Oracle ODBC configuration

Anonymous — Wed, 27 May 2015 20:48:02 GMT

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

Re: Help with Oracle ODBC configuration

Clever_Anjos — Wed, 27 May 2015 21:07:27 GMT

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

Re: Help with Oracle ODBC configuration

Anonymous — Wed, 27 May 2015 21:25:34 GMT

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

Re: Help with Oracle ODBC configuration

Anonymous — Wed, 27 May 2015 21:43:32 GMT

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:

Re: Help with Oracle ODBC configuration

maxgro — Wed, 27 May 2015 22:31:07 GMT

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

Re: Help with Oracle ODBC configuration

Anonymous — Thu, 28 May 2015 12:06:08 GMT

I get this error:

Re: Help with Oracle ODBC configuration

Thu, 28 May 2015 12:42:29 GMT

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

Re: Help with Oracle ODBC configuration

Anonymous — Fri, 29 May 2015 12:26:49 GMT

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

Re: Help with Oracle ODBC configuration

Clever_Anjos — Fri, 29 May 2015 13:35:08 GMT

What this command line returns?

tnsping sca

Re: Help with Oracle ODBC configuration

Anonymous — Fri, 29 May 2015 15:43:30 GMT

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

Re: Help with Oracle ODBC configuration

maxgro — Fri, 29 May 2015 17:07:30 GMT

open a dos prompt

ping the host of your oracle db

ping 158.170.53.248

ok?

tnsping the conn desc qlikview in tnsnames.ora

tnsping qlikview

ok?

connect to db from the dos prompt

sqlplus /nolog

conn username/password@qlikview

ok?

Re: Help with Oracle ODBC configuration

Anonymous — Mon, 05 Oct 2015 13:32:46 GMT

Follow the steps of this Oracle ODBC connection guide