"John Yung" wrote:

> All,
>
> I am running a middle tier component (MarshalByRefObject) as a Windows Service (the Windows Service starts a Console Application which hosts the Middle Tier component). When the services is running under a non-64bit machine, it runs without any problems (accepts client connections and API calls).
>
> However, when running on a 64bit Win 2003 server, I am getting the the "Unable to find the requested .Net Framework Data Provider.  It may not be installed." error. I am running Microsoft Windows Services 2003 Standard x64 Edition. I compiled the software using "Any CPU" setting. I am also getting the error if I start the console application directly.
>
> The following contains error information (check InnerException).
>
> Error Message:
> Exception has been thrown by the target of an invocation.
>
> Error Source:
> mscorlib:
>
> Error StackTrace:
> Server stack trace:
>    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
>    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
>    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
>    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
>    at System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWellKnownObject(String asmName, String svrTypeName, String URI, WellKnownObjectMode mode, Boolean fReplace)
>    at System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWellKnownObject(String URI)
>    at System.Runtime.Remoting.IdentityHolder.CasualResolveIdentity(String uri)
>    at System.Runtime.Remoting.Messaging.MethodCall.ResolveType()
>    at System.Runtime.Remoting.Messaging.MethodCall.ResolveMethod(Boolean bThrowIfNotResolved)
>    at System.Runtime.Remoting.Messaging.MethodCall..ctor(Object handlerObject, BinaryMethodCallMessage smuggledMsg)
>    at System.Runtime.Serialization.Formatters.Binary.BinaryMethodCall.ReadArray(Object[] callA, Object handlerObject)
>    at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
>    at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
>    at System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryRequestMessage(String objectUri, Stream inputStream, Boolean bStrictBinding, TypeFilterLevel securityLevel)
>    at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
>
> Exception rethrown at [0]:
>    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
>    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
>    at SAC.DataServices.EventServer.AttachClient(EventClient eventClient)
>    at SAC.DataServices.EventClient.gI() in C:\CSharp\EventServerClient\EventClient.cs:line 22
>   Inner Exception:
>   Error Message:
>   Unable to find the requested .Net Framework Data Provider.  It may not be installed.
>
>   Error Source:
>   System.Data
>
>   Error StackTrace:
>      at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
>      at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetDefaultMapping(String name, String dbProviderName)
>      at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetProviderMapping(String name, String dbProviderName)
>      at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
>      at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)
>      at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)
>      at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)
>      at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfigurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)
>      at Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies)
>      at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies)
>      at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadWriteLocator locator, String idToBuild, Object existing, PolicyList[] transientPolicies)
>      at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator, IConfigurationSource configurationSource)
>      at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](IConfigurationSource configurationSource)
>      at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T]()
>      at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase()
>      at SAC.DataServices.CorpAction.WithholdingTax.BizSvr..ctor()
>
> Please advice, Thanks,
>
> John Yung

> >      at SAC.DataServices.CorpAction.WithholdingTax.BizSvr..ctor()
> >
> > Please advice, Thanks,
> >
> > John Yung

"John Yung" wrote:

