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

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