The breakpoint cannot currently be hit after oracle dll change

Question

I have a solution with several projects in vb, Visual Studio 2012. I just completed an upgrade task from System.Data.OracleClient to Oracle.DataAccess. When I build and run the solution it works fine but failed once I try to enter login info. When I put a breakpoint and build it in debug mode and try to step through each step, it only hits the first instance for page load and after that throws an error. It never reach the targeted breakpoint.

When I check my dll module, I noticed both the older version of the oracle data access and the newest one. And they both say “Binary was not built with debug information”

Any idea how I can resolve this issue?

Edit

I was able to run the command again, in the Developer Command Prompt for VS2015 this time. I am getting:

    C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools\gacutil.exe

C:\Program Files (x86)\Microsoft Visual Studio 14.0>gacutil /l | find "Oracle."
  Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxx, processorArchitecture=x86
  Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=xxxxxxxx, processorArchitecture=x86
  Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxx, processorArchitecture=x86
  Policy.2.102.Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxx, processorArchitecture=x86
  Policy.2.111.Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxx, processorArchitecture=x86
  Policy.2.111.Oracle.Web, Version=2.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxxx, processorArchitecture=x86
  Oracle.DataAccess, Version=1.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxxx
  Policy.1.102.Oracle.DataAccess, Version=1.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxxx
  Policy.1.111.Oracle.DataAccess, Version=1.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxxx
  Policy.10.1.Oracle.DataAccess, Version=1.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx
  Policy.10.2.Oracle.DataAccess, Version=1.111.7.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx
  Policy.9.2.Oracle

Debug mode doesn't guarantee debug symbols are generated - try a full clean, then ensure "Debugging information" is set to "Full" in project properties > Build > Advanced... — Scott, Apr 24 '18 at 19:31
Hey thanks for your response. I don’t see Build when I go to project > properties. That’s weird — Geezus, Apr 24 '18 at 19:35
Oops, I was looking in VS2017! In VS2012 it seems to be under Compile > Advanced Compile Options > Generate debug info. — Scott, Apr 24 '18 at 19:42
Ok. I just checked, mine was set to "Full". I am still getting the issue — Geezus, Apr 24 '18 at 19:59
What have you done for "upgrade task from oracle 11 to oracle 12"? — Wernfried Domscheit, Apr 25 '18 at 14:43
@WernfriedDomscheit Thanks for responding. So far only change of application functions/operations and change of the Oracle references. I removed the older oracle client from the Reference and added the new one — Geezus, Apr 25 '18 at 14:49
Once again: What was the old reference, what is the new one? — Wernfried Domscheit, Apr 25 '18 at 14:55
@WernfriedDomscheit The old reference is 2.111.7.0 and the new one is 2.112.1.0 — Geezus, Apr 25 '18 at 14:59
In this case you changed from Oracle 11.1 to 11.2 (not Oracle 12). Did you also remove Oracle Client 11.1 and installed version 11.2? What do you get by `gacutil /l | find "Oracle."`? — Wernfried Domscheit, Apr 25 '18 at 15:03
@WernfriedDomscheit sorry but I am getting 'Command "gacutil" is not valid'. when I run the gacutil /l | find "Oracle." command on VS 2015 — Geezus, Apr 25 '18 at 15:32
Please put additional information in your question (by editing) instead of a comment. — Wernfried Domscheit, Apr 25 '18 at 16:07
Maybe you just need to update the connector in your system and reference the new one. — Hackerman, Apr 25 '18 at 17:53
@WernfriedDomscheit sorry I may not know what accordingly is in your term. What I have done so far is change of the Oracle references by removing the older DataAccess client from the Reference and added the new one. Replaced OracleType enum with OracleDbType and updating the references to datatypes from VarChar to Varchar2 etc. Actually the application was using system.data.oracleclient.dll and the task is to change it Oracle.DataAccess.Client dll — Geezus, Apr 25 '18 at 18:01
It is really not clear what you did. You say "upgrade from oracle 11 to oracle 12", "change from version 2.111.7.0 to 2.112.1.0",, "change from `System.Data.OracleClient` to `Oracle.DataAccess`" - these are all different things. - So what have you done? Did you install/upgrade any Oracle Client and/or driver on your machine? If yes, how did you make it? — Wernfried Domscheit, Apr 25 '18 at 18:16
@WernfriedDomscheit Yes, I understand how confusing my questions are. I am very new to this and this my first time doing this kind of task and did not know how to ask the right questions. I did not "upgrade from oracle 11 to oracle 12" or "change from version 2.111.7.0 to 2.112.1.0". I only "change from System.Data.OracleClient to Oracle.DataAccess". No I did not install any new oracle client but it was already there. Looks like someone had already installed it in the machine already. Also sorry for all the confusion. I will update my questions — Geezus, Apr 25 '18 at 18:22

score 0 · Answer 1 · answered Apr 26 '18 at 07:24

You don't have to conceal the PublicKeyToken, they are public to everybody.

Anyway, I assume you messed up your Oracle installation. Most likely you had a working Oracle Client 11.1 (include ODP.NET) but then you installed ODP.NET (i.e. Oracle.DataAccess.dll) version 11.2 but without underlying Oracle Client 11.2.

Remove all your Oracle client installation (consult How to uninstall / completely remove Oracle 11g (client)?) and make a fresh installation of either Oracle 11.1 or 11.2 - or even the latest version 12.2.

The breakpoint cannot currently be hit after oracle dll change

1 Answers1