[Mono-dev] ByteFX not working on Mono

[Reggie Burnett]

What version of MySQL are you trying to connect to?  The old ByteFX
code, if it has not been updated, cannot connect to any version of MySQL
past 4.0 unless you specifically setup the new versions of MySQL to use
the old authentication scheme.

> Hi,
>  
> I use ByteFX for my webservices and it cannot connect to database on
> Mono on Linux. I can actually connect to database when I
> use ByteFX Windows with .net framework. The webservices gives me this
> message on Linux
>  
> *The remote server returned an error: (500) Internal Server Error.*
> Unable to connect to any of the specified MySQL hosts
>  
> What would be the problem? Do I need to configure something or change
> any file permission or whatever on Linux?
>  
> I attach my code which is 100% working on Windows Platform. Can anyone
> suggest me why this error occurred?
>  
>
> using System;
>
> using System.Collections;
>
> using System.ComponentModel;
>
> using System.Data;
>
> using System.Diagnostics;
>
> using System.Web;
>
> using System.Web.Services;
>
> using ByteFX.Data.MySqlClient;
>
> namespace ws
>
> {
>
> /// <summary>
>
> /// Summary description for Service1.
>
> /// </summary>
>
> public class Fotohub : System.Web.Services.WebService
>
> {
>
> public Fotohub()
>
> {
>
> //CODEGEN: This call is required by the ASP.NET Web Services Designer
>
> InitializeComponent();
>
> }
>
> #region Component Designer generated code
>
> //Required by the Web Services Designer
>
> private IContainer components = null;
>
> /// <summary>
>
> /// Required method for Designer support - do not modify
>
> /// the contents of this method with the code editor.
>
> /// </summary>
>
> private void InitializeComponent()
>
> {
>
> }
>
> /// <summary>
>
> /// Clean up any resources being used.
>
> /// </summary>
>
> protected override void Dispose( bool disposing )
>
> {
>
> if(disposing && components != null)
>
> {
>
> components.Dispose();
>
> }
>
> base.Dispose(disposing);
>
> }
>
> #endregion
>
>  
>
> [WebMethod]
>
> public DataSet GetUserInfo()
>
> {
>
> string connectionString= "server=192.168.0.83; uid=koko; pwd=90087644;
> database=FotoWS";
>
> string query= "Select * From user";
>
> DataSet dataset=new DataSet();
>
> MySqlConnection conn = new MySqlConnection(connectionString);
>
> MySqlDataAdapter adapter = new MySqlDataAdapter();
>
> adapter.SelectCommand = new MySqlCommand(query, conn);
>
> adapter.Fill(dataset);
>
> return dataset;
>
> }
>
> }
>
> }
>
>  
>
> Regards,
>
> Ko Ko
>
>
>
> Reality starts with Dream
>
> ------------------------------------------------------------------------
> Yahoo! for Good
> Click here to donate <http://store.yahoo.com/redcross-donate3/> to the
> Hurricane Katrina relief effort.
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Mono-devel-list mailing list
>Mono-devel-list at lists.ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-devel-list
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20050930/36a2d33b/attachment.html