Errors when creating an Oracle data source for LightSwitch
Posted: Thu 11 Aug 2011 14:24
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!