oledb

[smilingjohn]

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 ..

[Qrishna]

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

[smilingjohn]

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

[Qrishna]

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.

[smilingjohn]

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

[Qrishna]

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)

[smilingjohn]

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 ..