Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(5 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"ERROR: Failed to create and initialize SQL OLE DB instance" when using Microsoft SQL Server with PowerCenter 9.6
Problem Description

When running a session using a Microsoft SQL Server Source, Target, or Lookup in Informatica 9.6, the following error is seen in the session log and the session fails:

 

CMN_1022 : Database driver error...
CMN_1022 [
Error: Failed to create and initialize SQL OLE DB instance. Reason [1008]: [An attempt was made to reference a token that does not exist.
]
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [infa] and connection string [].]

 

The same session might work fine in earlier versions.

Cause

This issue occurs due to a change in how PowerCenter connects to SQL Server.

Previous versions up to 9.5.1 used the OLEDB mechanism while 9.6 requires the SQL Server Native Client (SNAC).

 

Solution
SNAC is not part of the default installation of the SQL Server client software and needs to be installed manually.
It is part of the Microsoft SQL Server 2012 Feature Pack, which can be downloaded from the Microsoft website at http://www.microsoft.com/en-in/download/details.aspx?id=29065 
Note
 
The latest version of the Native Client should be used for all supported versions of Microsoft SQL Server prior to 2012 as well.
More Information
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter 9.6.0
Database: Microsoft SQL Server
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:3/18/2014 10:59 PMID:159016
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)