QTP总结之（一）－通过ODBC连接ORACLE

'通过odbc连接oracle数据库格式
'Dim res,cmd,sql
'Set res=createobject("adodb.recordset")
'Set cmd=createobject("adodb.command")
'Cmd.activeconnection="Driver={Microsoft ODBC for Oracle};Server=oradb;Uid=bpm6_test_0305;Pwd=bpmtest;"
'Cmd.CommandType = 1
'sql="select * from mocha_bo_type_def t where t.type_def_name='"&w_type1&"'"
'Cmd.CommandText = sql
'Set res = Cmd.Execute()
'res("user_id")