754
社区成员
发帖
与我相关
我的任务
分享菜鸟问题：请高手帮忙，关于数据库备份与还原！！
有个图书管理软件是用PB编的，数据库是SYBASE。想在PB中完成对数据库的备与还原，备份代码：intValue = GetFileSaveName("保存文件", &
strTextName, strNamed, "dat","备份文件 (*.dat),*.dat" )
IF intValue = 1 THEN
if f_message_yesno("您确定吗？") = 1 then
string DbName = "mdbook"
string BuildSQL
SQLCA.DBMS = "SYC Sybase System 10 CTLIB"
SQLCA.Database = "mdbook"
SQLCA.ServerName = "wangjx"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = true
SQLCA.DBParm = ""
BuildSQL = 'dump database mdbook to "'+strTextName+'"'
sle_1.text=buildsql
EXECUTE IMMEDIATE :BuildSQL;
if sqlca.sqlcode = 0 then
f_message_ok("图书资料备份成功")
else
if SQLCA.Sqlcode=-1 then
messagebox("sql error",sqlca.sqlerrtext)
halt close
其中的DUMP语句在winsql32中运行通过的，运行后出现的sql error：backup server sesion id is 5 use this value when executing the 'sp_volchanged system stored procedure after fulfilling any volume change request from the back up server.
望高手帮忙，小弟万分感谢！
strTextName, strNamed, "dat","备份文件 (*.dat),*.dat" )
IF intValue = 1 THEN
if f_message_yesno("您确定吗？") = 1 then
string DbName = "mdbook"
string BuildSQL
SQLCA.DBMS = "SYC Sybase System 10 CTLIB"
SQLCA.Database = "mdbook"
SQLCA.ServerName = "wangjx"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = true
SQLCA.DBParm = ""
BuildSQL = 'dump database mdbook to "'+strTextName+'"'
sle_1.text=buildsql
EXECUTE IMMEDIATE :BuildSQL;
if sqlca.sqlcode = 0 then
f_message_ok("图书资料备份成功")
else
if SQLCA.Sqlcode=-1 then
messagebox("sql error",sqlca.sqlerrtext)
halt close
其中的DUMP语句在winsql32中运行通过的，运行后出现的sql error：backup server sesion id is 5 use this value when executing the 'sp_volchanged system stored procedure after fulfilling any volume change request from the back up server.
望高手帮忙，小弟万分感谢！
...全文
请发表友善的回复…
发表回复
zjianabc 2003-05-13
- 打赏
- 举报
disconnect然后connect
xirumin 2003-05-13
- 打赏
- 举报
学习
hfs1978 2003-05-13
- 打赏
- 举报
在备份前请断开所有与数据库的连接，然后重新连接数据库即可
fengzeng 2003-05-13
- 打赏
- 举报
http://expert.csdn.net/Expert/topic/1663/1663740.xml?temp=.5629694
hanyuliang 2003-05-13
- 打赏
- 举报
不行，错误的信息为：login failed
