Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Would you mind posting your CONNECT statement?
Can you "tnsping" your server?
sqldeveloper is not a good way of testing, since it uses JDBC not ODBC
Do the following:
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
Into your script there is a line beginning with CONNECT, I refer to this line
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
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:
and when you test connection (button), what do you get?
I get this error: