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 : [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.
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).
FAQ: Is there a change in the connectivity technology to SQL Server databases from PowerCenter 9.6.0? (KB 160118)
What can we do to improve this information (2000 or fewer characters)