原先设计好了些管理文件,是用excel做的,当我用“外部数据源”-“生成器”-“ODBC”-连接后,出现
.NET Framework 版本:2.0.50727.3643
Foxtable 版本:2012.11.21.1
错误所在事件:
详细错误信息:
System.ArgumentException: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).
at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at Foxtable.O1O11ll0O1lO01O10lO0l1.OO111100001(Object O00O01, EventArgs O)
这是不是说不能用excel来作为数据源,另外,我想实现用foxtable管理原先的这些excel,并当数据更新后再重新更新到原excel文档,这样是否不行
帮助里说外部数据源是“”Access“、”SQL“