I'm new in UFT and I need to conect to a database. I added Oracle in the Add-ins and typed the next code:
DB_CONNECT_STRING = "Provider=OraOLEDB.Oracle; Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="myhost")(PORT=1521))(CONNECT_DATA=(SERVICE_NAME="myservice"))); User ID="myuser";Password="mypassword";"
Set myConn = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")
In the last line fails and appears the next message:
Provider cannot be found. It may not be properly installed.
I saw in other posts people installed oracle client but I don't know if it's strictly neccesary.
Thanks for your help!