Problems with OLE DB and ODBC on 64 bit systems
So, for the past few months a DBA and I were trying to figure out why all of our SSIS packages, connection strings and data sources all work fine on Server 2003, SQL 2005 and of course in dev, but not on our production SQL 2005 server. After extensive research (which was probably right in front of our faces the whole time) we stumbled over the following KB article: KB957570 Which very briefly explains how the OLE DB and ODBC…