title: Informatica workflow(MS SQL SERVER data source and target) fails error RR_4036"Data Source name not found and no default driver specified ."
body: <p>I have windows 64bit and a Informatica client 32bit installed on it, so I added a DSN entry using the ODBC administrator for 32bit with driver native client &quot;sql server&quot; to connect to a Mssql 2008 R2 database on another pc. I added an entry in system DSN tab because informatica service is using System account. No problems when I have to import source and target in informatica using that ODBC DSN 32 bit &quot;TARGET_DB_sciolto&quot; (see odbc.ini below) entry. I build up my mapping and in the workflow session property than I change the connection from mssql server to ODBC.
  The worflow is failing with same RR_4036 error.I think that the only thing I still have to try is to modify my ODBC.ini file since I read that I must add &quot;enablequotedidentifiers=1&quot; so I opened the file expecting to see a lot of entries but I only see following few lines and don't know what to do and would really appreciate if someone would help:</p>
  <pre><code>[ODBC 32 bit Data Sources]
  test_infa=SQL Server Native Client 10.0 (32 bit)
  TARGET_DB_sciolto=SQL Server (32 bit)
  Target_DB=SQL Server (32 bit)
  [test_infa]
  Driver32=C:\WINDOWS\SysWOW64\sqlncli10.dll
  [TARGET_DB_sciolto]
  Driver32=C:\WINDOWS\system32\SQLSRV32.dll
  [Target_DB]
  Driver32=C:\WINDOWS\system32\SQLSRV32.dll
  </code></pre>