Devart Forums

Thank you for your reply. The connection string you have posted worked for direct mode. However it did not fix the issue.

However, installing dotConnect on users machine in minimum rum time assemblies worked. However, why did it not work when we included the same DLLs with application? I see the DLLs in the package to be installed.

Will investigate more. If you have more insight, please let us know.

Thanks again.

We are still looking for solution on this. any help is appreciated

Here is more info: with this modified connection string:



we get an exception

{"ORA-12545: Connect failed because target host or object does not exist\n "}


where is 1521 (at the end in the exception) coming from?

I read the link http://www.devart.com/dotconnect/oracle ... tMode.html and created a connection and passed it as a parameter to my context on new() method.

So, the context looks like

dbContext = new IVSREntities(EntityObjectUtilities.connectionString);

At this point, I get the error {"Keyword not supported: 'user id'."}

Tried direct connection with the following connection string:






I get the following error:

{"The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid."}

I then changed the connection string to this:



I get the error "Underlying provider failed to open". I looked for standard direct connection format for connection strings, could not find one that worked with dotconnect. Is there one that i can include in app.config?


Please advice

Tried with setting the exception, but, can't get any more info. Will try with direct connect. Will update this post.

Thank you very much.

We have done all these. Only issue I see now is that the user computer does not have a full Oracle Client. I think that is the issue because, we took a developer's laptop that had VS 2010, DotConnect and full Oracle Client and started removing one by one. As soon as we removed Oracle, it started giving the same error.

So, anyway to make this work without a Oracle Client? One solution I see is to connect to DB directly rather than using OCI (http://www.devart.com/dotconnect/oracle ... yment.html)

I will give it a shot. Please let me know if there is another way.

Thanks,

Uday

Hi,

We are trying to deploy an application using ClickOnce. We have included all the DLLs from Dot COnnect for Oracle. However, when the application is launched, we get an error "Critical Error: Underlying Provider failed to start". We even changed the connection string to include fully qualified string. Here is the connection string:




This works on Developer's machine. THe client machine has Oracle 10g, same version as developer's machine.

please advice. Your help is greatly appreciated.

Avanata,

Did you get this resolved? What was the solution? Thanks for your response.

Are you deploying using ClickOnce method or installSheild? We are having similar issues using clickOnce deployment method. I have tried both including the DBProviderFactory segment in app.config and including Oracle.Entity.dll file with the app. But, neither solves the error. I would appreciate any help.

Hi,

We are trying to install a WPF application developed using C# and dotConnect for Oracle using clickOnce deployment. We have followed the instruction given in http://www.devart.com/dotconnect/oracle ... ml#project

Still we get the error:

critical errorSchema specified is not valid. Errors:
EntityModel.IVSREntityModel.ssdl(2,86): error 0004: Could not load file or assembly 'Devart.Data.Oracle.Entity, Version=6.30.172.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. The system cannot find the file specified

We followed the URLs: http://www.devart.com/forums/viewtopic. ... e7e670a204
http://www.devart.com/forums/viewtopic. ... e7e670a204
and
http://www.devart.com/dotconnect/oracle/docs/
and updated out project with suggestions from these links. Still the issue persists where we get the error shown above. Please advice on a solution.

We are using VS2010, C#, EF4.0, .NET 4, with dotConnect for Oracle verison 6.30.172

Thanks,

Uday

Hi,

We have entity objects where 2 fields UpdateUserId and UpdateDate needs to be set if an object is modified. When I check the object's EntityState, it shows it as Modified even when it is not. Is there a better way to check if something has changed in the object?

Thanks,

Uday