odbc-连接cache数据库.rar

安装odbc cache数据库 控制面板-系统安全-管理工具-odbc32位设置 c#代码 （需要设置成x86） private static DataTable CACHEDB(string sql) { string connectionString = "DSN=Test"; DataTable result; try { using (OdbcConnection odbcConnection = new OdbcConnection(connectionString)) { using (OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection)) { using (OdbcDataAdapter odbcDataAdapter = new OdbcDataAdapter(odbcCommand)) { DataTable dataTable = new DataTable(); odbcConnection.Open(); odbcDataAdapter.Fill(dataTable); WriteLog.Write("CACHE查询到值的总数：" + dataTable.Rows.Count.ToString()); result = dataTable; } } } } catch (Exception ex) { WriteLog.Write(ex.Message); result = null; } return result; }