hot club of hungary cd

hot club of hungary cd

Postby 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.
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby 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?
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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


   
   
      
      
   


   
      
      
         
            
            
            
         

      

      

      
      
   



Kind regards,
Karim[/code]
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby Alexey.mdr » Tue 05 Feb 2008 10:32

Could you send us the call stack of the error, please?
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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

Postby 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

Postby 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.
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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.
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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?
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby 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);
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for MySQL