Page 1 of 1

Publishing site

Posted: Fri 01 Feb 2008 11:11
by illusione
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.

Posted: Fri 01 Feb 2008 13:48
by Alexey.mdr
Check your web.config for referencing correct assemblies in the bin folder.
Have you ever had MyDirect .NET of other version installed on your developer machine? Probably the web site was earlier compiled with other assemblies.

Posted: Fri 01 Feb 2008 14:16
by illusione
Yes, I had the version Mydirect 4.20 TRIAL. I tried to connect to the database via code is working. When I use mysqldatasource while working locally on the server, I see the error.

Posted: Fri 01 Feb 2008 14:44
by Alexey.mdr
Let's reconfigure some references:
- delete all references to CoreLab.* libraries from your current ASP.NET project
- add new references to CoreLab.MySql and CoreLab.Data
- rebuild the project
- deploy the web site

Posted: Fri 01 Feb 2008 20:02
by illusione
I tried but it is the same.
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()
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

Posted: Mon 04 Feb 2008 09:58
by Alexey.mdr
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.
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;") 
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.

Posted: Mon 11 Feb 2008 15:20
by illusione
The connection string is right. In all the pages of the site using the same string is working. When I use datasource goes wrong. Unfortunately, the server will not install Mydirect me and I do not soche

Posted: Mon 11 Feb 2008 16:00
by Alexey.mdr
You need to register MyDirect .NET provider in your web.config.
Here is an example:

Code: Select all


...
 
...

You can get the needed block of code from your machine.config (on the developer side).

Posted: Mon 11 Feb 2008 16:49
by illusione
I copied the code does not work but nothing more.

This is my web config.






























































-->









Posted: Tue 12 Feb 2008 13:17
by Alexey.mdr
We tested your web.config and it worked fine with a demo web site.
Try inserting command in your web.config. See the code:

Code: Select all

     
          
           
            
    
  
Make sure that the version of the dll specified in the example corresponds to the version of the product installed on your (developer) machine.

Posted: Tue 12 Feb 2008 17:22
by illusione
Finally! We have succeeded!
It works all the great! Congratulations on the professionalism and care you give your customers. I am pleased to have purchased this product. You are the best. Thank you and the next! Hello

Posted: Wed 13 Feb 2008 12:00
by Alexey.mdr
You are welcome!
We're always glad to help our users.