how to connect qtp to hive

[smiley]

Hi Sir/Mam,

I am trying to connect QTP to hive using the below code, but it is not working. Can any one suggest me how to connect

Set objConnection = CreateObject("ADODB.Connection")

Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.open "Driver = Hive;Database Port = 10000;Driver(JDBC) = Hortonworks HiveServer2 HDP 2.3;Database URL =                                     

        jdbc:hive2://g4t8346c.houston.hp.com:10000; Database Userid = srvc_eap_uat;Database Password = *********;"

 objRecordSet.open sqlQuery, objConnection 

 value = objRecordSet.fields.item(0)                

 msgbox Value
'
objRecordSet.Close
objConnection.Close
Set objConnection = Nothing
Set objRecordSet = Nothing


Thanks 
Anusha