Public Sub OpenOraDB()
On Error GoTo ToExit: --提示这儿有语法错误? OraDB_Open = False
OraConstr = "Provider=MSDAORA.1;Data Source=TESTCASH;Password=CUSTFORTEST;User ID=CUST;Persist Security Info=True"
Set OraDB = CreateObject("ADODB.Connection")
OraDB.ConnectionString = OraConstr
OraDB.CommandTimeout = 30
'OraDB.CursorLocation = adUseServer
OraDB.Open
OraDB_Open = True Exit Sub
ToExit:
MsgBox "连接数据库服务器错误,您可以在网络正常后继续使用。",vbInformation , "错误信息"
OraDB_Open = False
End Sub
On Error GoTo ToExit: --提示这儿有语法错误? OraDB_Open = False
OraConstr = "Provider=MSDAORA.1;Data Source=TESTCASH;Password=CUSTFORTEST;User ID=CUST;Persist Security Info=True"
Set OraDB = CreateObject("ADODB.Connection")
OraDB.ConnectionString = OraConstr
OraDB.CommandTimeout = 30
'OraDB.CursorLocation = adUseServer
OraDB.Open
OraDB_Open = True Exit Sub
ToExit:
MsgBox "连接数据库服务器错误,您可以在网络正常后继续使用。",vbInformation , "错误信息"
OraDB_Open = False
End Sub
On Error GoTo ToExit: '提示这儿有语法错误?
过程怎么能赋值呢?