sql server connect: It looks as if query analyzer on my win2k client uses the ODBC SQL Server
Driver as its commection provider...

Is there a way to change this to use the OLEDB provider?

TIA!

JJ

Not that I know of. But what you can do is define a linked server to many
types of data sources from an existing SQL Server/MSDE installation in
Enterprise Manager (Under the Security section). Then you can do queries
against many types of data sources..

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.


*******************************************************************
[quoted text, click to view]

This is correct. Query Analyzer cannot be configured to use OLEDB.

Rand
This posting is provided "as is" with no warranties and confers no rights.