代码改变世界

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

2011-02-24 15:16  flyingfish  阅读(7739)  评论(0)  编辑  收藏  举报

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 Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List Point your RSS reader here for a feed of the latest messages in all forums

Permlink Replies: 5 - Pages: 1 - Last Post: Apr 30, 2010 1:13 PM by: Frank_Assis
elkeja99
Connecting: "揅annot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll"
Posted: Dec 11, 2009 9:40 AM
  Click to reply to this thread 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
  Click to reply to this thread 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
  Click to reply to this thread 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
  Click to reply to this thread Reply
Attachment Picture (Device Independent Bitmap) 1.jpg (26.6 K)






Toad requires a 32 bit Oracle client.

From the Toad Getting Started Guide: