It looks like you Oracle install is corrupted/incomplete. I've been using the System.Data.OracleClient namespace for about 2 years now without much problem. I would try reinstalling the oracle software.
FYI. When you are creating your connection programmatically, it uses the System.Data.OracleClient namespace. When you use the server explorer to create a connection, it uses the OLEDB provider. -----Original Message----- From: Moderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Jim Sent: Tuesday, March 16, 2004 5:17 PM To: [EMAIL PROTECTED] Subject: [ADVANCED-DOTNET] oracle db provider I receive the following exception when trying to open a connection to an Oracle database. Exception Details: System.DllNotFoundException: Unable to load DLL (oci.dll). Source Error: Line 133: 'Dim myCommand As New OracleCommand(mySql, myConnection) Line 134: 'myConnection.Open() Line 135: OracleConnection1.Open() Line 136: End Sub Line 137:End Class I have the Oracle 9.2 client installed. When I create the data connection in server explorere and do test it works. When I try to create a connection object either programmatically or visually when I do an open on it I ge this error. Please help if anyone has any ideas. Thanks, Jim =================================== This list is hosted by DevelopMentor(r) http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com ------------------------------------------------------------------------------ Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates (which may be known outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as Banyu) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. ------------------------------------------------------------------------------ =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com
