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

Profile Run Fails for a Microsoft SQL Server Resource in Enterprise Data Catalog
Problem Description
​When you enable the useDSN property in the Microsoft SQL Servicer connection options, and you run a profile on the Microsoft SQL Server resource in Enterprise Data Catalog, the profile run fails, and the following error appears:

FnName: Execute – [Informatica][ODBC 20101 driver][Microsoft SQL Server]Incorrect syntax near 'ALL_DATA_TYPES'. FnName: Execute – 523 158]….
Cause
​This issue occurs when Informatica generates SQL statements with quoted identifiers and the EnableQuotedIdentifiers property is disabled.
Solution
​To resolve this issue, set the EnableQuotedIdentifiers property to 1 in the odbc.ini file.
More Information
Applies To
Product: Enterprise Data Catalog
Problem Type: Configuration
User Type: Data Steward
Project Phase: Onboard
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:1/14/2020 1:46 AMID:613674
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)