Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 02:38 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.