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
error while using odbc stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius