Toad Data Point 3.8.1.677 / Windows 10 - Unable to Connect to Oracle 12c Database - SEHException/Win32Exception

Toad Data Point & Toad Intelligence Central
1

I recently installed Toad Data Point 3.8.1.677 on Windows 10, and I created a connection to an Oracle 12c database. Unfortunately I’m unable to connect to the database. With each attempt I get a “Toad Data Point Error Message” dialog. The actual error text alternates between this…

System.Runtime.InterOpServices.SEHException
External component has thrown an exception.
Stack Trace:
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Dell.NamedPipeRPC.MessageRequest.Invoke()
at Dell.NamedPipeRPC.MessagePumpServer.ExecuteMessage(MessageRequest state)

…and this…

System.ComponentModel.Win32Exception
Proxy process has gone away

I have been able to connect to the same database using SQL Developer. The version of the .NET Framework running on the machine is 4.6.0138.

Has anyone else encountered this problem before? What are some possible solutions?

Thanks very much!

2

Do you have 32-bit or 64-bit Oracle client on the Win10 PC? Did you try direct connect?

3

We released TDP 3.8.1.677 for a specific error that occurs with .net 4.6.1 and Oracle 64-bit client. Make sure you have latest version of .net 4.6.1 and then reinstall TDP 3.8.1.677. This was tested and resolved all issues.

4

Oracle 12.1.0.2.0, 64-bit client.

I believe I found the cause of the problem. My system’s ORACLE_HOME was set to the path of an earlier (also installed) version of the client:

C:\oracle\product\11.1.0.6

I changed this to the path of the 12c client:

C:\oracle\product\12.1.0.2

And now Toad connects as expected.

Thanks very much! Hopefully your tips and this information will help other Toad users.

5

(Deleted)