> Ken,
>
> I compiled the code under "Any CPU" setting in VS.NET 2005 and our backend
> is a MS SQL 2000 with SP4 (32bit) DB. Thus, I don't think it is trying to
> use 64bit version of odbc. What makes you think it is trying to use a 64bit
> version of odbc?
>
> Thanks,
>
> John Yung
>
> "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in message
> news:6CF926A3-CB35-48A8-8890-DFDE125A290E@microsoft.com...
> > Hi,
> >
> >         Sorry there are not any 64bit versions of the odbc drivers.  You
> > need to compile the application for x86 to force the computer to use the
> > 32bit drivers.
> >
> > I made a suggestion in the msdn product feed back center for a 64bit
> version
> > of odbc.  Please vote for it.
> >
> >
> http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=a533f823-73a1-40e8-9380-d25b58ce8ae8
> >
> > Ken
> > http://www.vb-tips.com
> > ---------------------------
> >
> >
> > "John Yung" wrote:
> >
> > > All,
> > >
> > > I am running a middle tier component (MarshalByRefObject) as a Windows
> Service (the Windows Service starts a Console Application which hosts the
> Middle Tier component). When the services is running under a non-64bit
> machine, it runs without any problems (accepts client connections and API
> calls).
> > >
> > > However, when running on a 64bit Win 2003 server, I am getting the the
> "Unable to find the requested .Net Framework Data Provider.  It may not be
> installed." error. I am running Microsoft Windows Services 2003 Standard x64
> Edition. I compiled the software using "Any CPU" setting. I am also getting
> the error if I start the console application directly.
> > >
> > > The following contains error information (check InnerException).
> > >
> > > Error Message:
> > > Exception has been thrown by the target of an invocation.
> > >
> > > Error Source:
> > > mscorlib:
> > >
> > > Error StackTrace:
> > > Server stack trace:
> > >    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> ctor, Boolean& bNeedSecurityCheck)
> > >    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> fillCache)
> > >    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> skipVisibilityChecks, Boolean fillCache)
> > >    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> > >    at
> System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
> KnownObject(String asmName, String svrTypeName, String URI,
> WellKnownObjectMode mode, Boolean fReplace)
> > >    at
> System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
> KnownObject(String URI)
> > >    at
> System.Runtime.Remoting.IdentityHolder.CasualResolveIdentity(String uri)
> > >    at System.Runtime.Remoting.Messaging.MethodCall.ResolveType()
> > >    at System.Runtime.Remoting.Messaging.MethodCall.ResolveMethod(Boolean
> bThrowIfNotResolved)
> > >    at System.Runtime.Remoting.Messaging.MethodCall..ctor(Object
> handlerObject, BinaryMethodCallMessage smuggledMsg)
> > >    at
> System.Runtime.Serialization.Formatters.Binary.BinaryMethodCall.ReadArray(Ob
> ject[] callA, Object handlerObject)
> > >    at
> System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(Head
> erHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean
> isCrossAppDomain, IMethodCallMessage methodCallMessage)
> > >    at
> System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(S
> tream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean
> isCrossAppDomain, IMethodCallMessage methodCallMessage)
> > >    at
> System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryRequestMessage
> (String objectUri, Stream inputStream, Boolean bStrictBinding,
> TypeFilterLevel securityLevel)
> > >    at
> System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IS
> erverChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders
> requestHeaders, Stream requestStream, IMessage& responseMsg,
> ITransportHeaders& responseHeaders, Stream& responseStream)
> > >
> > > Exception rethrown at [0]:
> > >    at
> System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
> reqMsg, IMessage retMsg)
> > >    at
> System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
> msgData, Int32 type)
> > >    at SAC.DataServices.EventServer.AttachClient(EventClient eventClient)
> > >    at SAC.DataServices.EventClient.gI() in
> C:\CSharp\EventServerClient\EventClient.cs:line 22
> > >   Inner Exception:
> > >   Error Message:
> > >   Unable to find the requested .Net Framework Data Provider.  It may not
> be installed.
> > >
> > >   Error Source:
> > >   System.Data
> > >
> > >   Error StackTrace:
> > >      at System.Data.Common.DbProviderFactories.GetFactory(String
> providerInvariantName)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetDefa
> ultMapping(String name, String dbProviderName)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetProv
> iderMapping(String name, String dbProviderName)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObjec
> t(IBuilderContext context, String name, IConfigurationSource
> configurationSource, ConfigurationReflectionCache reflectionCache)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
> figuredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object
> existing, String id)
> > >      at
> Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
> context, Type typeToBuild, Object existing, String idToBuild)
> > >      at
> Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
> context, Type typeToBuild, Object existing, String idToBuild)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
> figurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t,
> Object existing, String id)
> > >      at
> Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator
> locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
> transientPolicies)
> > >      at
> Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator
> locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
> transientPolicies)
> > >      at
> Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadW
> riteLocator locator, String idToBuild, Object existing, PolicyList[]
> transientPolicies)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> erpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator,
> IConfigurationSource configurationSource)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> erpriseLibraryFactory.BuildUp[T](IConfigurationSource configurationSource)
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> erpriseLibraryFactory.BuildUp[T]()
> > >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase()
> > >      at SAC.DataServices.CorpAction.WithholdingTax.BizSvr..ctor()
> > >
> > > Please advice, Thanks,
> > >
> > > John Yung
>
>
>

