<p>I need to create a linked server to a DB2 database on a mainframe. Has anyone done this successfully on a 64-bit version of SQL Server 2005? If so, which provider and settings were used?</p>

<p>It's important that the linked server work whether we are using a Windows authenticated account to login to SQL Server or a SQL Server login. It's also important that both the 4-part name and <code>OPENQUERY</code> query methods are functional. We have one set up on a SQL Server 2000 machine that works well, but it uses a provider that's not available for 64-bit SS 2005.</p>

[{'answer_id': 21459, 'author': 'Mark Brackett', 'author_id': 2199, 'author_profile': 'https://Stackoverflow.com/users/2199', 'pm_score': 0, 'selected': False, 'text': "<p>What provider are you using for Sql 2000? I'm pretty sure MS has an x64 OLEDB driver for DB2 (part of Host Integration Server, but available as a separate download). IBM has x64 for .NET and ODBC, and possible OLEDB as well (though it's a PITA to find).</p>\n\n<p>Once you get the linked server setup, I'm pretty sure all of your other requirements would be automatic....</p>\n"}, {'answer_id': 21550, 'author': 'Jon Erickson', 'author_id': 1950, 'author_profile': 'https://Stackoverflow.com/users/1950', 'pm_score': 2, 'selected': True, 'text': "<p>We had this same issue with a production system late last year (sept 2007) and the official word from our Microsoft contact was that they had a 64 bit oledb driver to connect to ASI/DB2 <strong>but</strong> it was in <strong>BETA</strong> at the time.</p>\n\n<p>Not sure when it will be out of beta but that was the news as of last year.</p>\n\n<p>We decided to move the production server onto a 32 bit machine since we were not comfortable using beta drivers on production systems.</p>\n\n<p>I know this doesn't <em>answer</em> your question but it hopefully gives you some insight</p>\n"}, {'answer_id': 22571, 'author': 'Mark Brackett', 'author_id': 2199, 'author_profile': 'https://Stackoverflow.com/users/2199', 'pm_score': 0, 'selected': False, 'text': '<p>From the <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&amp;DisplayLang=en" rel="nofollow noreferrer">Sql 2005 February 2007 Feature Pack</a>:</p>\n\n<blockquote>\n  <p>The Microsoft OLE DB Provider for DB2 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the provider and tools on x86, x64, and IA64 computers.</p>\n</blockquote>\n'}]
['https://Stackoverflow.com/questions/10898', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/162/']