Re: SQL Server 2000/DB2 OLE DB Provider

Warren,

For SQL Server 2000 I ended up going with the OLE provider that is supplied
with HIS 2006. Also the current DB2 OLE Provider for SQL Server 2005 is
available with the February 2007 feature pack. Note that SQL Server 2005
Enterprise Edition is required for this provider.

Thanks for the info.

RT
--
Regards,


"Warren Brunk" wrote:

In the past I used host integration server to achieve this...We used this
since we had some biztalk applications using it as well.
http://technet.microsoft.com/en-us/library/ms178027.aspx
http://msdn2.microsoft.com/en-us/library/aa213281(SQL.80).aspx

I have had many colleagues set up a UDL file with success before although I
have never done so.
http://www.microsoft.com/technet/prodtechnol/host/proddocs/dataint/oledb_about_ole_db_provider_for_db2.mspx?mfr=true
Click on
"Configuring a Data Source for OLE DB Provider for DB2"

As you stated below nothing is as easy as the SQL 2005 feature pack
connection though!


--

/*
Warren Brunk - MCITP,MCTS,MCDBA
www.TechIntSolutions.com
www.RealWorldSQL.com
*/


"Robert Thompson" <RobertThompson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:AE427367-0770-4EAC-B6C4-ED6256A90129@xxxxxxxxxxxxxxxx
What is the current DB2 OLE DB Provider for SQL Server 2000 + SP4 and how
do
I get it? I need to do some linked server connectivity to DB2.


I have found the SQL Server 2005 version as part of a feature pack but I'm
uncertain about what is current for 2000.

Is the version that comes with SQL Server 2005 feature pack April 2006
backward compatible with SQL Server 2000 or do I need to use a version
supplied with HIS? If so, which version of HIS?

Thanks.




--
RT




.

Relevant Pages
Loading