Toad World® Forums

Connecting: "“Cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll"


#1

64 bit Vista loaded with 64 bit Oracle Database 10.2.0.4 for Windows and Toad For Oracle 10.0.0.41. Toad Install appears to go fine. But when attempting to connect to the db, I get “Cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll”. The file is there. I have googled on this and found some saying Toad is 32 bit and does not work with 64 bit Oracle, but have found other entries saying Toad works with both 32 bit and 64 bit Oracle. I’ve searched asktoad.com for “OCI dll” and “Cannot load OCI DLL” but finding nothing about this error. There is an entry about an error “Could not locate OCI DLL” during installation but that’s a different error message and different operation. Using SQL*Plus, I can connect to and use the db with no issues. I see in asktoad that “Toad is supported on Windows NT 4.0, 2000, XP, and 2003 clients” is this error a symptom of Toad not being supported on Vista? Any advice is appreciated.


#2

Toad works with both 32 and 64 bit DATABASE

Toad only works with 32 bit CLIENT

If you need 64 bit client for other apps, you can install both 32 and 64 bit
client on a single machine and just tell Toad to use the 32 bit one.


#3

Vista is no problem. Toad can work with a 64 bit Oracle server, but you have
to use a 32 bit Oracle client. We won’t have the ability to use a 64 bit
client until our development environment (Delphi) has a 64 bit version.


#4

Toad requires a 32 bit Oracle client.

From the Toad Getting Started Guide:
Picture (Device Independent Bitmap) 1.jpeg


#5

Here’s a chart to summarize:


#6

Hello Jdorlon

I have the same problem : Cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll"

OS Windows Vista 64 bits sp2
Oracle 10g 10.0.2 - 64 bits Server

Toad for Oracle version 10.5.0.41 installed on the Database Server

I didn’t install the oracle client yet .

In your post you said :

Vista is no problem.
Toad can work with a 64 bit Oracle server,
but youhave to use a 32 bit Oracle client.

We won’t have the ability to use a 64 bit
client until our development environment (Delphi) has a 64 bit version ???

My Question is , based on my configuration above , why I am still getting the error msg ?