|
协议选择双协议:ms sql server+windows sockets
程序是PB开发 后台数据库sql server2000
录制脚本部分代码:
lrd_close_cursor(&Csr4, 0);
lrd_cancel(0, Csr2, 2 /*All*/, 0);
lrd_stmt(Csr2, "SELECT sysdate from dual", -1, 0, 0 /*None*/, 0);
lrd_exec(Csr2, 0, 0, 0, 0, 1);
lrd_stmt(Csr2, "SELECT top 1 getdate ( ) from sysusers ", -1, 0, 0 /*None*/, 0);
lrd_exec(Csr2, 0, 0, 0, 0, 0);
lrd_result_set(Csr2, 0 /*Succeed*/, 0, 0);
脚本回放 Action.c(224): lrd_stmt: SELECT sysdate from dual
Action.c(225): Error: Server error msg (Number=208, Severity=16, State=1, Function=dbsqlexec, Server="KEYU-TANGXS", Line=1):
Action.c(225): Error: 对象名 'dual' 无效。
Action.c(225): Error: DB-Library error msg (Number=10007, Severity=5, Function=dbsqlexec):
Action.c(225): Error: SQL Server 常规错误: 请检查来自 SQL Server 的消息。
汗 如何解决sql server没这个表啊 |
|