SybaseASE12.52配置使用错误
starg 2005-11-01 03:42:01 在windows2000中安装好SybaseASE12.52,使用时出现如下错误
1)恢复备份错误:
启动SQL Advantage,连接成功,默认数据库为appdb,执行如下SQL语句:
load database appdb from 'e:\DBaseFiles\SYBASE_DATA\bakup\dmp_appdb051031.bak'
ONLINE DATABASE appdb
执行结果:
Server Message: Number 3101, Severity 16
Server 'WSG1', Line 1:
Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load
Server Message: Number 3444, Severity 10
Server 'WSG1', Line 2:
Database 'appdb' is now online.
恢复备份没有成功,不知“must have exclusive use of database to run load”表示错在那?
2)在pb80中:
建立SYC_Sybase_ASE配置:appdb_syb,连接成功,
但访问table时出现“Stored procedure 'sp_pb80table'not found.”的错误,
访问Procedure & Fonction时出现"Stored procedure 'sp_pb80proclist'not found.”的错误
但使用ODBC配置一切正常,请高手解决,不够可加分。