Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
| Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old December 20th, 2006, 03:31 AM
Registered User
 
Join Date: Dec 2006
Location: Lahore, Punjab, Pakistan.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error While Connecting to Oracle 9i via .Net


Hi, i have to connect in Oracle9i database.At home on personal computer OracleClient connection work fine but in office it gives me
the error
Unable to find an entry point named OCIEnvCreate in DLL oci.dll
Now i tried with a OracleClient connection:

Dim StrSql As String
        Dim MyConn As OracleConnection = New OracleConnection("User ID=USER;Password=PASS;Data Source=SERVERNAME")

           MyConn.Open()

            StrSql = "select * from DATABASE"

But when i Run the application, this is the error:
An unhandled exception of type 'System.EntryPointNotFoundException' occurred in system.data.oracleclient.dll
Additional information: Unable to find an entry point named OCIEnvCreate in DLL oci.dll

Could anyone help-me?


firasatlipk
  #2 (permalink)  
Old December 21st, 2006, 03:14 AM
Registered User
 
Join Date: Dec 2006
Location: Lahore, Punjab, Pakistan.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

AOA and Hi All,
Dear Members I have problem which i have solved now and Thanks! God
Any body who has the problem when using the OracleClient Namespace
with oracle using .Net technologies.
Do the Following.
1-First of All check that are u using Oracle 8.1.7 version or later if yes then move ahead otherwise you must install 8.1.7 or later.
2-Check also that ocl.dll file is placed in the bin folder of the oraclehome.
3-See the environment variable and check the system variable named path and check its value and assure that it have a bin directory.
if all these three points works fine then move ahead

4- Close all applications and access the folder of oracle where u install the oracle and access the Oralce_Home folder.I am using oracle 9i therefore Oralce_Home folder name is ora90.Right Click on the folder and access the properties then click the security tab
and assure that your login name is there and has the Administrator Rights.Now assure that you have click the fullControl check box under the Allow option if not then please click the fullcontrol checkbox and apply the changes.
Now logoff your account and re-enter it.
Now run the application and establish the connection now it will work fine with the help of God (Allah)
if still have a problem then reboot your computer.
So it is the main secret about OracleClient.
Please pray for me as i needed it badly.

Best Regards


firasatlipk


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert/retrive image from oracle 9i in asp.net 2.0 Pramod2005 .NET Framework 1.x 0 July 4th, 2007 02:55 AM
Error in Connecting to Oracle vikasagarwal1984 ASP.NET 1.0 and 1.1 Basics 1 October 1st, 2006 01:03 PM
How to run ASP.Net with Oracle 9i ramk_1978 ASP.NET 1.0 and 1.1 Professional 1 September 7th, 2006 08:07 PM
Connecting to Oracle 9i through ADO.NET conjurer ADO.NET 2 August 26th, 2003 06:56 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.