question

Jhumma avatar image
Jhumma asked

Getting error for ODBC from SSIS

Getting error from SSIS which is trying to connect MYSQL using ODBC. ---On SSIS making ADO.Net connection and getting following error.. ---When I was configured ODBC and use all credential for System DSN and that's work perfect.. ERROR:- 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
sql-server-2005ssisodbcado.net
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
arthurz avatar image
arthurz answered
This could be related to the driver bitness. The SSMS or BIDS are 32 bit apps and therefore by default would attempt to load a 32 bit driver. But if you only have the 64 bit version installed these dev tools would not find it just like that. Frankly speaking, you have failed to post enough particulars to help you any further. The following article though solves most issues on how to connect SSIS and MySQL http://blogs.msdn.com/b/mattm/archive/2008/03/04/connecting-to-mysql-from-ssis.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.