Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > 2003 R2 issue with SqlDataSource

Reply
Thread Tools

2003 R2 issue with SqlDataSource

 
 
Mechanic
Guest
Posts: n/a
 
      06-09-2008
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.GetDbProvi derFactory() +63

System.Web.UI.WebControls.SqlDataSource.GetDbProvi derFactorySecure()
+19

System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments
arguments) +120
System.Web.UI.WebControls.ListControl.OnDataBindin g(EventArgs e)
+92
System.Web.UI.WebControls.ListControl.PerformSelec t() +31
System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +70
System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound()
+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
 
Reply With Quote
 
 
 
 
Michael Nemtsev [MVP]
Guest
Posts: n/a
 
      06-10-2008
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.GetDbProvi derFactory() +63
M> System.Web.UI.WebControls.SqlDataSource.GetDbProvi derFactorySecure()
M> +19
M>
M> System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceS
M> electArguments
M> arguments) +120
M> System.Web.UI.WebControls.ListControl.OnDataBindin g(EventArgs e)
M> +92
M> System.Web.UI.WebControls.ListControl.PerformSelec t() +31
M> System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +70
M> System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound()
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


 
Reply With Quote
 
 
 
 
Mechanic
Guest
Posts: n/a
 
      06-10-2008
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] <(E-Mail Removed)> 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.GetDbProvi derFactory() +63
> M> System.Web.UI.WebControls.SqlDataSource.GetDbProvi derFactorySecure()
> M> +19
> M>
> M> System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceS
> M> electArguments
> M> arguments) +120
> M> System.Web.UI.WebControls.ListControl.OnDataBindin g(EventArgs e)
> M> +92
> M> System.Web.UI.WebControls.ListControl.PerformSelec t() +31
> M> System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +70
> M> System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound()
> 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


 
Reply With Quote
 
Mechanic
Guest
Posts: n/a
 
      06-10-2008
I checked and I am not using a 64-bit ODP so I am going to try that.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permission issue with SQLDataSource? perplexed ASP .Net 2 01-24-2007 08:42 AM
Issue: The SqlDataSource control does not have a naming container wubin_98@yahoo.com ASP .Net 2 03-10-2006 10:55 PM
MCSA 2003 to MCSE 2003 =?Utf-8?B?UmFnbm9yYWs=?= Microsoft Certification 2 03-31-2005 01:19 AM
Visual Studio 2003 Office 2003 intergration Hawkmoth ASP .Net 4 03-30-2005 11:51 AM
Visual Studio .net 2003 and Frotpage 2003 Bootstrap Bill ASP .Net 3 09-17-2004 07:40 PM



Advertisments