problem with oracle OCI stage
Posted: Wed Feb 28, 2007 9:06 am
I am giving DSN name, user id and password in the oracle OCI stage. When i give the DSN name, iam getting the following error:
CTA_ASR..Oracle_OCI_8i_5: ORA-12154: TNS:could not resolve service name
CTA_ASR..Oracle_OCI_8i_5.DSLink1: DSP.Open GCI $DSP.Open error -100.
So, i removed the DSN name and gave TNS name in the same filed...then i get the following error:
CTA_ASR..Oracle_OCI_8i_5: Table Name is a required link property for Link DSLink1
CTA_ASR..Oracle_OCI_8i_5.DSLink1: DSP.Open GCI $DSP.Open error -100.
I don't know where i have to give table name. Always the DNS field is looking for a TNS name...if i give any other thing, iam getting the first error i mentioned.
Any hints plzz........!
CTA_ASR..Oracle_OCI_8i_5: ORA-12154: TNS:could not resolve service name
CTA_ASR..Oracle_OCI_8i_5.DSLink1: DSP.Open GCI $DSP.Open error -100.
So, i removed the DSN name and gave TNS name in the same filed...then i get the following error:
CTA_ASR..Oracle_OCI_8i_5: Table Name is a required link property for Link DSLink1
CTA_ASR..Oracle_OCI_8i_5.DSLink1: DSP.Open GCI $DSP.Open error -100.
I don't know where i have to give table name. Always the DNS field is looking for a TNS name...if i give any other thing, iam getting the first error i mentioned.
Any hints plzz........!