MVC将Oracle DB与实体框架连接字符串错误集成 [英] MVC Integrating Oracle DB with Entity Framework Connection string error

问题描述

您好，



我有一个将Oracle数据库与实体框架集成的MVC应用程序。



当我从服务器上的应用程序连接到服务器上的数据库时，我收到以下错误。



ORA-1034：Oracle不可用。



我已经实现了另一个没有实体框架的相同类型的应用程序，两者之间唯一不同的是Web.Config中的连接字符串。



有没有办法解决这个问题？



MVC应用程序和实体框架的连接字符串 - 本地工作正常但不在服务器上。

 connectionString =metadata = res：//*/Model.csdl | res：//*/Model.ssdl | res：//*/Model.msl; provider = Oracle.DataAccess.Client; provider connection string =& quot; DATA SOURCE = test; PASSWORD = xxx; PERSIST SECURITY INFO = True; USER ID = LOCAL& quot; 

没有实体框架的MVC应用程序的连接字符串

 connectionString =数据源= test; Initial Catalog = Exam; Persist Security Info = True; User ID = exam; Password = xxx; Connect Timeout = 300/> 

任何帮助都可以。



问候

D

解决方案

< blockquote> Link1

Link2

Link3

[已解决]



管理员必须解决的tnsnames存在问题。

Hi there,

I hav a MVC application integrating an Oracle DB with Entity Framework.

When I connect to the db on the server from the application on the server I get the following error.

ORA-1034 : Oracle not available.

I have implemented another application of the same type without Entity Framework and the only thing that is different between the two are there connection strings in the Web.Config.

Is there by any chance a workaround for this?

Connection String for MVC application and Entity Framework - Locally this works fine but not on the server.

connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=Oracle.DataAccess.Client;provider connection string="DATA SOURCE=test;PASSWORD=xxx;PERSIST SECURITY INFO=True;USER ID=LOCAL"" 

Connection String for MVC application without Entity Framework

connectionString="Data Source=test;Initial Catalog=Exam;Persist Security Info=True;User ID=exam;Password=xxx;Connect Timeout=300"/>

Any help would do.

Regards
D

解决方案

Link1
Link2
Link3

[Solved]

Had problems with the tnsnames which the administrator had to resolve.

这篇关于MVC将Oracle DB与实体框架连接字符串错误集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！