Groups | Blog | Home
all groups > dotnet distributed apps > september 2004 >

dotnet distributed apps : Oracle: "Unable to load dll (oci.dll)"


rotarinn
9/24/2004 4:51:06 AM
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.
s_cnot
9/24/2004 1:49:03 PM
Are you trying to create a Typed Dataset ?
For Stored Proc return result-set, we just went ahead and keyed in the
Leon Welicki
10/8/2004 3:35:04 AM
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

[quoted text, click to view]
AddThis Social Bookmark Button