error while using odbc stage

Hema.k · Post by **Hema.k** » Fri Sep 09, 2011 12:35 am

Hi All,

My requirement is to etract data from oracle database.
I'm able to view the data from my source(oracle) using oracle stage.
but when i use ODBC stage am not able to view the data.. its throwing the below error message

##F IIS-DSEE-TDOD-00004 07:22:51(000) <main_program> Fatal Error: Could not connect to datasource?? (-1; bi_etl; EUPCRM; [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor)

Could you please suggest me to resolve this.

Regards,
Hema K

arvind_ds · Post by **arvind_ds** » Fri Sep 09, 2011 2:24 am

Does the below files contains the entry for your odbc source?

(1) .odbc.ini
(2) uvodbc.config

If not, make sure to update these two before using ODBC stage.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 09, 2011 5:07 am

It appears that the entry in tnsnames.ora for this database does not have a resolvable SID.

qt_ky · Post by **qt_ky** » Sun Sep 11, 2011 12:34 am

Make sure the information for the .odbc.ini file entry matches what is in the tnsnames.ora file from the oracle client on your server: HostName (or IP), PortNumber, SID. It sounds like there is a mismatch. Or just use the Oracle stage instead since you can already view data using it.