Devart Forums

Hi,
I have installed Oracle 10g database and 10g client on the same windows XP PC and when I attempt to create a connection in Entity Developer, I get the following error.

I checked the permissions for the bin folder in oracle directory and gave full permissions to everyone. Also I'm able to connect with sqldeveloper just fine. I also get the same error when I connect with my ASP.NET web application.
---------------------------
Entity Developer for dotConnect
---------------------------
Can not load Oracle client. Check your PATH environment variable and registry settings.
---------------------------
OK
---------------------------

Hi,
The client keeps getting the following error when they deploy the ASP.NET web application.

Environment
VMware Virtual Server hosting windows server 2003 OS
ASP.NET 3.5 sp1
Devart dotConnect for Oracle 5.0 Professional
Oracle Client 10g (tried both instant client and full client)
IIS 6.0

I have set the trust level to full in the web.config and oracle path looks fine. I'm not sure what's going on...I'm pasting some web.config details below.
web.config




















ERROR


Can not load Oracle client library oci.dll from home .
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Can not load Oracle client library oci.dll from home .

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[FileNotFoundException: Can not load Oracle client library oci.dll from home .]
Devart.Data.Oracle.OracleHome.get_ClientVersion() +491
Devart.Data.Oracle.an.a(Boolean A_0, Boolean A_1, OracleHome A_2) +36
Devart.Data.Oracle.OracleInternalConnection..ctor(y connectionOptions, OracleInternalConnection proxyConnection) +382
Devart.Data.Oracle.by.a(i A_0, Object A_1, DbConnectionBase A_2) +116
Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, i A_1) +43
Devart.Common.DbConnectionPoolGroup.c(DbConnectionPool A_0) +18
Devart.Common.DbConnectionPool.a() +44
Devart.Common.DbConnectionPool.GetObject() +411
Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0) +77
Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection) +144
Devart.Common.DbConnectionBase.Open() +30
Devart.Data.Oracle.OracleConnection.Open() +267
Devart.Common.Web.Providers.DbMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object userId, MembershipCreateStatus& status) +314

[ProviderException: An exception occurred. Please contact your administrator.]
Devart.Common.Web.Providers.DbMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object userId, MembershipCreateStatus& status) +1807
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +318
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +102
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +418
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +161
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +19
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565[/b]

Hi,
I installed instant client on a new PC to test if I can connect to the database. I was not able to connect. When I launch Entity Developer, it doesn't recognize my database. I get the following error.
---------------------------
Entity Developer for dotConnect
---------------------------
ORA-12154: TNS:could not resolve the connect identifier specified
---------------------------
OK
---------------------------

Thanks
Mahipal

1. I have oracle Instant Client installed on the PC. Does this rule out the cause # 1? However on my development I have Oracle 9.2.0.4 client installed. Does the client PC also need Oracle client 9204 and not Instant Client?

2. In my app, there is no tag. On my development PC, this runs fine without this tag. So I'm guessing this isn't the problem. What do you think?

3. I will have the client check if it's an issue with the path variable for the OCI.dll.

Thanks

Hi,
I'm getting the following error when I'm attempting to connect to the oracle datbaase from my ASP.NET Dynamic Data Entities Website. We have Oracle instant client installed on the target PC. I'm able to connect to the database using the oracle instant client but not with the dotConnect for Oracle. I've also pasted the connection string that I'm using in my web.config to connect to the database. Please help. I purchased this product and I need to deploy my app to the client's PC.

Exception Details: System.InvalidOperationException: Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server.

Connection String in Web.Config



Here is the entire stack trace of the error.

Stack Trace:

[InvalidOperationException: Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server.]
Devart.Data.Oracle.OracleHomeCollection.a() +1874
Devart.Data.Oracle.OracleInternalConnection..ctor(y connectionOptions, OracleInternalConnection proxyConnection) +382
Devart.Data.Oracle.by.a(i A_0, Object A_1, DbConnectionBase A_2) +116
Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, i A_1) +43
Devart.Common.DbConnectionPoolGroup.c(DbConnectionPool A_0) +18
Devart.Common.DbConnectionPool.a() +44
Devart.Common.DbConnectionPool.GetObject() +411
Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0) +77
Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection) +144
Devart.Common.DbConnectionBase.Open() +30
Devart.Data.Oracle.OracleConnection.Open() +267
Devart.Common.Web.Providers.DbMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object userId, MembershipCreateStatus& status) +314

[ProviderException: An exception occurred. Please contact your administrator.]
Devart.Common.Web.Providers.DbMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object userId, MembershipCreateStatus& status) +1807
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +318
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +102
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +418
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +161
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +19
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Thanks. I tried again and it worked with Entity Framework. Please let us know when we can try the LINQ to Oracle support for Dynamic data websites.

Hi,

I'm trying to create a ASP.NET dynamic data website with Oracle as the underlying database. I'm getting an error....as "this context type is not supported" when I use the LINQ to Oracle feature.

When I use the Entity Framework component, I get the
"Provider Manifest Token 'Ora10gR2' is different from 'ORA' that was encountered earlier".

Does dotConnect for Oracle support Dynamic data websites for Oracle database? Any pointers you can provide me will be helpful. I'm evaluating your product so I can buy it if it does what I want.

Thanks
Mahipal