Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle".

I am using "Export Data..." option from Task menu.

I get to connect to the source database (SQL Server) but when I try to connect to the destination database (Oracle) using "Microsoft OLEDB Provider for Oracle" option, I get the following error.

"ORA-06413: Connection not open"

I also checked my connections (tnsnames.ora) and I am able to successfully connect using SQL Developer to my local Oracle XE instance. My OS is Windows 8 running on a x64 machine.

Any guess what could be the problem here?

share|improve this question
add comment

2 Answers

I would try installing the Oracle Data Access Components (ODAC).

You will be able to download them from this link. http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

share|improve this answer
    
Thanks Mark. I will try with your suggestion as well. –  Ajay Jun 20 '13 at 4:30
add comment

I found an answer to this issue on these forum posts:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ab662d63-6385-4f73-b27f-d526048f601f/connecting-to-oracle-on-64bit-x64-machine

and on this:

http://blogs.msdn.com/b/debarchan/archive/2009/02/04/good-old-connectivity-issue.aspx

The problem is with the "(x86)" string in the folder name in which SQL Server DTS is installed. I just copied/pasted the whole "Microsoft SQL Server" folder from "Program Files (X86)" to "C:\" and ran the DTSWizard.exe, and it worked. :)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.