Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "[ODBC SQL Server Wire Protocol driver] Insufficient information to connect to the data source" while creating IDR configuration to replicate from MS SQL server to flat file
Problem Description

While creating Informatica Data Replication (IDR) configuration to replicate from MS SQL server to flat file.


When obtaining the list of tables on Map tables page, the following error is seen:

[​Informatica][ODBC SQL Server Wire Protocol driver]Insufficient information to connect to the data source.
Cause
Solution
​An ODBC driver is required for MS SQL Server connectivity by IDR.

Data Replication provides DataDirect ODBC drivers in the DataReplication_installation/dd/lib subdirectory for Microsoft SQL Server databases.

To resolve this issue, specify the SQL Server ODBC driver in the odbc.ini file.
More Information
Applies To
Product: Universal Data Replication
Problem Type: Connectivity
User Type: Administrator
Project Phase: Configure
Product Version: Informatica Data Replication 9.8.0
Database: Microsoft SQL Server
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/29/2020 8:50 AMID:576956
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)