Devart Forums

I do the same thing with Orace driver (MSFT) and it work perfectly !

Sample code

var command = model.Connection.CreateCommand();
command.Connection.Open();
var tns = model.Connection.BeginTransaction();

command.Connection = model.Connection;

command.CommandType = CommandType.Text;
command.CommandText = @"ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';";
command.Transaction = tns;
command.Parameters.Clear();

command.ExecuteNonQuery();

I use 2.20.43 (trial) and I have the same problem ?!?

And the model is int the root ...

Or I do something wrong ?

I do that :
var j = new DataSourceModel1Entities();


I got an error there...


public partial class DataSourceModel1Entities : global::System.Data.Objects.ObjectContext
{
///
/// Initialize a new DataSourceModel1Entities object.
///
public DataSourceModel1Entities() :
base(@"name=NetbackmodelConnectionString", "DataSourceModel1Entities") {
this.OnContextCreated();
}


Error : (EmbedInOutputAssembly)
Unable to load the specified metadata resource.

Error :(CopyToOutputDirectory)

System.Data.MetadataException was unhandled
Message="The specified metadata path is not valid. A valid path must be either an existing directory, an existing file with extension '.csdl', '.ssdl', or '.msl', or a URI that identifies an embedded resource."
Source="System.Data.Entity"
StackTrace:
at System.Data.Metadata.Edm.MetadataArtifactLoader.Create(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver)
at System.Data.EntityClient.EntityConnection.SplitPaths(String paths)
at System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections)
at System.Data.Objects.ObjectContext.RetrieveMetadataWorkspaceFromConnection()
at System.Data.Objects.ObjectContext..ctor(EntityConnection connection, Boolean isConnectionConstructor)
at System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName)
at Netbackmodel.DataSourceModel1Entities..ctor() in C:\Dev\Test\db test\db test\DataSourceModel1.Designer.cs:line 21
at db_test.Program.Main(String[] args) in C:\Dev\Test\db test\db test\Program.cs:line 14
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:



Any idea?

AndreyR wrote:No Oracle 8 support is planned in the nearest future.

It's a joke ? On your web site specify you support 8i Oracle :!::!:




http://www.devart.com/oranet/

Compatibility

OraDirect .NET supports Oracle servers 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions. OraDirect .NET supports both x86 and x64 versions of the following Oracle clients: 11g, 10g, 9i, 8i and 8.0. The provider works with .NET Framework 1.0, 1.1, 2.0, 3.0, 3.5, and .NET Compact Framework 1.1 and 2.0, and can be used with the following development environments:

Hi,

I tried with a 10g Oracle DB and all seem work ...
I tried with a 8i Oracle DB and all seem NOT work ...
(http://devart.com/forums/viewtopic.php?p=38816#38816)

And my concert is I need a provider support really 8i ....

OraDirect.net support or not Oracle 8i ?

I tried with a 10.1 oracle DB ...and it's work ...

So I understand you didn't support Oracle 8i!

Hello ?!

Anybody could help me ? I try with Oracle client 10.2 ... and same error ...

Need help fast ... we are in evaluate processus from a Oracle provider for Entity Framework, and we need a quick answer ...

Setup............
Visual studio 2008 SP1 (Release)
OraDirect .net 4.75.42
OraDevelopper (latest)
Oracle 8i


PART1.........................................

Add
New Item
Ado.net Entity Data Model
Generate from database
Next
New Connection
Server : xxx1.16.4800
user ....
pw ...
home : OraHome81

Test Connection : Succeeded
OK
Select Yes , include the sensitive ....
Next


An error occured while connecting to the database.
The database might be unavailable.
An exception of type 'System.data.providerIncompatibleException' Ocurred.
The error message is : 'The provider did not return a providerManifestToken string.
The Inner exception caught was of type ' System.NotSupportedException',
with this error message: 'Entity framework is supported for Oracle server version 9.2 or higher'.'.



I setup the same stuff with oracleDevelopper and I can create connection and browse schema & tables.


PART2.........................................

Other bug ... if tns name server contain '.' your Server combobox I have only the first part.
ex.:

Dev1.99.0001
Dev1.99.0002
Dev1.99.0003

I see in Server ComboBox
Dev1
Dev1
Dev1