Posted by Erland Sommarskog on 07/24/05 12:02

Mark Yudkin (myudkinATcompuserveDOTcom@boing.org) writes:
> Microsoft SQL Server 2000 is not a DB2 client. It has facilities for
> connecting to remote databases, but you must configure these correctly to
> use the IBM DB2 drivers, not the Microsoft SQL Server drivers. MSDASQL is
> Microsoft SQL Server driver, not an IBM DB2 driver.

Correction: MSDASQL is an OLE DB provider that uses an ODBC driver as
its data source. It is thus not specific for SQL Server, bu can be used
to connect to any data source for which there is an ODBC driver.

Thus when you say:

> Your best bet - assuming you really do need a Microsoft SQL Server in the
> equation at all - is to use the IBM ODBC driver from SQL Server.

You are saying that he should use MSDASQL.

To wit, when you communicate with a linked server from SQL Server, you
always to this over OLE DB. Either then you use a targeted OLE DB provider,
or you use MSDASQL to use an ODBC driver. Usually it's preferrable to
use a targeted OLE DB provider over MSDASQL.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]