"John Yung" <jo***@sac.com> wrote in message
news:uNsXWC$CGHA.2644@TK2MSFTNGP09.phx.gbl...
> Ken,
>
> I compiled the code under "Any CPU" setting in VS.NET 2005 and our backend
> is a MS SQL 2000 with SP4 (32bit) DB. Thus, I don't think it is trying to
> use 64bit version of odbc. What makes you think it is trying to use a
> 64bit
> version of odbc?
>
> Thanks,
>
> John Yung
>
> "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in
> message
> news:6CF926A3-CB35-48A8-8890-DFDE125A290E@microsoft.com...
>> Hi,
>>
>>         Sorry there are not any 64bit versions of the odbc drivers.  You
>> need to compile the application for x86 to force the computer to use the
>> 32bit drivers.
>>
>> I made a suggestion in the msdn product feed back center for a 64bit
> version
>> of odbc.  Please vote for it.
>>
>>
> http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=a533f823-73a1-40e8-9380-d25b58ce8ae8
>>
>> Ken
>> http://www.vb-tips.com
>> ---------------------------
>>
>>
>> "John Yung" wrote:
>>
>> > All,
>> >
>> > I am running a middle tier component (MarshalByRefObject) as a Windows
> Service (the Windows Service starts a Console Application which hosts the
> Middle Tier component). When the services is running under a non-64bit
> machine, it runs without any problems (accepts client connections and API
> calls).
>> >
>> > However, when running on a 64bit Win 2003 server, I am getting the the
> "Unable to find the requested .Net Framework Data Provider.  It may not be
> installed." error. I am running Microsoft Windows Services 2003 Standard
> x64
> Edition. I compiled the software using "Any CPU" setting. I am also
> getting
> the error if I start the console application directly.
>> >
>> > The following contains error information (check InnerException).
>> >
>> > Error Message:
>> > Exception has been thrown by the target of an invocation.
>> >
>> > Error Source:
>> > mscorlib:
>> >
>> > Error StackTrace:
>> > Server stack trace:
>> >    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> ctor, Boolean& bNeedSecurityCheck)
>> >    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> fillCache)
>> >    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> skipVisibilityChecks, Boolean fillCache)
>> >    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
>> >    at
> System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
> KnownObject(String asmName, String svrTypeName, String URI,
> WellKnownObjectMode mode, Boolean fReplace)
>> >    at
> System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
> KnownObject(String URI)
>> >    at
> System.Runtime.Remoting.IdentityHolder.CasualResolveIdentity(String uri)
>> >    at System.Runtime.Remoting.Messaging.MethodCall.ResolveType()
>> >    at
>> > System.Runtime.Remoting.Messaging.MethodCall.ResolveMethod(Boolean
> bThrowIfNotResolved)
>> >    at System.Runtime.Remoting.Messaging.MethodCall..ctor(Object
> handlerObject, BinaryMethodCallMessage smuggledMsg)
>> >    at
> System.Runtime.Serialization.Formatters.Binary.BinaryMethodCall.ReadArray(Ob
> ject[] callA, Object handlerObject)
>> >    at
> System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(Head
> erHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean
> isCrossAppDomain, IMethodCallMessage methodCallMessage)
>> >    at
> System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(S
> tream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean
> isCrossAppDomain, IMethodCallMessage methodCallMessage)
>> >    at
> System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryRequestMessage
> (String objectUri, Stream inputStream, Boolean bStrictBinding,
> TypeFilterLevel securityLevel)
>> >    at
> System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IS
> erverChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders
> requestHeaders, Stream requestStream, IMessage& responseMsg,
> ITransportHeaders& responseHeaders, Stream& responseStream)
>> >
>> > Exception rethrown at [0]:
>> >    at
> System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
> reqMsg, IMessage retMsg)
>> >    at
> System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
> msgData, Int32 type)
>> >    at SAC.DataServices.EventServer.AttachClient(EventClient
>> > eventClient)
>> >    at SAC.DataServices.EventClient.gI() in
> C:\CSharp\EventServerClient\EventClient.cs:line 22
>> >   Inner Exception:
>> >   Error Message:
>> >   Unable to find the requested .Net Framework Data Provider.  It may
>> > not
> be installed.
>> >
>> >   Error Source:
>> >   System.Data
>> >
>> >   Error StackTrace:
>> >      at System.Data.Common.DbProviderFactories.GetFactory(String
> providerInvariantName)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetDefa
> ultMapping(String name, String dbProviderName)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetProv
> iderMapping(String name, String dbProviderName)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObjec
> t(IBuilderContext context, String name, IConfigurationSource
> configurationSource, ConfigurationReflectionCache reflectionCache)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
> figuredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object
> existing, String id)
>> >      at
> Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
> context, Type typeToBuild, Object existing, String idToBuild)
>> >      at
> Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
> context, Type typeToBuild, Object existing, String idToBuild)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
> figurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t,
> Object existing, String id)
>> >      at
> Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator
> locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
> transientPolicies)
>> >      at
> Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator
> locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
> transientPolicies)
>> >      at
> Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadW
> riteLocator locator, String idToBuild, Object existing, PolicyList[]
> transientPolicies)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> erpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator,
> IConfigurationSource configurationSource)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> erpriseLibraryFactory.BuildUp[T](IConfigurationSource configurationSource)
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> erpriseLibraryFactory.BuildUp[T]()
>> >      at
> Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase()
>> >      at SAC.DataServices.CorpAction.WithholdingTax.BizSvr..ctor()
>> >
>> > Please advice, Thanks,
>> >
>> > John Yung
>
>

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message news:u%23hbfRODGHA.628@TK2MSFTNGP14.phx.gbl...
> Hi,
>
>         I am trying to figure out this problem.  What version of the
> enterprise application blocks are you using?
>
> Ken
> ------------------
> "John Yung" <jo***@sac.com> wrote in message
> news:uNsXWC$CGHA.2644@TK2MSFTNGP09.phx.gbl...
> > Ken,
> >
> > I compiled the code under "Any CPU" setting in VS.NET 2005 and our backend
> > is a MS SQL 2000 with SP4 (32bit) DB. Thus, I don't think it is trying to
> > use 64bit version of odbc. What makes you think it is trying to use a
> > 64bit
> > version of odbc?
> >
> > Thanks,
> >
> > John Yung
> >
> > "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in
> > message
> > news:6CF926A3-CB35-48A8-8890-DFDE125A290E@microsoft.com...
> >> Hi,
> >>
> >>         Sorry there are not any 64bit versions of the odbc drivers.  You
> >> need to compile the application for x86 to force the computer to use the
> >> 32bit drivers.
> >>
> >> I made a suggestion in the msdn product feed back center for a 64bit
> > version
> >> of odbc.  Please vote for it.
> >>
> >>
> > http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=a533f823-73a1-40e8-9380-d25b58ce8ae8
> >>
> >> Ken
> >> http://www.vb-tips.com
> >> ---------------------------
> >>
> >>
> >> "John Yung" wrote:
> >>
> >> > All,
> >> >
> >> > I am running a middle tier component (MarshalByRefObject) as a Windows
> > Service (the Windows Service starts a Console Application which hosts the
> > Middle Tier component). When the services is running under a non-64bit
> > machine, it runs without any problems (accepts client connections and API
> > calls).
> >> >
> >> > However, when running on a 64bit Win 2003 server, I am getting the the
> > "Unable to find the requested .Net Framework Data Provider.  It may not be
> > installed." error. I am running Microsoft Windows Services 2003 Standard
> > x64
> > Edition. I compiled the software using "Any CPU" setting. I am also
> > getting
> > the error if I start the console application directly.
> >> >
> >> > The following contains error information (check InnerException).
> >> >
> >> > Error Message:
> >> > Exception has been thrown by the target of an invocation.
> >> >
> >> > Error Source:
> >> > mscorlib:
> >> >
> >> > Error StackTrace:
> >> > Server stack trace:
> >> >    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
> > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
> > ctor, Boolean& bNeedSecurityCheck)
> >> >    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
> > fillCache)
> >> >    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
> > skipVisibilityChecks, Boolean fillCache)
> >> >    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
> >> >    at
> > System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
> > KnownObject(String asmName, String svrTypeName, String URI,
> > WellKnownObjectMode mode, Boolean fReplace)
> >> >    at
> > System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
> > KnownObject(String URI)
> >> >    at
> > System.Runtime.Remoting.IdentityHolder.CasualResolveIdentity(String uri)
> >> >    at System.Runtime.Remoting.Messaging.MethodCall.ResolveType()
> >> >    at
> >> > System.Runtime.Remoting.Messaging.MethodCall.ResolveMethod(Boolean
> > bThrowIfNotResolved)
> >> >    at System.Runtime.Remoting.Messaging.MethodCall..ctor(Object
> > handlerObject, BinaryMethodCallMessage smuggledMsg)
> >> >    at
> > System.Runtime.Serialization.Formatters.Binary.BinaryMethodCall.ReadArray(Ob
> > ject[] callA, Object handlerObject)
> >> >    at
> > System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(Head
> > erHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean
> > isCrossAppDomain, IMethodCallMessage methodCallMessage)
> >> >    at
> > System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(S
> > tream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean
> > isCrossAppDomain, IMethodCallMessage methodCallMessage)
> >> >    at
> > System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryRequestMessage
> > (String objectUri, Stream inputStream, Boolean bStrictBinding,
> > TypeFilterLevel securityLevel)
> >> >    at
> > System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IS
> > erverChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders
> > requestHeaders, Stream requestStream, IMessage& responseMsg,
> > ITransportHeaders& responseHeaders, Stream& responseStream)
> >> >
> >> > Exception rethrown at [0]:
> >> >    at
> > System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
> > reqMsg, IMessage retMsg)
> >> >    at
> > System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
> > msgData, Int32 type)
> >> >    at SAC.DataServices.EventServer.AttachClient(EventClient
> >> > eventClient)
> >> >    at SAC.DataServices.EventClient.gI() in
> > C:\CSharp\EventServerClient\EventClient.cs:line 22
> >> >   Inner Exception:
> >> >   Error Message:
> >> >   Unable to find the requested .Net Framework Data Provider.  It may
> >> > not
> > be installed.
> >> >
> >> >   Error Source:
> >> >   System.Data
> >> >
> >> >   Error StackTrace:
> >> >      at System.Data.Common.DbProviderFactories.GetFactory(String
> > providerInvariantName)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetDefa
> > ultMapping(String name, String dbProviderName)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetProv
> > iderMapping(String name, String dbProviderName)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObjec
> > t(IBuilderContext context, String name, IConfigurationSource
> > configurationSource, ConfigurationReflectionCache reflectionCache)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
> > figuredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object
> > existing, String id)
> >> >      at
> > Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
> > context, Type typeToBuild, Object existing, String idToBuild)
> >> >      at
> > Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
> > context, Type typeToBuild, Object existing, String idToBuild)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
> > figurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t,
> > Object existing, String id)
> >> >      at
> > Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator
> > locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
> > transientPolicies)
> >> >      at
> > Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator
> > locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
> > transientPolicies)
> >> >      at
> > Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadW
> > riteLocator locator, String idToBuild, Object existing, PolicyList[]
> > transientPolicies)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> > erpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator,
> > IConfigurationSource configurationSource)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> > erpriseLibraryFactory.BuildUp[T](IConfigurationSource configurationSource)
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
> > erpriseLibraryFactory.BuildUp[T]()
> >> >      at
> > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase()
> >> >      at SAC.DataServices.CorpAction.WithholdingTax.BizSvr..ctor()
> >> >
> >> > Please advice, Thanks,
> >> >
> >> > John Yung
> >
> >
>
>

  "Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message news:u%23hbfRODGHA.628@TK2MSFTNGP14.phx.gbl...
  > Hi,
  >
  >         I am trying to figure out this problem.  What version of the
  > enterprise application blocks are you using?
  >
  > Ken
  > ------------------
  > "John Yung" <jo***@sac.com> wrote in message
  > news:uNsXWC$CGHA.2644@TK2MSFTNGP09.phx.gbl...
  > > Ken,
  > >
  > > I compiled the code under "Any CPU" setting in VS.NET 2005 and our backend
  > > is a MS SQL 2000 with SP4 (32bit) DB. Thus, I don't think it is trying to
  > > use 64bit version of odbc. What makes you think it is trying to use a
  > > 64bit
  > > version of odbc?
  > >
  > > Thanks,
  > >
  > > John Yung
  > >
  > > "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in
  > > message
  > > news:6CF926A3-CB35-48A8-8890-DFDE125A290E@microsoft.com...
  > >> Hi,
  > >>
  > >>         Sorry there are not any 64bit versions of the odbc drivers.  You
  > >> need to compile the application for x86 to force the computer to use the
  > >> 32bit drivers.
  > >>
  > >> I made a suggestion in the msdn product feed back center for a 64bit
  > > version
  > >> of odbc.  Please vote for it.
  > >>
  > >>
  > > http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=a533f823-73a1-40e8-9380-d25b58ce8ae8
  > >>
  > >> Ken
  > >> http://www.vb-tips.com
  > >> ---------------------------
  > >>
  > >>
  > >> "John Yung" wrote:
  > >>
  > >> > All,
  > >> >
  > >> > I am running a middle tier component (MarshalByRefObject) as a Windows
  > > Service (the Windows Service starts a Console Application which hosts the
  > > Middle Tier component). When the services is running under a non-64bit
  > > machine, it runs without any problems (accepts client connections and API
  > > calls).
  > >> >
  > >> > However, when running on a 64bit Win 2003 server, I am getting the the
  > > "Unable to find the requested .Net Framework Data Provider.  It may not be
  > > installed." error. I am running Microsoft Windows Services 2003 Standard
  > > x64
  > > Edition. I compiled the software using "Any CPU" setting. I am also
  > > getting
  > > the error if I start the console application directly.
  > >> >
  > >> > The following contains error information (check InnerException).
  > >> >
  > >> > Error Message:
  > >> > Exception has been thrown by the target of an invocation.
  > >> >
  > >> > Error Source:
  > >> > mscorlib:
  > >> >
  > >> > Error StackTrace:
  > >> > Server stack trace:
  > >> >    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean
  > > publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle&
  > > ctor, Boolean& bNeedSecurityCheck)
  > >> >    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean
  > > fillCache)
  > >> >    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean
  > > skipVisibilityChecks, Boolean fillCache)
  > >> >    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
  > >> >    at
  > > System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
  > > KnownObject(String asmName, String svrTypeName, String URI,
  > > WellKnownObjectMode mode, Boolean fReplace)
  > >> >    at
  > > System.Runtime.Remoting.RemotingConfigHandler.RemotingConfigInfo.StartupWell
  > > KnownObject(String URI)
  > >> >    at
  > > System.Runtime.Remoting.IdentityHolder.CasualResolveIdentity(String uri)
  > >> >    at System.Runtime.Remoting.Messaging.MethodCall.ResolveType()
  > >> >    at
  > >> > System.Runtime.Remoting.Messaging.MethodCall.ResolveMethod(Boolean
  > > bThrowIfNotResolved)
  > >> >    at System.Runtime.Remoting.Messaging.MethodCall..ctor(Object
  > > handlerObject, BinaryMethodCallMessage smuggledMsg)
  > >> >    at
  > > System.Runtime.Serialization.Formatters.Binary.BinaryMethodCall.ReadArray(Ob
  > > ject[] callA, Object handlerObject)
  > >> >    at
  > > System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(Head
  > > erHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean
  > > isCrossAppDomain, IMethodCallMessage methodCallMessage)
  > >> >    at
  > > System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(S
  > > tream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean
  > > isCrossAppDomain, IMethodCallMessage methodCallMessage)
  > >> >    at
  > > System.Runtime.Remoting.Channels.CoreChannel.DeserializeBinaryRequestMessage
  > > (String objectUri, Stream inputStream, Boolean bStrictBinding,
  > > TypeFilterLevel securityLevel)
  > >> >    at
  > > System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IS
  > > erverChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders
  > > requestHeaders, Stream requestStream, IMessage& responseMsg,
  > > ITransportHeaders& responseHeaders, Stream& responseStream)
  > >> >
  > >> > Exception rethrown at [0]:
  > >> >    at
  > > System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
  > > reqMsg, IMessage retMsg)
  > >> >    at
  > > System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
  > > msgData, Int32 type)
  > >> >    at SAC.DataServices.EventServer.AttachClient(EventClient
  > >> > eventClient)
  > >> >    at SAC.DataServices.EventClient.gI() in
  > > C:\CSharp\EventServerClient\EventClient.cs:line 22
  > >> >   Inner Exception:
  > >> >   Error Message:
  > >> >   Unable to find the requested .Net Framework Data Provider.  It may
  > >> > not
  > > be installed.
  > >> >
  > >> >   Error Source:
  > >> >   System.Data
  > >> >
  > >> >   Error StackTrace:
  > >> >      at System.Data.Common.DbProviderFactories.GetFactory(String
  > > providerInvariantName)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetDefa
  > > ultMapping(String name, String dbProviderName)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetProv
  > > iderMapping(String name, String dbProviderName)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseCustomFactory.CreateObjec
  > > t(IBuilderContext context, String name, IConfigurationSource
  > > configurationSource, ConfigurationReflectionCache reflectionCache)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
  > > figuredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object
  > > existing, String id)
  > >> >      at
  > > Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
  > > context, Type typeToBuild, Object existing, String idToBuild)
  > >> >      at
  > > Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext
  > > context, Type typeToBuild, Object existing, String idToBuild)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Con
  > > figurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t,
  > > Object existing, String id)
  > >> >      at
  > > Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator
  > > locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
  > > transientPolicies)
  > >> >      at
  > > Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator
  > > locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[]
  > > transientPolicies)
  > >> >      at
  > > Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadW
  > > riteLocator locator, String idToBuild, Object existing, PolicyList[]
  > > transientPolicies)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
  > > erpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator,
  > > IConfigurationSource configurationSource)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
  > > erpriseLibraryFactory.BuildUp[T](IConfigurationSource configurationSource)
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.Ent
  > > erpriseLibraryFactory.BuildUp[T]()
  > >> >      at
  > > Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase()
  > >> >      at SAC.DataServices.CorpAction.WithholdingTax.BizSvr..ctor()
  > >> >
  > >> > Please advice, Thanks,
  > >> >
  > >> > John Yung
  > >
  > >
  >
  >