Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: “[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Database driver error” with Oracle/SQL Server tasks after IICS Spring '20 upgrade on Windows Secure Agent
Problem Description
The following error occurs with Oracle/SQL Server tasks after IICS Spring '20 upgrade. Tasks were running fine before the IICS Spring '20 upgrade.​​

ERROR: “[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Database driver error” 
Cause
​IICS has new drivers that needs to be applied as part of this upgrade and it needs a Registry update. This error may occur after the IICS Spring '20 upgrade, if the Secure Agent did not have permissions to update the Registry.
Solution
The changes needed on the *.reg files (in the attached zip) are:

  • Unzip the attached Windows_Spring_2020_Registry_entries.zip file and open each .reg file with a text editor like Notepad++.
  • Update the “Setup” and “Driver” parameter so that the {Agent.Dir} is replaced with the directory where the agent is installed, like “C:\\Program Files\\Informatica Cloud Secure Agent” (Note: the double \\ in the path)
    For example, after the edit, the “Driver” and “Setup” parameter values for the orcl.reg file would look like: “{agent.Dir}\\drivers\\odbc\\datadirect\\r33\\dwora28.dll”.
  •  After editing all the *.reg files, just double click on the *.reg files on the agent machine, there will be a prompt informing about the change, Click on “Yes” to complete the import.
  • Start the failing tasks again.

PS: Before making any changes please make a back up of the Registry. We can make a backup of the Key "HKEY_LOCAL_MACHINE" (Open Registry Editor​, Select HKEY_LOCAL_MACHINE> Right Click and export to a file to backup)​

More Information
Applies To
Product: Cloud Data Integration
Problem Type: Connectivity; Product Feature
User Type: Administrator
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:5/27/2020 2:59 PMID:608868
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)