You searched for the word(s): userid:444880

More Search Options

RSS Available

• Re: Connection string into MySQL database hosted on GoDaddy

  Like Gervs mentions, you should use the MySQL Connector/NET. I'd definitely stay away from using the ODBC driver, as I have found it to be unreliable - with connection timeouts and the like, very annoying. Look at the following thread which talks about using the MySQL Connector/NET with a Godaddy account: http://forums.asp.net/thread/1314486.aspx

  Posted to MySQL (Forum) by whebert on 11/29/2006

• Re: mySQL connection trouble...

  I remember there being a difference between 1.1 and 2.0, with respect to being able to use MySql.Data.dll, which concerned running under Medium Trust. The MySql.Data.dll needs to be able to "Allow Partially Trusted Callers", which can be fixed by modifying the assembly code and recompiling, but there are other issues with it running under medium trust, one of which is a problem with the sockets, I think. Is your web server running under medium trust? If you own the server, you could probably raise

  Posted to MySQL (Forum) by whebert on 11/29/2006

• Re: Need advice for mysql and Visual Web Developer

  To connect to your MySQL database running on a server, all you basically need is a connection string. A typical connection string might look like the following: "Server=server.address.here; Port=3306; Database=your_database_name; Uid=you_user_id; Pwd=your_user_password;" Of course, this connection string only tells your database provider how to connect to your database. You will still need to know how to use a database provider and make SQL queries and such with it. For MySQL, I'd suggest using the

  Posted to MySQL (Forum) by whebert on 11/29/2006

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

  Ah yes, this was a familiar problem for me too when I was forced to rely on the ODBC driver to access MySQL from my GoDaddy shared-hosting account. I'd continually get timeouts and other exception oddities. Very frustrating and disheartening. You should switch from the ODBC connector to the MySQL Connector/Net provider discussed in this thread. That's why this thread was started, to get the far better MySQL Connector/NET working on GoDaddy's shared hosting. GoDaddy has since enabled their shared

  Posted to MySQL (Forum) by whebert on 11/29/2006

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

  Could you please post your code, including your connection string. I haven't seen this error myself, so I'm unfamiliar with what might be causing it, but if you post the code, it should give somebody a better idea of what might be happending.

  Posted to MySQL (Forum) by whebert on 10/20/2006

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

  Hmm, I am not aware of any 2.0.8.0 version of the MySQL Connector/Net, the latest version still appears to be 1.0.7. If you wish to simply test the MySQL Connector/Net 1.0.7 assembly in your application, place the MySQL.Data.Dll in your /bin directory and on your code behind page, simply add a "using MySql.Data.MySqlClient;" to access the assembly. Look at the example I posted above on 8-04-2006. I'd try this simple test first, just to make sure you can use MySQL Connector/Net with

  Posted to MySQL (Forum) by whebert on 9/15/2006

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

  Sorry, didn't see you got it working before I posted my last... Although .Open() works, the dataAdapter.Fill() method will open the connection if it isn't already, then close it for you as well if it had to open it. Anyway, not sure why your columns are not showing. Are you catching any potential exceptions? If you are, make sure you display the error - it will definitely help determin if there was a problem. You're sure that there is data in the dataset?

  Posted to MySQL (Forum) by whebert on 8/4/2006

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

  That was just a sample "code behind" page for a sample .aspx web page. Assuming that you're using Visual Web Developer 2005 Express or similar, and that you have a particular page, say "Default.aspx", and you have a corresponding code-behind "Default.cs", the code sample would start like: using ... using ... public partial class _Default : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e) { . . // Sample MySQL Code here } } Or just stick the sample MySQL code in your Page_Load

  Posted to MySQL (Forum) by whebert on 8/4/2006

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

  Sample code fragment: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using MySql.Data.MySqlClient; public partial class Test_Page : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e) { // Simple MySQL Database test string MyConString = "Server=yourMySQLServer;Port

  Posted to MySQL (Forum) by whebert on 8/4/2006

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

  Well, I tested it and sure enough, it works now. So thanks again to Alek and the Godaddy Hosting Team for taking the time to add support for the MySql Connector/Net provider under .NET 2.0. As mentioned, I did have to place the recompiled assembly in the /bin folder to get it to work, but that is easy to do. For those who haven't already done so or haven't read about it elsewhere, this is how I recompiled the MySql.Data.Dll assembly. I first downloaded the Connector/NET 1.0 provider from the MySql

  Posted to MySQL (Forum) by whebert on 7/6/2006