在局域网用ODBC连接MSSQL数据库,连接没错,用的是ADODataSet,进行赋值时提示"未知错误":
MData.ADODSUserInfo.Append;
try
MData.ADODSUserInfo.FieldByName('UserID').AsString := sMaxID;
MData.ADODSUserInfo.FieldByName('SectionID').AsInteger := iSectionID;
MData.ADODSUserInfo.FieldByName('TypeID').AsInteger := iTypeID;
执行第一句就提示未知错误,请问是那里的问题.
MData.ADODSUserInfo.Append;
try
MData.ADODSUserInfo.FieldByName('UserID').AsString := sMaxID;
MData.ADODSUserInfo.FieldByName('SectionID').AsInteger := iSectionID;
MData.ADODSUserInfo.FieldByName('TypeID').AsInteger := iTypeID;
执行第一句就提示未知错误,请问是那里的问题.
with adodataset do
begin
close;
commandtext:='';
open;
append;
FieldByName('UserID').AsString:= sMaxID;
FieldByName('SectionID').AsInteger:= iSectionID;
FieldByName('TypeID').AsInteger:= iTypeID;
post;
end;
直接用ADO连