This content has been marked as final. Show 4 replies
What happens if you use a basic connection? Specify the hostname,port and sid/service from your tnsnames directly in SQL Developer.1 person found this helpful
This will ignore any other oracle components you have and just use JDBC. That may avoid any DLL clash causing your Access Violation Error.
That works. Does that mean my ODAC install somehow corrupt? Any idea what gives?
Edited by: 993662 on Mar 13, 2013 10:17 AM
Not necessarily. It may just be a mismatch between the JDBC version in SQL Developer and the OCI and JDBCOCI dlls in ODAC.
I'm not really sure how to go about confirming that. Perhaps someone else here will have some more specific info on versions.
Thanks for your suggestion. After several hours of experimenting, I've managed to fix my problem by copying the ojdbc6.jar from my ODAC installation and replacing the one in [sqldeveloper root]\jdbc\lib
To whomever has a similar issue: See my original post for what software I was using and their version numbers.
Edited by: FrostyZoob on Mar 14, 2013 8:11 AM