0

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?

asked Jun 19, 2013 at 11:49

2 Answers 2

0

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

answered Jun 19, 2013 at 17:25
0
0

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:

Link

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. :)

Glorfindel
2,2095 gold badges19 silver badges26 bronze badges
answered Jun 20, 2013 at 4:29

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.