Highlighted
Absent Member.. Absent Member..
Absent Member..
591 views

UFT 12.02 : Unspecified error on ADODB connection consistently in UFT 12.02 env

unspecified error for ADODB Connection  

1) while connecting excel sheet through UFT using ADODB connection, it shows Unspecified error.

UFT version - 12.02

screenshot : refer the attachment for the error.

Example : Snippet

Set objConn = Nothing

strFilePath = "H:\test.xls"

strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFilePath + ";Extended Properties=""Excel 12.0 xml;HDR=Yes;IMEX=1"""

Set objConn = Nothing

Set objTestData = Nothing

    'If objConn = Nothing Then

    Set objConn = CreateObject("ADODB.Connection")

    objConn.Open strConnectionString

 

2) But while connecting excel sheet through VBA using ADODB connection, it is working fine.

0 Likes
1 Reply
Highlighted
Outstanding Contributor.
Outstanding Contributor.

Re: UFT 12.02 : Unspecified error on ADODB connection consistently in UFT 12.02 env

Hi Dinakaran,

Hope you are doing well.

HP does not provide support over the connection string, driver or database engine, so its configuration is the end-user's responsability. Below document contain suggestions collected over various scenarios.

https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/KM00780406

 

Also i found another possibility that may help you:

http://community.hpe.com/t5/Unified-Functional-Testing/Unable-to-connect-to-Oracle-databases-using-ADO-within-UFT-11-5/m-p/6324185#M6364

  1. I uninstalled all oracle drivers I had installed previously
  2. Rebooted my machine
  3. Downloaded the 64-bit and 32-bit Oracle 12c client install packages– look for the section near the bottom labeled Oracle Database 12c Release 1 Client (12.1.0.1.0) for Microsoft Windows (x64 and 32-bit)
  4. Installed 64-bit client first [installed to C:\oracle\product\12.1.0\client_64]
  5. Rebooted my machine [Note:  I tried installing the 32-bit version immediately afterward, but I got a weird installer error.  It worked fine after the reboot.]
  6. Installed 32-bit client [installed to C:\oracle\product\12.1.0\client_32]
  7. Rebooted again (because Windows)

I don't know what the magic sauce was here - maybe installing the full client instead of just the ODAC package did the trick.

Hope you will find well this information.

Best regards.

Ruddy Alvarez H.
Customer Support Engineer

If you find thst aat this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the pond show your appreciation.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.