Errors when creating an Oracle data source for LightSwitch
Errors when creating an Oracle data source for LightSwitch
I want to develop a Visual Studio LightSwitch application that uses an Oracle database as the data source. I have dotConnect for Oracle installed so I want to use it as the data provider for accessing the Oracle database.
The steps I follow are:
1. Open Visual Studio, create new LightSwitch project
2. Click on "Attach external data source", select "Database" type
3. Select dotConnect for Oracle as the data provider
4. Set the connection properties, test the connection
5. The database object selection screen appears with the "Retrieving database object" message, then after a while the following errors appear:
The error messages are in Spanish. This is an approximate translation of the first one:
(1,781453) : error 2039: The 'ELLIPSOID_ID' property of the conceptual side has been already assigned to a storage property of 'decimal' type. If a property of the conceptual side is assigned to more than one property of the storage model, make sure that all properties on the storage model have the same type.
I have no idea what is happening here, and I don't have any property named ELLIPSOID_ID in any of the tables of my database. So, what's wrong here?
By the way, I have no problems for accessing the very same database by using a LinqConnect model.
Additional details:
- Using LightSwitch 2011 RTM in Visual Studio 2010 SP1.
- dotConnect for Oracle version is 6.30.196.0
- Database is Oracle 10g Express Release 10.2.0.1.0
Thank you!
The steps I follow are:
1. Open Visual Studio, create new LightSwitch project
2. Click on "Attach external data source", select "Database" type
3. Select dotConnect for Oracle as the data provider
4. Set the connection properties, test the connection
5. The database object selection screen appears with the "Retrieving database object" message, then after a while the following errors appear:
The error messages are in Spanish. This is an approximate translation of the first one:
(1,781453) : error 2039: The 'ELLIPSOID_ID' property of the conceptual side has been already assigned to a storage property of 'decimal' type. If a property of the conceptual side is assigned to more than one property of the storage model, make sure that all properties on the storage model have the same type.
I have no idea what is happening here, and I don't have any property named ELLIPSOID_ID in any of the tables of my database. So, what's wrong here?
By the way, I have no problems for accessing the very same database by using a LinqConnect model.
Additional details:
- Using LightSwitch 2011 RTM in Visual Studio 2010 SP1.
- dotConnect for Oracle version is 6.30.196.0
- Database is Oracle 10g Express Release 10.2.0.1.0
Thank you!
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
Yesterday, I just tried the LightSwitch with devart and oracle, and had the Exact same error-message.... (but in english)Shalex wrote:We have reproduced the error. We will investigate the issue and notify you about the results as soon as possible.
I tested it with
- VS.NET 2010 premium SP1 and Lightswitch 2011
- dotConnect for Oracle version is 6.30.196.0
- Database Oracle 11.2.0.2
I would also appreciate it if you could notify me when you have any results about this issue...
Thx
Fred
New build of dotConnect for Oracle 6.50.228 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only). For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22164 .
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only). For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22164 .
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
Hello, today i have tested the LightSwitch again, but it give still the same error.Shalex wrote:Notify us about the results. If the issue persists, please send us the DDL script to reproduce the issue.
I tested it with
- VS.NET 2010 premium SP1 and Lightswitch 2011
- dotConnect for Oracle version is 6.50.228.0
- Database Oracle 11.2.0.2
- Tried with: oracle client 8, 10, 11
I have tested with a seperate DB-owner, and seperate tablespace with has only one table in it. (seee below)
I have the feeling it takes also a long time to retrieve the Db-objects (I only have 1 in my schema), and get to the error.
*) Does the Lightswitch fetches all the DB-objects (all schema's) first before you can select ?
*) What happens if 1 of your tables is a table without primary key, etc... --> does your full DB needs to be 100% OK, to use Lightswitch onle for some tables ?
Fred
CREATE TABLE TESTING_FG_ADMIN.TEST1 (
COL1 NUMBER(38),
CONSTRAINT PK_TEST1 PRIMARY KEY (COL1))
TABLESPACE TESTING_FG
LOGGING;
The Lightswitch fetches all the DB-objects, which your current user has access to. Please follow the recommendations from http://www.devart.com/dotconnect/oracle ... izard.html, "The Wizard Or EDM Designer Work Very Slowly" (do not connect as DBA, remove the privileges SELECT ANY TABLE, etc).goethals.f wrote:*) Does the Lightswitch fetches all the DB-objects (all schema's) first before you can select ?
This decision is taken by EDM Wizard (it either creates primary key basing on all NOT NULL columns or excludes the table from the list).goethals.f wrote:*) What happens if 1 of your tables is a table without primary key, etc... --> does your full DB needs to be 100% OK, to use Lightswitch onle for some tables ?
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
Hello,
I tested it again with a non dba-user which has only acces to some tables. and indeed, after some time I can select the tables and complete the wizard.
But when I just try to run the project itself, I get an error related to a SQLEXpress not found. Does the lightSwitch still needs some sql server ?
When I look in the file C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v1.0\Microsoft.LightSwitch.targets at line 157. I see the following info.
Is there still something that's missing or that I have done wrong.
My first test was to just create a basic default LightSwitch app, with 1-2 tables to see what it could do...
PS: in the generated app.config, there was some connectionstring, but I have tested with and without these. But still the same error.
Is there any Lightswitch Devart example available somewhere ?
Greetings,
Fred
I tested it again with a non dba-user which has only acces to some tables. and indeed, after some time I can select the tables and complete the wizard.
But when I just try to run the project itself, I get an error related to a SQLEXpress not found. Does the lightSwitch still needs some sql server ?
Code: Select all
Error 101 An error occurred while establishing a connection to SQL Server instance '.\SQLEXPRESS'.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v1.0\Microsoft.LightSwitch.targets 157 10 LightSwitchTest1
Code: Select all
My first test was to just create a basic default LightSwitch app, with 1-2 tables to see what it could do...
PS: in the generated app.config, there was some connectionstring, but I have tested with and without these. But still the same error.
Code: Select all
-->
Greetings,
Fred
Could you please try creating the new LightSwitch Application project that works only with Data Source which uses dotConnect for Oracle? Does the problem persist in this case as well? We cannot reproduce the issue at the moment.goethals.f wrote:An error occurred while establishing a connection to SQL Server instance '.\SQLEXPRESS'.
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
HelloShalex wrote:Could you please try creating the new LightSwitch Application project that works only with Data Source which uses dotConnect for Oracle? Does the problem persist in this case as well? We cannot reproduce the issue at the moment.goethals.f wrote:An error occurred while establishing a connection to SQL Server instance '.\SQLEXPRESS'.
Sorry for the late replay, but was really busy with some other projects.
I just tested some more, and it seems I can only get it working, when on my devel pc my SQLServerExpress-service is really started and running. Then no build problems occurs.
When I switch my local sqlserver express off, I get the build error again.
I also check the contents of my local DB, but there was nothing in it.
Also, a simple deploy to a IIS on win2003 server, did work.
so it seems maybe the developer "needs" a sqlserver express running for some reasons.
But now, I have some more questions related lightswitch - oracle - devart.
I created a new project, and included 1 DB-table with an ID-field as primary key.
When I first wanted to create a new record, I got the famous transaction-error (http://www.devart.com/forums/viewtopic. ... ightswitch) which i could solve by the explanation in that thread.
My table, currently has no trigger for creating ID-value based on sequence --> so inserting nex records via lightswitch does not really works (you have to specify ID by yourself)
I'm just wondering.
Is there any example from devart available, for a really simplistic LightSwitch application with following basic-every-day actions
*) 1-2 tables with relationship
*) ID-fields in table which would be auto-generated based on sequence --> but not really relying on insert-triggers if possible
*) how to implement the lightswitch roles/users/authentication model also with an oracle DB (which schema, connectionstring, ...)
*) simple deployment to an IIS server via the lightswitch deployment wizard
I think if you provide us with an basic example or really good blog-post or ... it would help a lot of users which want to use/test lightswitch in combination with oracle.
Or if there is already enough info somewhere else --> maybe just combining this info together to make it a lot easier for developer to start with lightswitch and have any feeling if we can really use devart, oracle and lightswitch together.
Greetings and keep up the good work to at least make the new technologies possible, but a little more detailed examples can do magic sometimes.
Fred
[/list]