title: Via SSIS, cannot connect to mysql DB with User DSN that connects successfully and is in ODBC.INI registry
body: <p>Through an <code>SSIS</code> package, I need to export data from a <code>mySql</code> database. So I created a User Data Source with both versions of the <code>mysql odbc 5.3 driver</code> (ANSI &amp; Unicode), and both connect successfully through the <code>ODBC Data Source Administrator</code>.</p>
  
  <p>So in VS2008 (SSIS), I select <code>Odbc Data Provider</code> and then select the mysql user DSN that I created and tested. Once selected, when I click "Test Connection", I get error: <em>Test connection failed because of an error in initializing provider. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.</em> I get the same error with both user DSNs.</p>
  
  <p>What can the problem be? We have <code>Windows Server Enterprise SP2</code> and I don't have administrator access, which is why I can't create a System DSN.</p>
  
  <p>I checked in the Registry Editor and both datasources are under <code>ODBC.INI</code> and they're configured correctly. I also read to change from <code>localhost</code> to <code>127.0.0.1</code> but I still get the same error.</p>
  
  <p>Finally, I created a <code>File DSN</code> which also connects successfully, but I'm not sure how to configure SSIS to look at that data source.</p>
  
  <p>I also installed <code>MySql Connector/ODBC 5.1.13</code> thinking it could be the driver, but I receive the same error.</p>
  
  <p>I also noticed that when I create a data source from the ODBC data source administrator, I can see all mysql drivers, plus the older version that I installed today. On the other hand, when I create a "machine data source" from the VS2008 (SSIS) interface, I don't see any of the mysql drivers. In other words, I cannot create a mysql data source from within VS2008.</p>
  
  <p>Any help is appreciated.</p>