Link to home
Start Free TrialLog in
Avatar of fairrington
fairrington

asked on

ORA-06413 Connection not open

Help!

I have a 64 bit Windows 2008 R2 SP1 server (Citrix XenApp) and I'm trying to connect to an Oracle database 10g through a 32 bit ODBC connection (Microsoft ODBC for Oracle).  I'm receiving an ORA-06413 Connection Not Open error.

The App is an Excel 2010 (32 bit) macro using ADODB to open an ODBC connection.
   Dim ConString, SQL
    Dim Conn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
   
    Set Conn = New ADODB.Connection
    ConString = "Provider=MSDAORA.1;Data Source=prtl;User ID=rate;Password=******"
   
    Conn.Open ConString

I get the error as soon as I try to open the connection.  I've also tried creating a connection in Access 2003 via ODBC and I get the same error.

This same Excel spreadsheet works on a Windows 2003 R2 machine running Excel 2003.  However it's using a different Oracle Client (6i) and it's pure 32 bit.

The Oracle client that was installed is the 32 bit Oracle Developer Suite 10g (10.1.2.0.2).
 
I've verified that TNS is working using tnsping as well as I can connect to SQL*plus.

I found a bunch of old articles on this error, but nothing is panning out.  The only thing I've tried is copying the oracle folder in (x86) to program files and then I removed the (x86) reference in the registry under the Oracle key.  That didn't work.

Thanks in advance for any help,

Steve Cross
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Can I assume you installed the 32Bit Oracle drivers?
and used the 32Bit ODBC Administrator to create and test the DSN and everything worked?

http://support.microsoft.com/kb/942976
ASKER CERTIFIED SOLUTION
Avatar of fairrington
fairrington

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I don't have any Oracle ODBC drivers installed anywhere so I cannot tell you exactly where it is.

It should be an option when you configure the DSN.
>>Figured it out by myself.

What was the solution to this problem?
what was the solution I'm having the same problem?
Avatar of fairrington

ASKER

Figured it out by myself.