Oracle: "Unable to load dll (oci.dll)"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rotarinn - 24 Sep 2004 12:51 GMT

Hi,
I am using VisualStudio.NET 2003 trying to connect to an Oracle Database
(version 8.0.5). I have created the connection using "Microsoft
OleDBProvider for Oracle" and when I click on Test connection, I get a
message showing "Test connection succeeded".

However, when I try to drag a table from the connection into a dataset, I
get the following message: "The connection could not be opened due to the
following error: Unable to load DLL (oci.dll)"

I have read a few posts regarding this error message but most of them seem
to be related to ASP.NET. Since I am only creating a Windows Forms
application, I believe the ASP.NET permissions shouldn't be an issue here. I
don't even have IIS installed on my computer.

I have been trying to locate the oci.dll file, but all I could find was a
file named ociw32.dll in the ORANT/BIN folder.

Do you guys have any idea what I should do???

Best regards,
-rotarinn

System info:
VisualStudio.NET 2003
Oracle 8.0.5.
Windows 2000 Professional

Reply to this Message

s_cnot - 24 Sep 2004 21:49 GMT

Are you trying to create a Typed Dataset ?
For Stored Proc return result-set, we just went ahead and keyed in the
schema/xml to create the dataset, with the table field names.

Reply to this Message

Leon Welicki - 08 Oct 2004 11:35 GMT

rotarin,

I had the same problem and fixed it giving read, read & execute and list
folder contents permissions to the account running the process onto the
directory where the oracle dlls are.

Anyway, I guess you need Oracle 8.1.7 or later in order to use the Microsoft
.NET Data Provider for Oracle

Regards,
Leon

> Hi,
> I am using VisualStudio.NET 2003 trying to connect to an Oracle Database
[quoted text clipped - 23 lines]
> Oracle 8.0.5.
> Windows 2000 Professional

Reply to this Message

Oracle: "Unable to load dll (oci.dll)"

Free Magazines