Hello Gurus,
I hope you can help me with the odd message I am getting all of a sudden.
I am trying to run a very simple job that reads from a sequential file and writes to an oracle DB via ODBC stage. No much transformations either but the job fails with the error message: TNS:Protocol adapter not loadable.
I know this is an oracle message but what is surprising me is that I am able to connect to the DB without any problem. Also if I specify a new Datasource in the ODBC stage the job runs fine.
Can you please shed some light on how to fix this issue? I have lot of jobs that read from the current DataSource (which is throwing the error), changing that would mean changing all the jobs.
TNS: Protocol adapter not loadable
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Re: TNS: Protocol adapter not loadable
Probably the Database settings won't be properly set in case if you are running those jobs for the first time.
Please check with the server.
Please check with the server.