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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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 to this problem?
what was the solution I'm having the same problem?
ASKER
Figured it out by myself.
and used the 32Bit ODBC Administrator to create and test the DSN and everything worked?
http://support.microsoft.com/kb/942976