Error when Adding View from Oracle DB

Error when Adding View from Oracle DB

Postby nssidhu » Tue 19 Oct 2010 16:07

I am getting Error when Adding View From Oracle DB.
The view is defined in Oracle and is using Oracle Link to connect to the sybase Server and query is running against sybase server.
SELECT P.C_LLW_CODE P_LLW_CODE,
C.M_AWARD_AMOUNT AWARD_AMOUNT,
V.C_NAME GC_CONTRACTOR,
BW.C_ELECTRICAL ELECTRICAL,
BW.C_PLUMBING PLUMBING,
BW.C_HVAC HVAC,
C.VC_COMMENT
FROM PROJ_LLW@XXXX_LINK_CMS P,
CONTRACT@XXXX_LINK_CMS C,
VENDOR@XXXX_LINK_CMS V,
BIDDER_WICKS@XXXX_LINK_CMS BW
WHERE P.C_SOLICIT = C.C_SOLICIT
AND V.C_VENDOR_ID = C.C_VENDOR_ID
AND BW.N_SOLICIT_SEQ = C.N_SOLICIT_SEQ
AND BW.C_VENDOR_ID = C.C_VENDOR_ID

Query runs fine against DB.

Unable to generate the model because of the following exception: 'The item with identity 'LLW_CODE' already exists in the metadata collection.
Parameter name: item
'.
Loading metadata from the database took 00:00:04.6467538.
Generating the model took 00:00:36.7599838.
Unable to update the Web.Config file because of the following exception: 'The 'server' keyword is not supported.'
Successfully registered the assembly 'System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' in the Web.Config file.
nssidhu
 
Posts: 11
Joined: Tue 23 Feb 2010 18:35

Postby AndreyR » Wed 27 Oct 2010 12:50

Please try to add a Devart Entity model to your project. Its functionality is the same as the functionality of Microsoft Entity model, and it has a bit more convenient designer and some other features like flexible code generation and editable Storage model.
Please let us know if the error persists.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle