Dear All, I installeed DB2 Client server and Microsoft OLEDB Provider dfor DB2 on my serrver still not able to connect. plesae suggest me step by step regards, Vipin jhaThankx & regards, Vipin jha MCP

What error are you getting? I have installed OLEDB for DB2 from this web site http://www.microsoft.com/en-us/download/details.aspx?id=11988 and it works just fine Microsoft OLEDB Provider for DB2 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. The package includes product updates in the form of an integrated Service Pack 1. Read the installation guide and Readme for more information. Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/