Devart Forums

Emily

I can't seem to connect my application that runs on Windows Server that is accessed via the web (ASP.NET MVC) to an Oracle instance that runs on Linux.

I have the following in the web.config:

Code: Select all

<connectionStrings>
<add name="ProjectEntities" connectionString="metadata=res://*/XModel.csdl|res://*/XModel.ssdl|res://*/XModel.msl; provider=Devart.Data.Oracle; provider connection string='Server=PROD;Persist Security Info=True'" providerName="System.Data.EntityClient" />
</connectionStrings>
...
<authentication mode="Windows" />

---------------
I also disabled Anonymous Access on ISS and checked Windows Authentication.

I even tried trying to set and kept on getting 'provider failed to open' message.

My application works if I include credentials in the connection string. I can even log onto that server and use SQL*Plus to try /@PROD and that works.

Am I able to do this with your Oracle dotConnect?

Emily

I am using ASP.NET DataSets and want to use impersonation, i.e. not set userID or password. I know the web server can identify the user, but my connection string must be wrong.

this.connection.ConnectionString = "Persist Security Info=True;Data Source=ServerX;";

Can you please help me?

Emily

Hello -

I would like to use dbMonitor to see what is going through to the database in my Silverlight 3.0 applications. I am currently using WCF Data Services as the web service layer and Entity Framework 1.0. Is this possible? I tried looking for a sample in the dotConnect samples that is installed on my PC, but couldn't find one.

Or if this is not possible with dbMonitor, is there another way to trace the SQL from my Silverlight/EF application?

Any and all advice will be greatly appreciated.

Emily

Here's my setup: I am using EF v1, dotConnect for Oracle (latest), and ASP.NET. I want to use Integrated Windows Authentication and pass those credentials to Oracle (Linux).

When I first created my EF model, EF threw this into the .config file:

Code: Select all

This is a general account. When I deploy my application, I want to use WIndows Authentication to send over those credentials to Oracle. How can I do that? I'm assuming I have to edit my connectionString?

This works fine if I have Windows Authentication set to off (unchecked) and I can perform all CRUD, but now I want impersonation in place and thus when I turn WIndows Authentication on, my queries fail.

Emily

I am trying to take advantage of ASP.NET's Dynamic Data framework using dotConnect for Oracle.

I have a project that has my Model, i.e. my Entity Framework EDM, created using dotConnect for Oracle. This works great using other UI technologies.

Now, I want to see how I can hook up this Dynamic Data technology, but when I hook my DataContext of the Model, which is ProjectXEntities.

I threw this in the Global.asax.cs file:

Code: Select all

model.RegisterContext(typeof(ProjectXEntities), new ContextConfiguration() { ScaffoldAllTables = true });

And when I run it, I get the following error via the ASP.NET page:

The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.

And it points to line 46:

Code: Select all

Line 44:        /// Initializes a new ProjectXEntities object using the connection string found in the ProjectXEntities section of the application configuration file.
Line 45:        /// 
Line 46:        public ProjectXEntities() : 
Line 47:                base("name=ProjectXEntities", "ProjectXEntities")
Line 48:        {

So I have to projects, one containing my Model and the other containing my ASP.NET project.

Do you have any tutorials regarding Dynamic Data by the way?

Thanks!

Emily

I don't believe that's the issue.

In Visual Studio 2008, within the project where I have the EDMX file hosted, I look under the References and took a look at the path for System.Data.Entity and it is: C:\WINDOWS\assembly\GAC_MSIL\System.Data.Entity\3.5.0.0__b77a5c561934e089\System.Data.Entity.dll.

I then looked at my C:\windows\assembly directory and the dll is indeed there.

I then opened 'regedit' and did a 'Find" for the System.Data.Entity.dll and it found it within HKEY_LOCAL_MACHINE --> SOFTWARE --> Classes --> c:|Program Files|Reference Assemblies|Microsoft|Framework|v3.5|System.Data.Entity.dll.

Once again, I've always been able to create and consume models using Visual Studio but have never been able to generate via Entity Developer. I believe I've gone through 3 revisions of the product. What else could it be?

Please help.

Emily

AndreyR:

I do have it. Like I noted, I've been developing Entity Framework-based applications for a while but have NEVER been able to get Entity Developer working, i.e. once I press the generate code button. I can generated the pertinent class files via Visual Studio.

I want to harness the robustness of the Entity Developer tool.

Please help.

Emily

When I try to generate code for my model, I get the following error using Entity Developer:
--------------------
An error occurred during an attempt to compile the template.
Error List:
error : Metadata file 'System.Data.Entity.dll' could not be found
error : Metadata file 'System.Data.Entity.Design.dll' could not be found
--------------------
I've uninstalled my dotConnect software, even manually deleted the registry keys, and reinstalled everything and I still get this error. I've never been able to generate code via my Entity Developer tool.

I've only been able to successfully create code via my EDM via VS 2008. I've been using dotConnect for Oracle since version 5.25.49 and Entity Developer since 2.20.43. I am currently using the latest build (Beta 2.80.82) and still no luck!

Please help.

Emily

Devart,

I am using version (5.35.79) and received the following error when trying to generate some numeric fields:

Error 1 Error 2019: Member Mapping specified is not valid. The type 'Edm.String[Nullable=True,DefaultValue=,MaxLength=,Unicode=,FixedLength=]' of member 'OBJECT_LENGTH' in type 'TestObject' is not compatible with 'Devart.Data.Oracle.decimal[Nullable=True,DefaultValue=,Precision=29,Scale=15]' of member 'OBJECT_LENGTH' in type 'TestObject'. C:\xxx\xxx\CompanyTestModel.edmx

This is the second error I've submitted showing things are not compatible. Is there a quick turnaround I could do on my end to get up and running?

Emily

I just downloaded the latest version today and this problem still persists. Any update on this issue?

Emily

Devart,

My organization is heavily invested using SDO_GEOMETRY and such spatial data. Any plans for Devart to have this implemented. Me work for big organization, so very important when considering dotConnect.

Emily

Devart,

Any update on this issue? With this error in place, I can't seem to use your EDM Designer due to always erroring out.

Emily

Default value (systimestamp ) is not valid for DateTimeOffset. The value must be in the form 'yyyy-MM-dd HH:mm:ss.fffffffz'.

----------------------

I just upgraded to the latest dotConnect version (5.35) and when using the latest EF Developer (2.50.50), I get the above error when dropping a table from Oracle with a timestamp field. This error was not being generated in the previous version.

FYI, the field in the Oracle table has default value set to 'systimestamp' and is of type 'TIMESTAMP(6) WITH TIME ZONE'.

Devart Forums

Search found 13 matches

AD Authentication to Oracle

ASP.NET DataSet Connection String with Impersonation

Silverlight w/ Entity Framework - How to use dbMonitor?

Oracle ASP.NET impersonation

ASP.NET Dynamic Data Entities Web Application - Error

Generate Code Error - Metadata file 'System.Data.Entity.dll'

Member Mapping is not valid. The type 'Edm.String[Nullable=T

Error - Default value (systimestamp) is not valid for DateTi