Showing posts with label ole. Show all posts
Showing posts with label ole. Show all posts

Sunday, March 25, 2012

Download Microsoft OLE DB Provider for DB2

Hi

The readme file for SQL Server 2005 says:

4.10.1 Obtaining the Microsoft OLE DB Provider for DB2

The Microsoft OLE DB Provider for DB2, which is a component of Microsoft Host Integration Server 2004, can be downloaded for use with SQL Server 2005. For information about how to install and configure the OLE DB provider, see the documentation that is included with the provider. For instructions about how to download this provider, see this Microsoft Web site. (http://go.microsoft.com/fwlink/?LinkId=52036)

However, I cannot seem to find it...?! Sad

Michael, try check back after 11/7 (the day for SQLServer2005 Launch).

Thanks
Wenyangsql

Sunday, February 19, 2012

doing transactions with linked server(ole db provider)

Hi all,

When i begin a distributed transaction..., do i need to always
set xact_abort on?

But when i tried to put custom error handling to roll back a transaction with a linked server , it seems its impossible (as set xact_abort on, already automatically rolls back the transaction)

Does anyone have any ideas on this?

Thanks in advance

Bennyset xact_abort on is not required for distributed transactions.|||But i get an error when i dont set that.
Do you know what has to be done instead?

Thanks for your feedback

Benny

Tuesday, February 14, 2012

Does the OLE DB Provider for OLAP Services Work with RS

Thanks in advance for any and all help ...
I'm exploring using reporting services to report on analysis services data
sources. When I try to create the connection it gives me a data link error
'Provider is no longer available.' I'm not sure where in windows I manage
OLE DB providers, but I decided to install the latest version of MDAC. This
did not seem to do anything ...
Any ideas on how to get the provider installed?
Thanks!It does but you'll have to write the MDX yourself I'm afraid :(.
--
Brian Knight
SQL Server MVP
http://www.sqlservercentral.com
Reporting Services Resource Center -
http://www.sqlservercentral.com/rc/rc.asp?rc=105
"See Guy" <123@.123.com> wrote in message
news:%23MUEklRZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Thanks in advance for any and all help ...
> I'm exploring using reporting services to report on analysis services data
> sources. When I try to create the connection it gives me a data link error
> 'Provider is no longer available.' I'm not sure where in windows I manage
> OLE DB providers, but I decided to install the latest version of MDAC.
> This
> did not seem to do anything ...
> Any ideas on how to get the provider installed?
> Thanks!
>