[Mono-list] cannot connect to mysql server

StarLiu minxinjianxin at gmail.com
Thu Jul 17 03:31:04 EDT 2008


Greetings!
 
My code builds successfully, but it cannot connect to mysql server when it
runs, i searched in google about the error information:
"Stream is not a valid .resources file"
very little information about it, and no solution to it. so i ask here.
 
Here is the code:
 
using System;
using System.IO;
using System.Xml;  
using System.Data;
using MySql.Data.MySqlClient;
 
 
namespace StarConsole
{
class MainClass
{
public static void Main(string[] args)
{
   string connectionString ="Server=localhost;Database=Star;User
ID=root;Password=password;Pooling=false";
  IDbConnection dbcon = new MySqlConnection(connectionString);
  dbcon.Open();
  IDbCommand dbcmd = dbcon.CreateCommand();
  string sql ="insert into Departments(deptno,deptname)
values('0004','caohejin');";
  dbcmd.CommandText = sql;
   dbcmd.ExecuteNonQuery();
  reader.Close();
  reader = null;*/
  dbcmd.Dispose();
  dbcmd = null;
  dbcon.Close();
  dbcon = null;
 
}
}
}
 
here is the debug information output by monodevelop
 
 
Unhandled Exception: System.Reflection.TargetInvocationException: Exception
has been thrown by the target of an invocation. --->
System.ArgumentException: Stream is not a valid .resources file,
magic=0x6d783f3c
  at System.Resources.ResourceReader.ReadHeaders () [0x00000]  
  at System.Resources.ResourceReader..ctor (System.IO.Stream stream)
[0x00000]  
  at System.Resources.ResourceSet..ctor (System.IO.Stream stream) [0x00000]  
  at (wrapper managed-to-native)
System.Reflection.MonoCMethod:InternalInvoke (object,object[])
  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags
invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
System.Globalization.CultureInfo culture) [0x00000] --- End of inner
exception stack trace ---
 
  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags
invokeAttr, System.Reflection.Binder binder, System.Object[] parameters,
System.Globalization.CultureInfo culture) [0x00000]  
  at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr,
System.Reflection.Binder binder, System.Object[] parameters,
System.Globalization.CultureInfo culture) [0x00000]  
  at System.Activator.CreateInstance (System.Type type, BindingFlags
bindingAttr, System.Reflection.Binder binder, System.Object[] args,
System.Globalization.CultureInfo culture, System.Object[]
activationAttributes) [0x00000]  
  at System.Activator.CreateInstance (System.Type type, System.Object[]
args, System.Object[] activationAttributes) [0x00000]  
  at System.Activator.CreateInstance (System.Type type, System.Object[]
args) [0x00000]  
  at System.Resources.ResourceManager.InternalGetResourceSet
(System.Globalization.CultureInfo culture, Boolean Createifnotexists,
Boolean tryParents) [0x00000]  
  at System.Resources.ResourceManager.GetString (System.String name,
System.Globalization.CultureInfo culture) [0x00000]  
  at MySql.Data.MySqlClient.Resources.get_PerfMonCategoryName () [0x00000]  
  at MySql.Data.MySqlClient.PerformanceMonitor..ctor
(MySql.Data.MySqlClient.MySqlConnection connection) [0x00000]  
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00000]  
  at StarConsole.MainClass.Main (System.String[] args) [0x0000d] in
/root/Life/Mono/StarConsole/Main.cs:31  
 
any advice? thanks! 
-- 
View this message in context: http://www.nabble.com/cannot-connect-to-mysql-server-tp18503084p18503084.html
Sent from the Mono - General mailing list archive at Nabble.com.



More information about the Mono-list mailing list