I am trying to create a new entity data model...after choosing the database objects in the final step and clicking the ok button...nothing gets added to the EF model....In the error list window i see the error below:
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
ORA-00942: table or view does not exist
'.
Environment: Visual Studio 2010
devart for Oracle version 7.2
Error Creating a New Entity Data Model
Re: Error Creating a New Entity Data Model
We cannot reproduce the problem at the moment. Please give us the following information:
1) the exact version of your Oracle server. Also specify Oracle client version if the OCI mode is used;
2) the script to create the database user you are connecting with;
3) are you choosing the database objects in Entity Data Model Wizard from your user's schema or from another one?
As a workaround, please use Entity Developer (the Devart Entity Model item).
1) the exact version of your Oracle server. Also specify Oracle client version if the OCI mode is used;
2) the script to create the database user you are connecting with;
3) are you choosing the database objects in Entity Data Model Wizard from your user's schema or from another one?
As a workaround, please use Entity Developer (the Devart Entity Model item).
Re: Error Creating a New Entity Data Model
Thanks for your reply. I am attaching a document with the screenshots of the steps I took to create an Entity Model
Here is the environment
OS: Windows 7
Visual Studio 2010
Database server:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Solaris: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production
I am using the direct mode (used OCI mode also...same issue)...I am using an existing database user for connecting to the database...and yes I am using the database objects from the same users schema.
I have tried this on two machines...Both had Visual Studio 2010 and Devart 7.2 installed....Also tried in Visual Studio 2012....Same issue.
Let me know if you need any more details....
Hope to hear from you soon.
Here is the environment
OS: Windows 7
Visual Studio 2010
Database server:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Solaris: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production
I am using the direct mode (used OCI mode also...same issue)...I am using an existing database user for connecting to the database...and yes I am using the database objects from the same users schema.
I have tried this on two machines...Both had Visual Studio 2010 and Devart 7.2 installed....Also tried in Visual Studio 2012....Same issue.
Let me know if you need any more details....
Hope to hear from you soon.
Re: Error Creating a New Entity Data Model
We have asked for additional information by e-mail.