hot club of hungary cd

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

hot club of hungary cd

Post by karim » Mon 04 Feb 2008 20:49

polymerase that serve to increase binding event. In the case of synexin actingin vitro These secondary structure elements in
abundance extremes: a genomic signature, nus on the left and the 3 terminus on heritable human breast cancers and is
Studies in the budding yeast,S. cerevisiae, made to date in the field of anticancer im- thickening of the basement membrane
health bene ts, 60?61, 318 all our water with sodium fluoride, their deadly waste for burning fat. And this is really sad because while this type of exercise certainly
Last edited by karim on Tue 07 Sep 2010 15:47, edited 2 times in total.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Tue 05 Feb 2008 08:14

Please describe the steps that lead to the exception.
When did you get this exception?
Did you make Minimal installation of MyDirect .NET on the server?

karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Post by karim » Tue 05 Feb 2008 08:45

Alexey.mdr wrote:Please describe the steps that lead to the exception.
When did you get this exception?
Did you make Minimal installation of MyDirect .NET on the server?
Hmm, how do i install MyDirect.NET on SUSE Linux? Why do i have to install it? I am copying the dll's to the server.

I get this error when i try to run the following codebehind:

Code: Select all

            MySqlConnection conn = new MySqlConnection();
            try
            {
                conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["Main.ConnectionString"].ToString());
                conn.Open();
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandText = "select username, lastactivity from vB_user";
                cmd.Connection = conn;
                MySqlDataTable dt = new MySqlDataTable();
                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                da.Fill(dt);

                MySqlDataTable dt2 = new MySqlDataTable();
                dt2.Columns.Add("index");
                dt2.Columns.Add("username");
                dt2.Columns.Add("lastactivity");
                int count = 0;
                foreach (DataRow dr in dt.Rows)
                {
                    count++;
                    DataRow dr2;
                    dr2 = dt2.NewRow();
                    dr2[0] = count;
                    dr2["username"] = dr[0];
                    dr2["lastactivity"] = Utility.ConvertFromUnixTimestamp(Convert.ToDouble(dr[1]));
                    dt2.Rows.Add(dr2);
                }
                GridView1.DataSource = dt;
                GridView1.DataBind();
                Response.Write("Het is gelukt.");

            }
            catch (Exception ex)
            {
                Label1.Text  = ex.Message;
            }
            finally
            {
                conn.Close();
            }
        }
It works with MySql Connector.


My Web.Config:

Code: Select all


	
	
		
		
	

	
		
		
			
				
				
				
			
		
		

		 section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
		 section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        
            
            
        
        -->
	
Kind regards,
Karim[/code]

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Tue 05 Feb 2008 10:32

Could you send us the call stack of the error, please?

karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Post by karim » Tue 05 Feb 2008 15:40

Alexey.mdr wrote:Could you send us the call stack of the error, please?
There is no call stack returned. I only get a blank screen with that info.

I attached an image of the screen.

Kind regards,
Karim

karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Post by karim » Tue 05 Feb 2008 15:42

karim wrote:
Alexey.mdr wrote:Could you send us the call stack of the error, please?
There is no call stack returned. I only get a blank screen with that info.

I attached an image of the screen.

Kind regards,
Karim
I cannot upload an image??[/img]

karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Post by karim » Tue 05 Feb 2008 15:44

Alexey.mdr wrote:Could you send us the call stack of the error, please?
Also, what do i have to install on the server for this to run? As i already stated: the .aspx page works when i use mysqlconnecter.net.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Wed 06 Feb 2008 15:01

To get a stacktrace, you can modify your code like this:

Code: Select all

try{
...
}
catch (Exception ex){
      Label1.Text  = ex.StackTrace;
}
finally{
...
} 
Also, what do i have to install on the server for this to run?
On the Linux server you need to copy all necessary assemblies to the bin folder of the web site.

karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Post by karim » Wed 06 Feb 2008 21:08

Alexey.mdr wrote:To get a stacktrace, you can modify your code like this:

Code: Select all

try{
...
}
catch (Exception ex){
      Label1.Text  = ex.StackTrace;
}
finally{
...
} 
Also, what do i have to install on the server for this to run?
On the Linux server you need to copy all necessary assemblies to the bin folder of the web site.

Code: Select all

at System.Collections.Hashtable.Find (System.Object key) [0x00000] at System.Collections.Hashtable.Contains (System.Object key) [0x00000] at System.Data.Common.DataTableMappingCollection.Contains (System.String value) [0x00000] at (wrapper remoting-invoke-with-check) System.Data.Common.DataTableMappingCollection:Contains (string) at CoreLab.MySql.MySqlDataAdapter.a (System.Data.DataTable[] A_0, CoreLab.MySql.MySqlDataReader A_1, System.Data.DataSet A_2, System.String A_3, Int32 A_4, Int32 A_5) [0x00000] at CoreLab.MySql.MySqlDataAdapter.a (System.Data.DataTable[] A_0, IDataReader A_1, System.Data.DataSet A_2, System.String A_3, Int32 A_4, Int32 A_5) [0x00000] at CoreLab.MySql.MySqlDataAdapter.a (System.Data.DataTable A_0, IDataReader A_1, Boolean A_2) [0x00000] at CoreLab.MySql.MySqlDataAdapter.Fill (System.Data.DataTable table, IDataReader dataReader) [0x00000] at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable, IDbCommand command, CommandBehavior behavior) [0x00000] at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable) [0x00000] at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill (System.Data.DataTable) at TestOnWebserver.Default.Page_Load (System.Object sender, System.EventArgs e) [0x00000] 
That's the stacktrace...i hope you can make something out of it.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 07 Feb 2008 10:40

We are investigating the problem.
Meanwhile, as a temporary solution, you can explicitly set TableMappings property of MySqlDataAdapter for your tables.

karim
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Post by karim » Thu 07 Feb 2008 16:19

Alexey.mdr wrote:We are investigating the problem.
Meanwhile, as a temporary solution, you can explicitly set TableMappings property of MySqlDataAdapter for your tables.
Do you have an example of how to do that?

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Fri 08 Feb 2008 14:10

Here is an example of using MySqlDataAdapter.TableMapping property:

Code: Select all

  
            MySqlDataAdapter da = new MySqlDataAdapter();
            MySqlDataSet ds = new MySqlDataSet();            
            da.TableMappings.Add("MySQLServer_DEPT", "dept");            
            da.TableMappings.Add("MySQLServer_EMP", "emp");            
            da.Fill(ds);

Post Reply