2003 R2 issue with SqlDataSource

Discussion in 'ASP .Net' started by Mechanic, Jun 9, 2008.

  1. Mechanic

    Mechanic Guest

    I set up a Server 2003 R2 64-bit server to run ODP.NET.... That all
    works fine in 32-BIT mode except 1 thing.

    When I use asp:SqlDataSource tag on this machine I get this error.
    This application runs fine on all the other machines.

    Unable to find the requested .Net Framework Data Provider. It may not
    be installed.
    Description: An unhandled exception occurred during the execution of
    the current web request. Please review the stack trace for more
    information about the error and where it originated in the code.

    Also wow64log.dll comes up often in Filemon.
    ________________________________________________________________________________

    4:22:59 PM emdctl.exe:3624 QUERY INFORMATION C:\Program Files
    (x86)\Microsoft SQL Server\90\Tools\binn\wow64log.dll NOT FOUND
    Attributes: Error

    ________________________________________________________________________

    Exception Details: System.ArgumentException: Unable to find the
    requested .Net Framework Data Provider. It may not be installed.

    Source Error:

    An unhandled exception was generated during the execution of the
    current web request. Information regarding the origin and location of
    the exception can be identified using the exception stack trace
    below.

    Stack Trace:


    [ArgumentException: Unable to find the requested .Net Framework Data
    Provider. It may not be installed.]
    System.Data.Common.DbProviderFactories.GetFactory(String
    providerInvariantName) +1447431
    System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() +63

    System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure()
    +19

    System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments
    arguments) +120
    System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e)
    +92
    System.Web.UI.WebControls.ListControl.PerformSelect() +31
    System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
    System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
    +82
    System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
    System.Web.UI.Control.PreRenderRecursiveInternal() +86
    System.Web.UI.Control.PreRenderRecursiveInternal() +170
    System.Web.UI.Control.PreRenderRecursiveInternal() +170
    System.Web.UI.Page.ProcessRequestMain(Boolean
    includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    +2041




    --------------------------------------------------------------------------------
    Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
    ASP.NET Version:2.0.50727.1433
    Mechanic, Jun 9, 2008
    #1
    1. Advertising

  2. Hello Mechanic,

    do you use .NET 64 bit?!
    Are you sure that you are using the right version of ODP.net ? (do they have
    64 bit version? )

    ---
    WBR,
    Michael Nemtsev [Microsoft MVP] :: blog: http://spaces.live.com/laflour

    "The greatest danger for most of us is not that our aim is too high and we
    miss it, but that it is too low and we reach it" (c) Michelangelo


    M> I set up a Server 2003 R2 64-bit server to run ODP.NET.... That all
    M> works fine in 32-BIT mode except 1 thing.
    M>
    M> When I use asp:SqlDataSource tag on this machine I get this error.
    M> This application runs fine on all the other machines.
    M>
    M> Unable to find the requested .Net Framework Data Provider. It may
    M> not
    M> be installed.
    M> Description: An unhandled exception occurred during the execution of
    M> the current web request. Please review the stack trace for more
    M> information about the error and where it originated in the code.
    M> Also wow64log.dll comes up often in Filemon.
    M> _____________________________________________________________________
    M> ___________
    M> 4:22:59 PM emdctl.exe:3624 QUERY INFORMATION C:\Program Files
    M> (x86)\Microsoft SQL Server\90\Tools\binn\wow64log.dll NOT FOUND
    M> Attributes: Error
    M>
    M> _____________________________________________________________________
    M> ___
    M>
    M> Exception Details: System.ArgumentException: Unable to find the
    M> requested .Net Framework Data Provider. It may not be installed.
    M>
    M> Source Error:
    M>
    M> An unhandled exception was generated during the execution of the
    M> current web request. Information regarding the origin and location of
    M> the exception can be identified using the exception stack trace
    M> below.
    M>
    M> Stack Trace:
    M>
    M> [ArgumentException: Unable to find the requested .Net Framework Data
    M> Provider. It may not be installed.]
    M> System.Data.Common.DbProviderFactories.GetFactory(String
    M> providerInvariantName) +1447431
    M> System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() +63
    M> System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure()
    M> +19
    M>
    M> System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceS
    M> electArguments
    M> arguments) +120
    M> System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e)
    M> +92
    M> System.Web.UI.WebControls.ListControl.PerformSelect() +31
    M> System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
    M> System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
    M> +82
    M> System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
    M> System.Web.UI.Control.PreRenderRecursiveInternal() +86
    M> System.Web.UI.Control.PreRenderRecursiveInternal() +170
    M> System.Web.UI.Control.PreRenderRecursiveInternal() +170
    M> System.Web.UI.Page.ProcessRequestMain(Boolean
    M> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    M> +2041
    M>
    M> ---------------------------------------------------------------------
    M> -----------
    M> Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
    M> ASP.NET Version:2.0.50727.143
    Michael Nemtsev [MVP], Jun 10, 2008
    #2
    1. Advertising

  3. Mechanic

    Mechanic Guest

    Re: 2003 R2 issue with SqlDataSource

    I have had a lot of trouble with the oracle and dotnet framework
    running in 64 bit... So I have been running everything in 32bit
    because it all seemed to work that way. All the other data calls work
    except the asp:SqlDataSource tag. As a bandage I switched it to and
    asp:ObjectDataSource and did the data call from the code behind but
    the underlying problem remains... A major function of the framework is
    unavailable to myself and the other developers. Frankly I would have
    never suggested a 64-bit machine had I know it was this much more
    complicated.

    Mike


    On Jun 9, 7:48 pm, Michael Nemtsev [MVP] <> wrote:
    > Hello Mechanic,
    >
    > do you use .NET 64 bit?!
    > Are you sure that you are using the right version of ODP.net ? (do they have
    > 64 bit version? )
    >
    > ---
    > WBR,
    > Michael Nemtsev [Microsoft MVP] :: blog:http://spaces.live.com/laflour
    >
    > "The greatest danger for most of us is not that our aim is too high and we
    > miss it, but that it is too low and we reach it" (c) Michelangelo
    >
    > M> I set up a Server 2003 R2 64-bit server to run ODP.NET.... That all
    > M> works fine in 32-BIT mode except 1 thing.
    > M>
    > M> When I use asp:SqlDataSource tag on this machine I get this error.
    > M> This application runs fine on all the other machines.
    > M>
    > M> Unable to find the requested .Net Framework Data Provider. It may
    > M> not
    > M> be installed.
    > M> Description: An unhandled exception occurred during the execution of
    > M> the current web request. Please review the stack trace for more
    > M> information about the error and where it originated in the code.
    > M> Also wow64log.dll comes up often in Filemon.
    > M> _____________________________________________________________________
    > M> ___________
    > M> 4:22:59 PM emdctl.exe:3624 QUERY INFORMATION C:\Program Files
    > M> (x86)\Microsoft SQL Server\90\Tools\binn\wow64log.dll NOT FOUND
    > M> Attributes: Error
    > M>
    > M> _____________________________________________________________________
    > M> ___
    > M>
    > M> Exception Details: System.ArgumentException: Unable to find the
    > M> requested .Net Framework Data Provider. It may not be installed.
    > M>
    > M> Source Error:
    > M>
    > M> An unhandled exception was generated during the execution of the
    > M> current web request. Information regarding the origin and location of
    > M> the exception can be identified using the exception stack trace
    > M> below.
    > M>
    > M> Stack Trace:
    > M>
    > M> [ArgumentException: Unable to find the requested .Net Framework Data
    > M> Provider. It may not be installed.]
    > M> System.Data.Common.DbProviderFactories.GetFactory(String
    > M> providerInvariantName) +1447431
    > M> System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() +63
    > M> System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure()
    > M> +19
    > M>
    > M> System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceS
    > M> electArguments
    > M> arguments) +120
    > M> System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e)
    > M> +92
    > M> System.Web.UI.WebControls.ListControl.PerformSelect() +31
    > M> System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
    > M> System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
    > M> +82
    > M> System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26
    > M> System.Web.UI.Control.PreRenderRecursiveInternal() +86
    > M> System.Web.UI.Control.PreRenderRecursiveInternal() +170
    > M> System.Web.UI.Control.PreRenderRecursiveInternal() +170
    > M> System.Web.UI.Page.ProcessRequestMain(Boolean
    > M> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    > M> +2041
    > M>
    > M> ---------------------------------------------------------------------
    > M> -----------
    > M> Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
    > M> ASP.NET Version:2.0.50727.1433
    Mechanic, Jun 10, 2008
    #3
  4. Mechanic

    Mechanic Guest

    Re: 2003 R2 issue with SqlDataSource

    I checked and I am not using a 64-bit ODP so I am going to try that.
    Mechanic, Jun 10, 2008
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bootstrap Bill

    Visual Studio .net 2003 and Frotpage 2003

    Bootstrap Bill, Sep 12, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    592
    Bootstrap Bill
    Sep 17, 2004
  2. Hawkmoth
    Replies:
    4
    Views:
    936
    =?Utf-8?B?SGF3a21vdGg=?=
    Mar 30, 2005
  3. David Waz...
    Replies:
    5
    Views:
    414
    Yan-Hong Huang[MSFT]
    Jul 14, 2003
  4. Replies:
    2
    Views:
    6,472
  5. perplexed

    Permission issue with SQLDataSource?

    perplexed, Jan 23, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    298
    brett
    Jan 24, 2007
Loading...

Share This Page