Hey,

You get this ".NET Data Provider not Found, tring to use the sqlDataSource control." because you are missing the MySQL.dll file in your bin folder.

If my memory is not wrong, I remember seeing an URL in this thread where you can download the file. If  you cannot find it, I can give you my MySQL.dll file. CHEER

Sorry for the error: The file name is MySQL.Data.dll

Hi,
Was wondering if anybody could shed any light on my problem, that I have with godaddy....

I'm using the adapted version of the club starter kit, using mysql for the datasource.  I 'm using the mySql.Net Connector that somebody uploaded onto RiverSprint.  And now have all the pages, except one working :(

The page that isn't working is the events_calendar.aspx, i'm getting the following error:

 Could not load file or assembly 'MySql.Data, Version=1.0.7.0, Culture=neutral, PublicKeyToken=33a1c5bf06bf72d7' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

my web.config has the following:

<system.data>
<DbProviderFactories>
<add name="MySql Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySql" type="MySql.Data.MySqlClient.MySqlFactory, MySql.Data, Version=1.0.7.0, Culture=neutral, PublicKeyToken=33a1c5bf06bf72d7"/>
</DbProviderFactories>
</system.data>

Any ideas what the problem could be? I'm thinking it has something to do with the publickeytoken?  but not sure...
Thanks 

Gibbo

 Hi,

      i am using godaddy server for both our applcation and database as well.

     when i try to run a page without database interaction.it runs successfully. but when i try to run a page that has the interaction with database it always prompt error.

     i.e.;

Security Exception

[SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]
   System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) +0
   System.Security.CodeAccessPermission.Demand() +59
   System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) +678
   System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) +114
   System.Configuration.Internal.InternalConfigHost.StaticOpenStreamForRead(String streamName) +80
   System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName, Boolean assertPermissions) +115
   System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName) +7
   System.Configuration.Internal.DelegatingConfigHost.OpenStreamForRead(String streamName) +10
   System.Configuration.UpdateConfigHost.OpenStreamForRead(String streamName) +42
   System.Configuration.BaseConfigurationRecord.InitConfigFromFile() +443

    So could anyone suggest/help me to figure out the solution of this appropriate problem.

  Thanks in advance.

  Regards:

  Hira Mohan
 

need help guys im stuck where you guys were... i got the dll loading (the good one with medium trust) and now i ran into the other issue

"A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied"

I was wondering if you found a way to get it fixed because im stuck on the same bug... any help would be MUCH appreciated. I tried adding port=3306 and even the polling=false thing both didnt change anything, i tried using the localhost database and tried a remote database, regardless i get the above error... PLEASE HELP

 To use MySql 5 on GoDaddy do you still need Connector 1.0 whebert refers to or has all this been resolved with connector 5.1? Anyone know?

hi,

I have also the same problem in mysql.data.dll. it couldn't add the assembly reference.

I am just a beginner.  .

Please somebody help me to fix this.it ios urgent.

Hi

If you drop a newer version of MySql.Data.dll into your \bin folder you might need to add a binding redirect in web.config to force other assemblies in your app to reference the newer dll. Obviously replace the version numbers with those relevant to you:

 Andrew

Is Godaddy a good host for ASP.NET sites?

I am especially interested in backend databases performance. Please provide more feedback on maintenance issues of MSSQLServer and MySQL databases there.

I've been using it for a few months now and found it to be good for the price. Can't comment on performance as my website isn't really heavy on db usage. I'm using Sitefinity CMS with a SQL Server database. You get the run-of-the-mill Plesk control panel and the web-based database mgt tool (which isn't great, basically you can only run queries). However there is an option in the control panel to upload a database backup and restore it into your database.

I had issues with MySql but that was more to do with Sitefinity not liking GoDaddy's custom medium trust environment, and I was never able to get Sitefinity working with MySql - shame as my hosting plan provides only 1 SQL db but 10 (I think) MySql dbs.

Andrew

www.websitesandmore.co.uk