关于超时已过期的问题，请高手解惑！

[倾心软件]

VB运行下面代码,在运行到恢复帐套时，总是弹出“超时已过期”的提示，而在查询分析器中执行相同的sql 语句是可以正常执行的。我已经把ConnectionTimeout=0 还是不行,这个问题该怎么解决。在线等。

Label1.Caption = "正在拆分帐套请耐心等待..."
DoEvents
strCreat = "BACKUP DATABASE MHPS TO DISK='D:\BACKUP'; "
g_adoConn.Execute strCreat


strCreat = " CREATE DATABASE [" & Combo1.Text & "] ON ..."
g_adoConn.Execute strCreat
Label1.Caption = "帐套备份成功..."
DoEvents

strCreat = " RESTORE DATABASE [" & Combo1.Text & "] FROM DISK = 'd:\BACKUP' ..."
g_adoConn.Execute strCreat
Label1.Caption = "帐套恢复成功..."
DoEvents

strCreat = " Delete [" & Combo1.Text & "]..m_curcardinfo ; "
strCreat = strCreat & " Delete [" & Combo1.Text & "]..m_mcardinfo "
g_adoConn.Execute strCreat
Label1.Caption = "数据清理成功..."
DoEvents

[playwarcraft]

一般執行多長時間，跳出提示？

[倾心软件]

3分钟吧，总是在还原数据库时提示超时。

[倾心软件]

问题已经解决了。解决方法是在每次执行SQL语句时都加上一个ConnectionTimeout=0

[chenjunsheep]

......