2003 R2 issue with SqlDataSource

M

Mechanic

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
 
M

Michael Nemtsev [MVP]

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
 
M

Mechanic

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


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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top