ORA-06413 Connection not open

ChuyenGia
ChuyenGia used Ask the Experts™
on
Hi all,

I use OracleXE 10g and Visual Studio 2010. I can connect to Oracle from CSE or A5M2 database tool. I also connect to Oracle by code use OleDB. But when I add connection to Server Explorer in Visual Studio 2010 I got ORA-06413 Connction not open error. What is wrong? How can I fix this problem?

I'm using Win7 64
Thanks a lot.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi,

Have no idea how Visual Studio works but here's a guess :
Are you using Microsoft's ODBC driver to connect to your database ? Personally I have always had problems with it. I use instead the one from Oracle.

Here you have anything that might be useful with Visual Studio :
http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html


Cheers,
P
Top Expert 2009

Commented:
I've never heard of either of your database tools, CSE or A5M2.

Believe it or not, it is probably due to the path that your Oracle is in. Since you are on Windows 64, then when you install a 32-bit program, it goes under Program Files (x86). The parens have been known to cause warnings / issues with certain versions of Oracle. But I thought it was resolved in 10g, so I'm curious if you also have an older Oracle client installed.

One option is to try the new Oracle 11g Express Edition beta. The other is to install under somewhere besides Program Files (x86) without the parens. I personally install my Oracle(s) under C:\Oracle or C:\Oracle32
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
I found this links,
http://msdn.microsoft.com/en-us/library/xexk8kx3%28v=vs.71%29.aspx
http://social.msdn.microsoft.com/Forums/en-US/netfx64bit/thread/9296e57a-b89e-4165-b25a-db58ceaa9ee0/

as I understand, your code comes from x86 previously, and interop was build.
Try to remove your old files like interop.*?
since your now on 64, build a clean solution and project.

Commented:
I'm not sure the server explorer supports oracle by itself.  I would install Oracle's Developer Tools for Visual Studio.  It has a very similar navigator tool:

http://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html
Top Expert 2009

Commented:
It does support it. What he shows is an ORA- error which comes from the Oracle driver itself.

Commented:
Then maybe the updated driver in the ODT pack will work over the one that is currently being used?  And I mispoke, the ODT does not add a similar navigator tool - it adds it (or to mrjoltcola's point of support already being there, it enhances it).

Admittedly, IJZ has posted some pretty good links with good possibilities.

Author

Commented:
OracleXE is not work fine on Win7x64, so that I change to use 32bit OS and it's work fine.
Thanks a lot.

Commented:
Good to hear.  Credit to IJZ and his first link then?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial