DTS error -Orcale Client & networking components not found
-
Hi,
I am having this error "Oracle CLient and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation." when running a DTS (logged in as the SQLServer service account). I also checked ODBC and it also gave me that error. Do I need to install something?
Thanks!!
-
I always install the targeted Oracle client-software on the server. Then it works fine.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I have to install Oracle client or just the Microsoft ODBC for Oracle driver? Thanks a again!
-
I install de minimal client and add the windows-components-installation to be able to use ole-db. ODBC is already available with the minimial instalation.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Where do i get the windows-components installation? My server is NT.
-
Now I'm getting this error --"Microsoft OLE DB Provider for ODBC Drivers". What's wrong? Thanks!!
-
You should run OUI and perform a custom installation. There you can check Windows-components.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks you very much!!
-
Hi again! I can now run the package manually but when I tried running it through a scheduled job, it's giving that error again. Microsoft ODBC for Oracle "Oracle client and netowrking components not found...You will be unable to use this driver until these componets have been installed" But I have installed oracle client and odbc already. Thanks!
-
did you define the ODBC as system-dsn ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
yes i did. i am actually running the job as the sqlservice agent account.
-
I suppose your sqlserver-agent-account is member of windows-server-administrators group ?
If not, you'll need to give it access to the Oracle-folders and reg-keys.
You might also want to login on the server itself as sqlserver-agent-account and run the package. Maybe this gives more detailed info.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Yes, the sqlserver agent account is member of the windows admin group, I am logged in as the sqlserver agent account. I can run the package fine manually but when I ran it through a job, it fails. The sqlserver agent account has also the System Admin rights on the SQLServer. Do I need to reboot the server after the Oracle client installation? or do I need to update my ODBC for SQLServer?? thanks!
-
When I install new basic software (Oracle client in this case) I alway reboot.
Especialy when installing on a server. This way I can better relate a problem to a last install or not. Just to be sure all components get activated when I want to and not at unplanned downtime.
If you can run it when you are logged in as sqlagent-service-account, it should also work when scheduled.
Maybe the reboot solves this case.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
How did u run your DTS job ? If u ran it from SQL EM on your client then DTS looks for the Oracle client components on your PC, however if the job is scheduled then it looks for the Oracle client stuff on the server - confusing hey!.
The thing to do is to get the 8i/9i client CD and install using OUI on the server machine (make sure you install OLEDB, ODBC etc...), then configure tnsnames.ora. Schedule the job and test, or better still connect to the server using terminal services, at least then you can guarantee that you will be using the server installation of the client.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply