Search found 11 matches

by nssidhu
Tue 15 Feb 2011 16:36
Forum: dotConnect for Oracle
Topic: Error: Root element is missing
Replies: 3
Views: 2037

Error: Root element is missing

I am getting Error : " Root element is missing
This is not a fatal error, setup will continie after you press OK."

when isntalling version 6.0 of Dotconnect for oracle. Trying to install on windows 7 64bit version.
by nssidhu
Tue 01 Feb 2011 15:52
Forum: dotConnect for Oracle
Topic: Cannot Add Views or Stored Procedure to the Model
Replies: 5
Views: 1178

I am doing exactly as you mentioned., but when opening the .edmx in xml editor i don't see any commented code relating to the view that i was trying to import
by nssidhu
Tue 25 Jan 2011 17:59
Forum: dotConnect for Oracle
Topic: Cannot Add Views or Stored Procedure to the Model
Replies: 5
Views: 1178

Cannot Add Views or Stored Procedure to the Model

I am not able to Add View or Stored Procedure to the Model, even though i am able to select View, but after selecting it nothing happens and the dialog box closes. Upon opening the .edmx i don't see anything related to View
by nssidhu
Wed 19 Jan 2011 16:45
Forum: dotConnect for Oracle
Topic: Columns are not included in Update Statement
Replies: 1
Views: 891

Columns are not included in Update Statement

DotConnet for Oracle.

When using DomainService Class, certain columns are not included in the Update statement, when the updated value is same as Orginal Value.

How can i force the Value to be always be passed, even if the value is changed or not.

Our Triggers Needs updated_By value to be always be passed even if it is same value.
by nssidhu
Wed 08 Dec 2010 16:33
Forum: dotConnect for Oracle
Topic: How to Handle Inserts & Updated to CLOB Field > 4000 chars
Replies: 2
Views: 984

that works thanks
by nssidhu
Tue 07 Dec 2010 17:30
Forum: dotConnect for Oracle
Topic: How to Handle Inserts & Updated to CLOB Field > 4000 chars
Replies: 2
Views: 984

How to Handle Inserts & Updated to CLOB Field > 4000 chars

I am using the following Statement it works fine if the comments are less then 4000 characters, buit fails with error String litral too long, when using more then 40000 characters.

Dim Qry As String = String.Format("UPDATE PTS.LLW_T_LLW SET C_LL24_COMMENT='{0}', Updatedby_security_ID_FK={1} WHERE LLW_ID_PK={2}", LLW.LLW24_Comments, LLW.Updatedby_security_ID_FK, LLW.LLW_ID_PK)
Dim irowsAffected As Integer = Me.ObjectContext.ExecuteStoreCommand(Qry)

I would additinally also like to know, if this will also be a problem when using entities from entity model.
by nssidhu
Fri 22 Oct 2010 19:35
Forum: dotConnect for Oracle
Topic: Unable to Load Devart.Data.Oracle.dll on IIS7
Replies: 3
Views: 2437

Unable to Load Devart.Data.Oracle.dll on IIS7

when i Deploy the Web Site to IIS7.5 i am getting Error, Unable to load Devart.Data.Oracle.dll.

Devart was installed properly using the installation.

How to get it working.
by nssidhu
Tue 19 Oct 2010 16:07
Forum: dotConnect for Oracle
Topic: Error when Adding View from Oracle DB
Replies: 1
Views: 1604

Error when Adding View from Oracle DB

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.
by nssidhu
Tue 07 Sep 2010 15:06
Forum: Entity Framework support
Topic: How to do DBUnit Test using VS2010
Replies: 1
Views: 1717

How to do DBUnit Test using VS2010

How can Create DBUnit Test for Oracle.

I am using Devart(dotConnect) as Drive for Entity Fram work & VS 2010

when i create new unit Test, it does not provide any option to connect to Oracle DB
by nssidhu
Tue 23 Feb 2010 18:43
Forum: dotConnect for Oracle
Topic: Cannot Created Domain Service Class from Entity Model
Replies: 3
Views: 2079

I was able to figure it out, i had some other bug, which preventing compilation .
by nssidhu
Tue 23 Feb 2010 18:39
Forum: dotConnect for Oracle
Topic: Cannot Created Domain Service Class from Entity Model
Replies: 3
Views: 2079

Cannot Created Domain Service Class from Entity Model

I created Devart Entity Model using , now when i try to create Domain Service Class, it does not provide option to create doamin service class from the Devart Entity Model.

I am creating silverlight Application and re-writing the MIX 09 example for
"Silverlight Business APP" using Oracel Backend as prototype for Decission making.

Am i missing anything ?