September 1, 2014 at 12:06 pm
Hi all,
I would like to use SSIS to get data from a mySQL database to SQL Server.
I have created a project incl package. In this package I have added an ADO net source and ADO net destination, linked together
If I try to connection to the mySQL source I get the error message:
"
Test connection failed because of an error in initializing provider ERROR [M014] [MICROSOFT][ODBC Driver manager]
The specified DSN contains an architecture mismatch between driver and application
"
I have searched this forum (and more) to find out what the problem might be and I think the problem is that my system is 64-bit, and the mySQL programm is 32-bit?
In SQL Server I have created a linked server and this works fine (rather quickly actually).
I use the same ODBC 5.2 driver for both connections.
What can I do to connect SSIS to mySQL?
Thanks in advance
Hein
September 1, 2014 at 1:31 pm
SpeedSkaterFan (9/1/2014)
Hi all,I would like to use SSIS to get data from a mySQL database to SQL Server.
I have created a project incl package. In this package I have added an ADO net source and ADO net destination, linked together
If I try to connection to the mySQL source I get the error message:
"
Test connection failed because of an error in initializing provider ERROR [M014] [MICROSOFT][ODBC Driver manager]
The specified DSN contains an architecture mismatch between driver and application
"
I have searched this forum (and more) to find out what the problem might be and I think the problem is that my system is 64-bit, and the mySQL programm is 32-bit?
In SQL Server I have created a linked server and this works fine (rather quickly actually).
I use the same ODBC 5.2 driver for both connections.
What can I do to connect SSIS to mySQL?
Thanks in advance
Hein
Quick solution would be to query the MySql via the linked server connection.
September 1, 2014 at 1:53 pm
Hallo Eirikur,
I don't think that is the solution
The linked server only allows me a small portion of the things I want to do
1 of the tables I need to address is over 10 million records, which is far to large for a linked server (as I found out)
Hein
September 1, 2014 at 2:05 pm
SpeedSkaterFan (9/1/2014)
Hallo Eirikur,I don't think that is the solution
The linked server only allows me a small portion of the things I want to do
1 of the tables I need to address is over 10 million records, which is far to large for a linked server (as I found out)
Hein
Got it;-)
Have you tried MariaDB ODBC[/url] drivers instead, I remember that solving some issues?
Edit: added link
September 1, 2014 at 2:31 pm
Hallo Eirikur,
I will give it a go, thanks for your suggestion
Hein
September 2, 2014 at 3:25 am
Download ODBC 5.1 driver 32 bit. I had also same problem while creating data source for SSRS report. It's resolve after installing ODBC 5.1 32 bit driver.
September 2, 2014 at 1:12 pm
Hi Shahnawaz,
I did as you suggested.
After installing the driver it took a while to get it mentioned in the administrative tools\data sources (odbc) dialogbox, but using the file C:\Windows\SysWOW64\odbcad32.exe got that solved (for other readers, this is where I found the information: http://www.milanm.com/?p=556
Now I have a connection to the database, and the table I am looking for. So far so good.
The new challenge is that I can connect to the table, but there are no columns and or information visible.
So I have to sort that out.
But as I say: new challenges provide new insight.
Thanks for getting me on my way
Hein
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy