SQL 触发器DECLARE @filepath nvarchar(max) -- the query
DECLARE @filename nvarchar(max) -- its estimated execution cost set @filepath = 'E:\192.168.1.141\Sqltodbf\SqlIntoDbf\'
set @filename = 'wo.dbf'EXEC master.dbo.SqlintoDbfDll @filepath, @filenameC#string strOledbConn = @"provider=VFPOLEDB.1;data source=" + DbfPath + ";" + DbfTableFile + " id=admin;password=";
conn = new OleDbConnection(strOledbConn);
conn.Open(); 执行到这里系统出错,但是如果直接运行上面代码正常,如果我想修改某表的值的话就出错。
DECLARE @filename nvarchar(max) -- its estimated execution cost set @filepath = 'E:\192.168.1.141\Sqltodbf\SqlIntoDbf\'
set @filename = 'wo.dbf'EXEC master.dbo.SqlintoDbfDll @filepath, @filenameC#string strOledbConn = @"provider=VFPOLEDB.1;data source=" + DbfPath + ";" + DbfTableFile + " id=admin;password=";
conn = new OleDbConnection(strOledbConn);
conn.Open(); 执行到这里系统出错,但是如果直接运行上面代码正常,如果我想修改某表的值的话就出错。
The ITransactionLocal interface is not supported by the 'VFPOLEDB.1' provider
用其它 Access 驱程时亦是同样信息
当我用 DNS [ODBC]
DRIVER=SQL Native Client
UID=Administrator
DATABASE=Product
WSID=JUJUMAO
APP=Microsoft Data Access Components
Trusted_Connection=Yes
SERVER=192.168.1.108 连接时出现的信息是:其它会话正在使用事务的上下文。
The ITransactionLocal interface is not supported by the 'VFPOLEDB.1' provider
用其它 Access 驱程时亦是同样信息
当我用 DNS [ODBC]
DRIVER=SQL Native Client
UID=Administrator
DATABASE=Product
WSID=JUJUMAO
APP=Microsoft Data Access Components
Trusted_Connection=Yes
SERVER=192.168.1.108 连接时出现的信息是:其它会话正在使用事务的上下文。