March 2010 - Posts

• Running 32-bit SSIS in a 64-bit Environment

  After my recent post on where to find the 32-bit ODBC Administrator on a 64-bit SQL Server, a new question was asked about how to get SSIS to run with the 32-bit ODBC instead of the 64-bit ODBC. You need to make a simple configuration change to the properties Read More... Posted Wednesday, March 24, 2010 10:54 PM by John Paul Cook | 10 Comments

• 32-bit ODBC on Windows Server 2008 R2

  Heterogeneous data access requires having the right drivers. If you have to use 32-bit ODBC drivers, you won’t find then when you start the Microsoft ODBC Administrator because it is 64-bit. The 32-bit ODBC Administrator is found here: C:\Windows\SysWOW64\odbcad32.exe Read More... Posted Tuesday, March 16, 2010 7:16 PM by John Paul Cook | 10 Comments

• Oracle Linked Servers on Windows Server 2008 R2

  Oracle hasn’t yet released versions of its client software for Windows Server 2008 R2. If you need to create an Oracle linked server, that’s a problem. You’ll see this installation block when attempting to install the Oracle client software for Windows Read More... Posted Monday, March 15, 2010 1:05 PM by John Paul Cook | 2 Comments