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

http://toadfororacle.com/thread.jspa?threadID=24227 Thread: Connecting: "揅annot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll"

Reply to this Thread

Search Forum

Back to Thread List

elkeja99 Connecting: "揅annot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll" Posted: Dec 11, 2009 9:40 AM   Reply 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. HillbillyToad Posts: 589 Registered: 8/10/06 RE: Connecting: ""Cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll" Posted: Dec 11, 2009 9:51 AM   in response to: elkeja99   Reply 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. Follow me on twitter @hillbillyToad Check out my blog jdorlon Posts: 503 Registered: 10/30/09 RE: Connecting: ""Cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll" Posted: Dec 11, 2009 9:52 AM   in response to: elkeja99   Reply 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. GTDG Posts: 112 Registered: 11/30/07 RE: Connecting: ""Cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll" Posted: Dec 11, 2009 9:52 AM   in response to: elkeja99   Reply Picture (Device Independent Bitmap) 1.jpg (26.6 K) Toad requires a 32 bit Oracle client. From the Toad Getting Started Guide: