jeff

Hello all experts!

My problem is that I do not know how to create an Microsoft OLE DB Provider
on my win98 client!

My system:
- SQL Server 2000 (client connectivity) on the win98 - (client-pc)
- SQL Server 2000 on the server, Windows Server 2003 (server-pc)

This is what I have done:
- Read the help files
- I have looked in the ODBC Data Source Administrator for a clue to how to
setup an OLE DB Provider.
- Searched the internet for help
- Searched newsgroups for articles on this issue.
So fare no luck finding a way to create the OLE DB Provider.

In the ODBC Data Source Administrator I have read it is possible to create
an OLE DB Provider for ODBC, but I
can't see how to do it.

I DO NOT EXPECT YOU TO FULLY DESCRIBE HOW TO CREATE AN OLE DB PROVIDER.
BUT MAY BE YOU COULD GIVE ME A CLUE TO HOW TO DO IT. For example what
applications are being used
to create an OLE DB Provider.

Please help me, this may sound like a stupid question but I'm new to SQL
Server and wants to learn more about it.

Jeff

sue hoegemeier

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