有关数据库连接的问题?
zkw 2003-10-20 03:58:24 代码如下:
sqlca.dbms = "odbc";
sqlca.autocommit = false;
sqlca.dbparm = "connectstring='dsn=student_00057350;uid=dba;pwd=sql'"
connect;
if sqlca.sqlcode <> 0 then
messagebox(sqlca.sqlerrtext,"can't open database!",Information!,okcancel!)
end if
declare cur_name cursor for
select "userpassword_0057350"."username" from "userpassword_0057350";
string name;
open cur_name;
fetch cur_name into :name;
do while sqlca.sqlcode = 0
ddlb_name.additem(name);
fetch cur_name into :name;
loop
close cur_name;
当我编译的时候报错:
database c0038:s0002 [sybase]...Table or view not found:table 'userpassword_0057350' not found
我没有发现代码有什么问题?初学pb,请多指教!!!