| Erland Sommarskog 2006-10-24, 6:31 pm |
| (alingsjtu@gmail.com) writes:
> I used the IBM DB2 OLE DB Provider instead of Microsoft OLE DB Provider
> For DB2.
> Don't know whether this provider support "OLE DB Services = -2;"
> property. I should wait to next Monday to test.
Since this property is in OLE DB Core Services, I would expect so,
although I cannot vouch for it.
> Do you think whether things will be better if I use Microsoft OLE DB
> Provider For DB2?
Didn't I say that I have no experience of DB2? I don't want to speculate
about software I don't know about. But if you try the other provider,
you may want to try to run the full query again. If the provider provides
the SQL Server optimizer with better statistics, the query plan may be
better.
> And where to get the Microsoft OLE DB Provider For DB2? Could you give
> me a link?
A couple of clicks at www.google.com lead me to:
http://www.microsoft.com/downloads/...1d60-a13c-4479-
9b91-9e8b9d835cdc&displaylang=en
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|