Devart Forums

Do we need to reference the DevArt.Data.Oracle dll's in our project or just place them in the bin folder upon deployment?

We are trying to test our newly deployed application on a web server and keep receiving the following errors when trying to establish a connection to the Oracle Server:






An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
at OciDynamicType.nativea(Int32 )
at OciDynamicType.a(Int32 )
at Devart.Data.Oracle.al..ctor(Boolean A_0, Boolean A_1, OracleHome A_2)
at Devart.Data.Oracle.al.a(Boolean A_0, Boolean A_1, OracleHome A_2)
at Devart.Data.Oracle.OracleInternalConnection..ctor(x connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.by.a(h A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, h A_1)
at Devart.Common.DbConnectionPool.a()
at Devart.Common.DbConnectionPool.GetObject()
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Data.Oracle.OracleConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
System.BadImageFormatException

The underlying provider failed on Open.
.GetEnumerator()
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.b__2[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
at Rosetta.Amp.Services.Profile.Data.ProfileServiceDataAdapter.GetEntityProfileByGUID(Guid profileGuid)
at Rosetta.Amp.Services.Profile.Data.ProfileServiceDataAdapter.GetProfileByGuid(Guid profileGuid)
at Rosetta.Amp.Services.Profile.Strategies.ProfileServiceSimpleStrategy.GetProfilesByProfileId(ProfileResult profileResult)
at Rosetta.Amp.Services.Profile.Strategies.ProfileServiceSimpleStrategy.GetProfilesById(GetProfilesByIdRequest request, GetProfilesByIdResponse response)
at Rosetta.Amp.Services.Profile.Service.ProfileServiceContext.GetProfilesById(GetProfilesByIdRequest getByIdRequest)
at Rosetta.Amp.Services.Profile.Service.ProfileServiceDispatcher.GetProfilesById(GetProfilesByIdRequest getByIdRequest)
at SyncInvokeGetProfilesById(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)]]>
System.Data.EntityException


The server that this is running against is Windows 2008 64-bit OS. We can easily switch back to SQL Server and have it work, so we know it is not a 64/32 bit issue.

The installation process order was
DevArt Professional Trial
Oracle Instant Client
Oracle Administrator Client

What ideas do you think could be causing the above issue? We use the same connection string locally on our development machines and have no problems getting things to run.

Good thing I came back and read this. I didn't realize that you said it would be bool in the SSDL. Thanks.

I tried using the number data type. I can't regenerate the model from the oracle schema at the moment, but would expect the below line to validate in my SSDL:



The error that I get when running ValidateArtifacts against this is

error 0040: The Type number is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.

Any idea why it isn't recognizing the number data type?

I'm getting the error

error 2019: Member Mapping specified is not valid. The type 'EdmBoolean[Nullable=false,DefaultValue=] of member 'IsDefault' in type 'TypeX' is not compatible with 'Devart.Data.Oracle.decimal[Nullable=false,DefaultValue=0,Precision=1,Scale=0]

I tried using the NUMBER data type with a precision of 1, scale of 0, but NUMBER is not recognized.

Which ssdl type do I need for conversion from boolean to oracle data type?

What are you referring to when you mention modify the StoreGeneratedPattern attribute on the property element? I see it exists for my SQL Server Data Model. Can I just add that to my Oracle Data Model and everything should work?