topic Re: oledb in QlikView

oledb

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to connect to the oracle database but this time i am entering IP address into data source and using user name and password

but this is giving me the error as shown in the screenshot .. please do suggest me where am i going wrong ..

Re: oledb

Qrishna — Thu, 12 Apr 2018 16:46:15 GMT

Hi - have you created TNS entry in the connection file?

Re: oledb

smilingjohn — Thu, 12 Apr 2018 16:51:33 GMT

Hi Krishna thanks for the reply

what is that ?

I have one more OLEDBC connection which connects becuase it has data source name ..

but here i have IP address and hence it is giving me error ...

can you please explain me what is TNS entry and how do we do it

Re: oledb

Qrishna — Thu, 12 Apr 2018 16:57:28 GMT

For Oracle installation, There would be something like 'tnsnames.ora' file when you install oracle on a machine.

you have to edit that .ora file and add the entry for your connection.

the format is something like below

net_service_name=

(DESCRIPTION=

(ADDRESS=(protocol_address_information))

(CONNECT_DATA=

(SERVICE_NAME=service_name)))

so once you add your tns entry for your connection, the rest is same like we do for other connection.

Re: oledb

smilingjohn — Thu, 12 Apr 2018 17:05:25 GMT

sorry hard for me to understand this ..

if this is what i need to do then why is this connecting successfully for other OLEDB Databse...why is this giving me an error only when iam trying to enter the IP address ?

Thanks

Re: oledb

Qrishna — Thu, 12 Apr 2018 17:16:41 GMT

thats what i am saying, make a tns entry with ip address in the above format.

ADDRESS=(your IP Address)

Probably you old tns entry might be having

ADDRESS=(your DataSource name)

Re: oledb

smilingjohn — Thu, 12 Apr 2018 17:28:59 GMT

Hi Krishna ,

Okay will follow your steps ....

I am not able to how do we edit this tns ...This is the first time iam doing finding it diffcult ..