Publishing site
Publishing site
Hello
I bought Mydirect 4.30. I created a website I copied the folder bin dll CoreLab.Data.dll CoreLab.MySql.dll CoreLab.MySql.Web.dll I published the site but the server I see this error:
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.
I bought Mydirect 4.30. I created a website I copied the folder bin dll CoreLab.Data.dll CoreLab.MySql.dll CoreLab.MySql.Web.dll I published the site but the server I see this error:
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.
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
I tried but it is the same.
If I use the code works on the local and server
If I use the configuration wizard(MySqlDataSource),
I work locally but not on the server. Why?
Error:
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.
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.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
If I use the code works on the local and server
Code: Select all
Dim cn As New CoreLab.MySql.MySqlConnection("Database=vdlweb;Data Source=localhost;User Id=root;Password=123456;")
Dim cm As New CoreLab.MySql.MySqlDataAdapter("SELECT * FROM audio limit 10", cn)
cm.Fill(ds)
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
cn.Close()
I work locally but not on the server. Why?
Error:
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.
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.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Could you make minimal installation of MyDirect .NET on the server?
If yes, uninstall any prior versions of the product and make Minimal installation of the new one.It's not matter where the database is. You can work locally as well as remotely.
From your connection string I can see that you use localhost. Try changing the connection string.
Be aware of the server settings, which should allow remote connection to the database.
If yes, uninstall any prior versions of the product and make Minimal installation of the new one.
I work locally but not on the server. Why?
Code: Select all
Dim cn As New CoreLab.MySql.MySqlConnection("Database=vdlweb;Data Source=localhost;User Id=root;Password=123456;")
From your connection string I can see that you use localhost. Try changing the connection string.
Be aware of the server settings, which should allow remote connection to the database.
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
You need to register MyDirect .NET provider in your web.config.
Here is an example:
You can get the needed block of code from your machine.config (on the developer side).
Here is an example:
Code: Select all
...
...
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
We tested your web.config and it worked fine with a demo web site.
Try inserting command in your web.config. See the code:
Make sure that the version of the dll specified in the example corresponds to the version of the product installed on your (developer) machine.
Try inserting command in your web.config. See the code:
Code: Select all
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24