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 : [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 .].]
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).
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.
This is a part of the Microsoft SQL Server Feature Pack, which can be downloaded from the Microsoft website. The download link is:
Click here for more details on PowerCenter Express forum post.
FAQ: Is there a change in the connectivity technology to SQL Server databases from PowerCenter 9.6.0? (KB 160118)
"ERROR: Failed to create and initialize SQL OLE DB instance" when using Microsoft SQL Server with PowerCenter 9.6 (KB 159016)
What can we do to improve this information (2000 or fewer characters)