MySQL

Re: Godaddy.com and MySql.Data.dll problems.

andyste1 — Fri, 06 Nov 2009 09:20:32 GMT

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

Re: Godaddy.com and MySql.Data.dll problems.

thuhue — Thu, 05 Nov 2009 23:06:53 GMT

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.

Re: Godaddy.com and MySql.Data.dll problems.

andyste1 — Mon, 15 Jun 2009 11:56:08 GMT

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

Re: Godaddy.com and MySql.Data.dll problems.

hariomtatsat — Tue, 21 Apr 2009 05:08:37 GMT

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.

Re: Godaddy.com and MySql.Data.dll problems.

Sojan80 — Sun, 06 Jan 2008 02:12:04 GMT

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?

Re: Godaddy.com .

cchance — Tue, 31 Jul 2007 03:53:34 GMT

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

Godaddy.com .

Hira Mohan — Wed, 30 May 2007 14:24:37 GMT

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

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

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:

[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

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

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

Thanks in advance.

Regards:

Hira Mohan

Re: Godaddy.com and MySql.Data.dll problems.

WHGibbo — Mon, 16 Apr 2007 21:41:38 GMT

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

Re: Godaddy.com and MySql.Data.dll problems.

irfan_mcsd — Fri, 13 Apr 2007 11:24:25 GMT

Hi, make MySQL DLL Compatible for running in Medium Trust Level, and request for MYSQL Port Number from Godaddy and used this port number in your Connection string, this will fix your problem.

Re: Godaddy.com and MySql.Data.dll problems.

WishStar99 — Thu, 29 Mar 2007 19:38:50 GMT

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

Re: Godaddy.com and MySql.Data.dll problems.

WishStar99 — Thu, 29 Mar 2007 19:37:41 GMT

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

Re: Godaddy.com and MySql.Data.dll problems.

Darl — Sun, 25 Mar 2007 15:44:23 GMT

Hi All,

Am glad i found this forum, I was hit with .NET Data Provider not Found, tring to use the sqlDataSource control.

Now that I seen posting on the forum, I have moved my Data Binding into Code Behine and have uploaded the re-complied dll, but not am getting the

"System.Net.Sockets.SocketException: 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"

this error is thrown on line 30 (see code blow)

GoDaddy still said a script problem and not server problem, Have anybody come across this and you did you solve the problem.

Thanks for any help.

Here is my Code: default.aspx.cs

1    using System;
2    using System.Data;
3    using System.Configuration;
4    using System.Web;
5    using System.Web.Security;
6    using System.Web.UI;
7    using System.Web.UI.WebControls;
8    using System.Web.UI.WebControls.WebParts;
9    using System.Web.UI.HtmlControls;
10   using MySql.Data.MySqlClient;
11   
12   
13   public partial class _Default : System.Web.UI.Page 
14   {
15       protected void Page_Load(object sender, EventArgs e)
16       {
17           string MyConString = "Server=localhost;Port=3306;Database=mydatabase;Uid=root;Pwd='mypassword';";
18           MySqlConnection MyConnection = new MySqlConnection(MyConString);
19   
20           string queryString = "SELECT * FROM tb_storelinks";
21   
22           MySqlCommand MyCommand = new MySqlCommand();
23           MyCommand.CommandText = queryString;
24           MyCommand.Connection = MyConnection;
25   
26           MySqlDataAdapter dataAdapter = new MySqlDataAdapter();
27           dataAdapter.SelectCommand = MyCommand;
28           System.Data.DataSet dataSet = new System.Data.DataSet();
29         
30               dataAdapter.Fill(dataSet);
31   
32               gView.DataSource = dataSet;
33               gView.DataBind();
34   
35           
36   
37       }
38   }

default.aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <div style="margin-left:auto; margin-right:auto; width:auto; ">
        <h1>Test Site</h1>        <p />
          <asp:GridView ID="gView" runat="server" AutoGenerateColumns="False" DataKeyNames="PKID">
            <Columns>
              <asp:BoundField DataField="PKID" HeaderText="PKID" ReadOnly="True" SortExpression="PKID" />
              <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
              <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
              <asp:BoundField DataField="ImageUrl" HeaderText="ImageUrl" SortExpression="ImageUrl" />
              <asp:BoundField DataField="Importance" HeaderText="Importance" SortExpression="Importance" />
              <asp:BoundField DataField="URL" HeaderText="URL" SortExpression="URL" />
            </Columns>
          </asp:GridView>
          <br />
          <asp:Label runat="server" ID="Label_Error" /></div>
    </form>
</body>
</html>

Re: Godaddy.com and MySql.Data.dll problems.

Alexandre Leclerc-Gravel — Fri, 23 Mar 2007 00:18:52 GMT

What is the line you had changed ?

Re: Godaddy.com and MySql.Data.dll problems.

JoshStodola — Fri, 16 Mar 2007 22:07:14 GMT

Hey, I remember having this problem when I first started using MySQL.

Called their support and they told me what I had to do in minutes. It involved opening up a project in Visual Studio (I believe it was C#) and I had to change one line of code, and then compile everything in Release mode. Brought in the new DLL and everything works great.

I love MySQL! Open source (free!!!), and super fast. I like it better than SQL Server, honestly.

But then again, I am an open-source kinda guy (lol I am now developing a blog to run on apache with Mysql - both open source). Which is why I am sometimes confused that I code using ASP.NET and not PHP. Who am I kidding? PHP aint got nothin on ASP!

Re: Godaddy.com and MySql.Data.dll problems.

madtownlounge.com — Wed, 14 Mar 2007 16:48:35 GMT

Would any of this work with classic ASP? If so, how? I'm getting a ton of errors similar to those described on this board:

"[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-max-log]MySQL server has gone away"

I'm also hosted at GoDaddy on a shared server running ASP connecting to MySQL.