var objCon = COMCreateObject("ADODB.Connection"); objCon.Open("Provider=OraOLEDB.Oracle.1;Data Source=SIEBPRDDB;User Id=siebel;Password=P@ssWod;PLSQLRSet=1"); var oadoRecordsetUA = objCon.execute("SELECT MAX(SR_NUM) from siebel.s_srv_req where ROW_ID='"+sRowId+"'"); oadoRecordsetUA.moveFirst(); oadoFieldUA = oadoRecordsetUA.Fields.Item(0); strSRNum = oadoFieldUA.Value;