Skip to Content.
Sympa Menu

freetds - Re: TDS implementation on windows: using OLDEDB to access proprietary database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
  • Cc: sharad AT ITAngel.com
  • Subject: Re: TDS implementation on windows: using OLDEDB to access proprietary database
  • Date: Thu, 1 Aug 2002 07:09:16 -0400


On Wed, 31 Jul 2002 15:08:50 -0400, "Sharad Bansal" <sharad AT ITAngel.com>
wrote:

> I am building a proprietary database on the windows platform and want to
> allow microsoft clients connect to it using OLEDB. As I understand, for
> this to happend I need to make sure that the prop database talks TDS
> format and responds to queries from clients just like microsoft SQL
> server does.

Sharad,

If I understand you correctly, your database and clients are on a
Microsoft platform, and you want the clients to use OleDB to access the
database.

You don't need TDS to do that. You "just" write an OleDB provider with
VC++. The OleDB Tables and Accessors in OleDB will be the means by which
your clients access the data in your proprietary database. The client
(normally written in VB) then opens your database in much the same way it
would open an ODBC data source; the database may be local or elsewhere on
the network.

Microsoft wrote an "OleDB provider" interface to SQL Server. I think our
documentation might say that their OleDB interface is "just another client
library", but on reflection I think that's not true. AFAIK, we have no
evidence that the OleDB provider uses TDS, nor any reason to think it
would. Their provider lives on the server; it is accessed by a local
client via DCOM.

Regards,

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page