Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    15
  • Views views
    77
  • Users 0 members are here
Related
Options

Unable to connect to Oracle DB using lr_db_connect

Narmadha Rajkumar

Hi All,

I am trying to connect to Oracle DB using lr_db_connect but getting following error.

Script:

lr_db_connect("StepName=StoredProc",
"ConnectionName=DB_Connect",
"ConnectionString=Provider=OraOLEDB.Oracle.1;Data Source=<hostname:portnumber>;User ID=<MyUID>;Password=<mYPassword>",
"ConnectionType=OLEDB",
LAST); 

Error Log:


DB Connection failed {"The 'OraOLEDB.Oracle.1' provider is not registered on the local machine."}
Error (-17939): DB Connection failed {"StoredProc"}
Abort was called from an action.

I tried installing both 64 and 32 bit of SQL Developer tool but still throwing same error. Any thoughts.

Thanks,

Narmadha

  • 0  

      ,

    Please check the error message The OraOLEDB.Oracle.1' provider is not registered on the local machine.on google. Looks to me a generic error of the Oracle API.

    Note that LRE/LRP is a 32 bit application.

    P.S.

    1. Do not send private messages to push things. Posting on forum will give you most exposure to your problem.

    2. Read the linked article below 'How to ask questions'

    How to ask questions

    Reward contributions via likes or 'verified answers'

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.