title: 32-bit Text drivers (Microsoft Access , Microsoft Excel and Text files ) from a 64 bit application on windows 7
body: <p>Hi i have an application developed on XP with Text ODBC drivers. But when i deployed on Win 7 with office 2007, i have connection issues.</p>
  
  <pre><code>&lt;add key="SQLConnection.TextConnectionString" value="Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\Data\;Extensions=asc,csv,tab,txt;Persist Security Info=False" /&gt;
  </code></pre>
  
  <p>ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified</p>
  
  <hr>
  
  <p>i have googled every solutions like installing the following</p>
  
  <p><a href="http://blogs.msdn.com/b/sqlblog/archive/2009/12/29/how-to-connect-to-file-based-data-sources-microsoft-access-microsoft-excel-and-text-files-from-a-64-bit-application.aspx" rel="nofollow noreferrer">http://blogs.msdn.com/b/sqlblog/archive/2009/12/29/how-to-connect-to-file-based-data-sources-microsoft-access-microsoft-excel-and-text-files-from-a-64-bit-application.aspx</a></p>
  
  <p>Microsoft Access Database Engine 2010 Redistributable (32-bit)</p>
  
  <p>2007 Office System Driver: Data Connectivity Components</p>
  
  <p>after all of those, in my datasources(ODBC), it still only shows "SQL native client/SQL server/SQL server native client"</p>
  
  <p>in the C:\Windows\SysWOW64\odbcad32.exe</p>
  
  <p>i can see all the x32 drivers, but how can i modify my connection strings to access 32-bit Microsoft Text Drivers or are there any alternative solutions? 
  Thanks</p>