Trial with Express Edition ORA-12571
Trial with Express Edition ORA-12571
Hello,
I have a problem with direct access to Oracle Express and sample codes for Entity framework.
When I use trial of OraDeveloper tools, I can access directly the server and tables are there (I ran the sql script for the samples)
I've no idea what is wrong here
I have a problem with direct access to Oracle Express and sample codes for Entity framework.
When I use trial of OraDeveloper tools, I can access directly the server and tables are there (I ran the sql script for the samples)
I've no idea what is wrong here
It is from LinqQueries example on line 208 - RefreshQuery method and this code
Stack:
Code: Select all
dataGridView.DataSource = query.Query;
Code: Select all
ORA-00942: table or view does not exist
at xc.u.d()
at Devart.Data.Oracle.be.b()
at Devart.Data.Oracle.t.a(Int32 A_0, a1 A_1)
at Devart.Data.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.d.a.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.d.a.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
I just tried this code with Devart.Data.Oracle to get the count of companies in database with the same connection parameters and it workded fine:
Code: Select all
OracleConnection con = new OracleConnection(
"User Id=tcha;Password=pwd;Server=127.0.0.1;Direct=True" );
con.Open();
OracleCommand cmd = con.CreateCommand();
cmd.CommandText = "select count(*) from \"Company\"";
Hello, I am a newbie in the Oracle world, so it could be some stupid thing for sure
The steps I did was:
The steps I did was:
- - I have installed the Oracle Express 10g on the localhost and setup a user with all privileges via the oracle web UI
- I have installed the latest FW 3.5 SP1 and SP1 for VisualStudio 2008
- I have installed latest dotConnect for Oracle with full choice
- I came to Samples/Oracle directory and loaded the script crm_demo via oracle UI and executed it succesfully (logged in as my new user)
- When I browse the tables in oracle web UI, there are the Company, Order Details, Orders, etc. tables and the data in it, so it should be prepared for the entity samples
- I openned the CSharp solution in entity samples folder and edited the app.config to make the right connection string in LinqQueries project as folows:- I executed the sample and I get the describet exception: ORA-00942: table or view does not exist while loading All companiesCode: Select all
provider connection string="User Id=tcha;Password=tcha;Server=localhost;Direct=True;Sid=XE;Port=1521"
- So I tried to install the trial version of Ora Developer Tools
- I tried to add 2 new connections with these connection strings:- Both are working well and I can see those tables (Company, Orders, etc. and browse the data in it)Code: Select all
User Id=tcha;Password=tcha;Server=XE;Direct=False User Id=tcha;Password=tcha;Server=localhost;Direct=True;Sid=XE
- When I try to modify the connection string in the samples, it allways ends up with the same error