+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: General (https://www.learnqtp.com/forums/Forum-General)
+--- Forum: Suggestions and Feedback (https://www.learnqtp.com/forums/Forum-Suggestions-and-Feedback)
+--- Thread: how to connect qtp to hive (/Thread-how-to-connect-qtp-to-hive)
how to connect qtp to hive - smiley - 10-04-2016
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