I am trying to connect directly to the server with the following connection information in my web.config file (obfuscated of course):
Code: Select all
<add name="AuthorizationEntities"
connectionString="metadata= res://Config.Domain/DataModels.Authorization.AuthorizationDataModel.csdl|
res://Config.Domain/DataModels.Authorization.AuthorizationDataModel.ssdl|
res://Config.Domain/DataModels.Authorization.AuthorizationDataModel.msl;
provider=Devart.Data.Oracle;
provider connection string="User Id=fake_name;Password=********;Server=someserver.xx.boeing.com;Port=1521;Service Name=tango.boeingdb;Direct=True;""Code: Select all
[FormatException: Input string was not in a correct format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +10689507
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +145
System.Convert.ToInt32(String value) +43
Devart.Data.Oracle.cx.a() +111
Devart.Data.Oracle.b2.a(String A_0, Int32 A_1, String A_2, String A_3) +490
Devart.Data.Oracle.c7.a(b6 A_0, Boolean A_1) +108
Devart.Data.Oracle.c7.a(b6 A_0, o A_1) +112
Devart.Data.Oracle.OracleInternalConnection..ctor(b6 connectionOptions, OracleInternalConnection proxyConnection) +453
Devart.Data.Oracle.an.a(p A_0, Object A_1, DbConnectionBase A_2) +114
Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, p A_1, DbConnectionBase A_2) +228
Devart.Common.DbConnectionPool.a(DbConnectionBase A_0) +45
Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection) +916
Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0) +148
Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection) +130
Devart.Common.DbConnectionBase.Open() +257
Devart.Data.Oracle.OracleConnection.Open() +235
System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +44
[EntityException: The underlying provider failed on Open.]
System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +203
System.Data.EntityClient.EntityConnection.Open() +104
System.Data.Objects.ObjectContext.EnsureConnection() +75
System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +41
System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator() +36
System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source) +152
System.Data.Objects.ELinq.ObjectQueryProvider.b__1(IEnumerable`1 sequence) +41
System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable`1 query, Expression queryRoot) +59
System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +133
System.Linq.Queryable.FirstOrDefault(IQueryable`1 source, Expression`1 predicate) +287
Config.Domain.Repositories.EntityRepository`1.Single(Expression`1 expression) in A:\gide-tfs.web.boeing.com\CAS IT TnFS Config\Main\Configurator.Domain\Repositories\EntityRepository.cs:26
Config.Domain.Providers.ConfigRoleProvider.GetRolesForUser(String bemsidString) in A:\gide-tfs.web.boeing.com\CAS IT TnFS Config\Main\Configurator.Domain\Providers\ConfigRoleProvider.cs:172
System.Web.Security.Roles.GetRolesForUser(String username) +329
Config.Domain.DataModels.Authorization.ConfigMembershipUser..ctor(MembershipUser user) in A:\gide-tfs.web.boeing.com\CAS IT TnFS Config\Main\Configurator.Domain\DataModels\Authorization\ConfigMembershipUser.cs:74
Config.Web.Areas.Accounts.ConfigAuthorizeAttribute.AuthorizeCore(HttpContextBase httpContext) in A:\gide-tfs.web.boeing.com\CAS IT TnFS Config\Main\Configurator.Web\Areas\Accounts\ConfigAuthorizeAttribute.cs:33
System.Web.Mvc.AuthorizeAttribute.OnAuthorization(AuthorizationContext filterContext) +39
System.Web.Mvc.ControllerActionInvoker.InvokeAuthorizationFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor) +97
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +324
System.Web.Mvc.Controller.ExecuteCore() +105
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +42
System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
System.Web.Mvc.c__DisplayClass8.b__4() +31
System.Web.Mvc.Async.c__DisplayClass1.b__0() +19
System.Web.Mvc.Async.c__DisplayClass8`1.b__7(IAsyncResult _) +10
System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +43
System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9629708
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155Code: Select all
using System;
using System.Collections.Generic;
using Devart.Data.Oracle;
using System.Linq;
using System.Text;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
string username = "fake_name";
string password = "********";
string server = "someserver.xx.boeing.com";
int port = 1521;
bool direct = true;
string svcName = "tango.boeingdb";
StringBuilder sb = new StringBuilder();
sb.AppendFormat("User Id={0};", username)
.AppendFormat("Password={0};", password)
.AppendFormat("Server={0};", server)
.AppendFormat("Port={0};", port.ToString())
.AppendFormat("Direct={0};", direct.ToString())
.AppendFormat("Service Name={0}", svcName);
OracleConnection conn = new OracleConnection(sb.ToString());
conn.Open();
Console.Write(conn.ServerVersion);
Console.ReadLine();
}
}
}