同样是数据备份,为什么在我的机子上可以,在别的机上不行!!
如下这段备份数据代码
ElseIf Request.QueryString("type")="backdb" Then
myPath = Request("txtPath")
myFile = Request("txtFileName")
Set fso = CreateObject("Scripting.FileSystemObject")
If not fso.FolderExists(myPath) Then
On error resume next
Set f = fso.CreateFolder(myPath)
If Err.number<>0 then
Response.Write "<script>"
Response.Write "alert('输入路径有错,请重新输入!');"
Response.Write "history.go(-1);"
Response.Write "</script>"
Response.End
End If
End If
strSql = "USE master BACKUP DATABASE jxwzzb TO DISK='"& myPath &"\"& myFile &"'"
conn.Execute strSql
'记录管理员操作日志
SiteLogAdmin "","","","247"
Response.Write "数据库已经备份成功!<br>"
Response.Write "<p> </p>"
在自己机子上能很好运行。放到别的机子上就提示如下错误:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]已将数据库上下文改为 'master'。
/manage/info/backup.asp,行 196
谁知道这是怎么回事啊,怎么解决?谢谢啦