problem of version of system.data.dll about read from excel and sql server

Unity Engine
1

I have two system.data.dll files ,one is from unity3d 2.6, and one is from unity3d 3.x , the problem is :

  1. when I read the excel file, the dll from the 3.0 works well, while use the dll from 2.6 , it appers something bellow:
    OdbcException: [Microsoft][ODBC Excel Driver] FROM clause syntax error
    System.Data.Odbc.OdbcCommand.ExecSQL (System.String sql)
    System.Data.Odbc.OdbcCommand.ExecuteNonQuery (Boolean freeHandle)
    System.Data.Odbc.OdbcCommand.ExecuteReader (CommandBehavior behavior)
    System.Data.Odbc.OdbcCommand.ExecuteReader ()
    (wrapper remoting-invoke-with-check) System.Data.Odbc.OdbcCommand:ExecuteReader ()
    ExcelOp.QueryAllType () (at Assets\Code\ExcelOp.cs:21)
    TT2Form1.InitializeComponent () (at Assets\Forms\TT2Form1.cs:57)
    TT2Form1.Initialize () (at Assets\Forms\TT2Form1.cs:165)
    UnityForms.Form.InitializeForm ()
    UnityForms.FormsManager.LoadForm (UnityEngine.GameObject gameObject, System.Type formType, UnityEngine.GUISkin defaultSkin)
    TestForm1.Start () (at Assets\Forms\TestForm1.cs:15)

  2. when I read the sql server from 2.6, it works ok, while I use the dll from 3.0, it will appears :
    SqlServerTest ---- Test – catch :System.MissingMethodException: Method not found: ‘Mono.Data.Tds.Protocol.Tds.set_Pooling’.
    at <0x00000>
    at SqlServerTest.ConnectTest () [0x00016] in C:\Documents and Settings\Administrator\My Documents\GUITest\Assets\Code\SqlServerTest.cs:34
    UnityEngine.Debug:Log(Object)
    SqlServerTest:ConnectTest() (at Assets\Code\SqlServerTest.cs:40)
    SqlServerTest:Start() (at Assets\Code\SqlServerTest.cs:12)

2

  1. Thats to expect. System data was not half done with mono 1.2.5
    Especially not MS only stuff

  2. you try to use something not present either in mono 2.6 anymore or something UT has cut either in general or for your specific deployment target

General: I Hope you didn’t copy the dlls around or it will totally mess up and definitely not work!

3

thanks for your reply,dreamora.
In unity2.6 , when I use the system.data.dll from unity2.6, it works well. But when I changed to use the dll file from unity3d3.x ,it appears:
System.MissingMethodException: Method not found: ‘Mono.Data.Tds.Protocol.Tds.set_Pooling’.
why the higher the version , the error appears instead?

below is the code I use:

public static bool ConnectTest()
  {
    string connectionString =
          "Server=192.168.0.193;" +
          "Database=devices;" +
          "User ID=sa;" +
          "Password=123;";        
            bool connected = false;
            using (IDbConnection conn = new SqlConnection(connectionString))
            {
                using (IDbCommand cmd = conn.CreateCommand())
                {
                    try{
                         conn.Open();
                    }catch(Exception Ex)
                     {
                            // Try to close the connection
                            if (conn != null)
                                conn.Dispose();
                                    Debug.Log("SqlServerTest ---- Test -- catch :" + Ex);
                                    return false;
                       }
                      connected = true;
            } // command 
        } // connection 
        return connected;
    }
}