我使用ODBC连接Sybase IQ数据库,使用连接串'Provider=MSDASQL.1;Password=sql;Persist Security Info=True;User ID=dba;Data Source=iqDB'。使用语句:
adoquery1.Close;
adoquery1.SQL.Add('insert into dimen(dimen_id) values(11)');
adoquery1.ExceSQL;
可以正确执行。
但使用语句:
adoquery1.Close;
adoquery1.SQL.Add('select * from dimen');
adoquery1.Open; adoquery1.Insert;
adoquery1.FieldByName('dimen_id').AsString:= '11';
adoquery1.post;
出现错误提示::[Sybase][ODBC Driver][Adpative Server IQ]Invalid user authorization specification;User ID 'unknown' does not exits'.SOS!!!
adoquery1.Close;
adoquery1.SQL.Add('insert into dimen(dimen_id) values(11)');
adoquery1.ExceSQL;
可以正确执行。
但使用语句:
adoquery1.Close;
adoquery1.SQL.Add('select * from dimen');
adoquery1.Open; adoquery1.Insert;
adoquery1.FieldByName('dimen_id').AsString:= '11';
adoquery1.post;
出现错误提示::[Sybase][ODBC Driver][Adpative Server IQ]Invalid user authorization specification;User ID 'unknown' does not exits'.SOS!!!
:)
OR dimen_id is the 'pk' ,is not it?
adoquery1.sql.clear;
adoquery1.SQL.Add('select * from dimen');
adoquery1.Open;