Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

ERROR: "Error: Failed to create and initialize SQL OLE DB instance. Reason [1008]: [An attempt was made to reference a token that does not exist" while running a preview on data or running a profile job using a Microsoft SQL Server database connection
Problem Description

​While running a preview on the data or running a profile job using a Microsoft SQL Server DB connection, it is fails with the following error:

[LDTMCMN_0029] message [com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database [
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 [sa] and connection string [].].]
However, it will still be able to create connections, and the test connections works as normal. In addition, creating new physical data objects is also possible without any issues.
Cause

​This issue occurs because of the change in the mechanism of how PowerCenter connects to SQL Server.

 

Prior to PowerCenter Express 9.6.0, OLEDB mechanism was used. From PowerCenter Express 9.6.0 onwards, it requires SQL Server Native Client (SNAC).

Solution

 

​To resolve this issue, SNAC needs to be installed manually as it is not part of the default installation of the SQL Server client software.

More Information

This is a part of the Microsoft SQL Server Feature Pack, which can be downloaded from the Microsoft website. The download link is: 

http://www.microsoft.com/en-in/download/details.aspx?id=29065

Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter Express
Database: Microsoft SQL Server 2008
Operating System: Windows 7; Windows 2008; Windows
Other Software: Data Profiling; Informatica Developer

Reference

Click here for more details on PowerCenter Express forum post.

 

Attachments
Last Modified Date:3/16/2015 11:39 PMID:160624
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)