OLEDB Connection error (ORA 12541: TNS No Listener)

[siddharth_kulka]

Getting below error when testing an OLEDB connection on desktop.

Facts:

1. Trying to connect to Oracle DB on DEV server using OLEDB

2. The connection works when logged into actual DEV server but fails from desktop

3. Using

4. 64 Bit Driver installed on desktop

5. TNSNAMES.ORA with correct entries copied at the required location (Working for others)

6. Tried re-installing oracle client and driver to negate corrupt driver issue if any, but to no avail

Any idea, what else might be causing this? Any experiences?

Thanks,

Sid

[maxgro]

in your alias you have

SERVICE_NAME=

so service_name is blank

is it the same when you try the tnsping .... on the server?

[#3]

I had a similar problem when I first started using Qlikview, it was the drivers that hadn't installed properly.

Re installed it and hey presto it worked again!

[ToniKautto]

I have not found any other clue in our support knowledge, it always seems to boil down to Oracle installation or config

Did you check the links I posted earlier?

[siddharth_kulka]

The issue was resolved after copying over tnsnames.ora directly from the server.

Can't say it is was different from the one previously used, but somehow fixed the issue. Sadly, no rational behind the fix.

Thanks All!