sql server connect: OLE DB providers are installed and you don't really have to
configure anything like you do with ODBC DSNs. When you
install MDAC, you install several MS OLE DB providers.
The one for SQL Server is installed. So it's already
installed and ready for you to use...you don't have to do
anything.When someone uses something like ADO on a web page
or in an application, they connect to SQL Server through the
ADO connection string. This connection string references the
OLE DB provider (it can reference an ODBC driver as well).
The OLE DB provider gets instantiated when you open the
connection in your code and that's essentially how it works.
The configuration part is just the connection string that
you use in your code.
ADO and ADO.Net related information may help you understand
it better. A good site to visit is:
http://www.able-consulting.com/tech.htm
The site also has a lot of connection string examples for
ADO and ADO.Net.

Another thing you may want to try is DTS in SQL Server. If
you are comfortable messing around with that tool and you
connect to different data sources, those sources listed are
based upon the OLE DB providers installed on the computer
where you are running DTS. As you will see, you just select
the provider and the data source and then import, export,
etc the data.

Hope that helps -

-Sue

On Wed, 27 Aug 2003 14:27:17 +0200, "Jeff"
[quoted text, click to view]