Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

32 BITS 12C ODBC not working with WINDOWS 10

user2618876Jun 8 2016 — edited Jul 15 2016


Hi Everyone,

this is my first post, please give me some help to give me a good first experience, thanks in advance.

Here is the issue I am facing, my company is about to upgrade all computer to windows 10, I tested the Oracle 12c client odbc 32 bits in windows 10, unfortunately, it does not work, it come back with an error unable to find dll SQORA32.DLL even the dll does exist. It does not have such problem if using Oracle 11g 32 bits under same env.

our product only work with 32 bits odbc driver, that is why I need to mention 32 bits here.

Does anyone has a solution for this.

Thanks

Patrick

Comments

thatJeffSmith-Oracle
Answer

Should be out soon.

Marked as Answer by jdoornae · Jun 29 2022
1 person found this helpful
jdoornae

It's there now. Thanks!

Mal Baird

Is JDK 8 or 11 included?
image.pngimage.png

thatJeffSmith-Oracle

11, fixing the typo now

stom

Downloaded SQL Developer 22.2 with JDK 11
Copied my preferences over from the previous installation (21.4.3.063).
When I try to connect to a database from the connection tree, I get this error.
image.png Any ideas?

thatJeffSmith-Oracle

What type of connection is it?
I'm running the exact same thing you are, 64-bit Windows w/Java 11 included, and on an upgrade can connect just fine.
Maybe, try extracting the zip again using native Windows file explorer to a net-new directory, and try connecting from that location?

stom

It is a basic connection. I specify the host, port and service name. I right clicked on the connection name -> properties -> Test
image.pngI extracted to a new location and I also downloaded the "No Java" version. I get the same error on both attempts.

thatJeffSmith-Oracle

Do you have an oracle client defined in the Advanced Preferences, or are you using a TNS connection type or do you have 'OCI' checked on your advanced connection properties?

stom

I am using a basic connection type. I have a TNSNAMES file but I don't use it.
image.pngI have "OCI/Thick driver" checked. We use Radius authentication for our DB logins and I remember it wasn't working without this box checked.

thatJeffSmith-Oracle

That's probably it, get a newer client and try that, a 19c or 21c client.

user-x79xr

Same issue for me - java.lang.NoClassDefFoundError: oracle/jdbc/datasource/impl/OracleDataSource

I'm using 19c Client with "OCI/Thick driver" checked in SQLDeveloper 22.2 but still facing this issue.

1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 11 2020
Added on Jun 8 2016
#odbc, #windows-and-net
14 comments
54,867 views