Re: Implementation of full text
From: John Kane (jt-kane_at_comcast.net)
Date: 09/29/04
- Next message: Vinodh: "The Microsoft Search service cannot be administered under the present user accou"
- Previous message: Anil Saharan: "Re: Implementation of full text"
- In reply to: Anil Saharan: "Re: Implementation of full text"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Sep 2004 17:21:55 -0700
Anil,
ESP or (Extended Stored Procs) can use the OLE-DB API and if you are using
the DBLib API you are cutting your own code's future as it is most likely
(un-confirmed) that Microsoft will drop, i.e.. remove the DB-Library API
from future SQL Server versions, such as SQL Server 2005 (Yukon).
See SQL Server 2000 BOL titles "Running Stored Procedures (OLE DB)",
"Extended Stored Procedure Architecture", "Programming Extended Stored
Procedures" and "Samples" and specifically the sample app xp-ODBC for more
info.
In the final analysis, if you're putting the time and effort to write your
own ESP wouldn't you want to use all of the features and data types that SQL
Sever 2000 contains as well as be fully supported in future versions and
applications?
Regards,
John
"Anil Saharan" <aksaharan@devdex.com> wrote in message
news:eJ8e5VapEHA.2304@TK2MSFTNGP14.phx.gbl...
> John,
> I wrote in context of Extended Stored Procedures and I guess OLE-DB and
> other new API are application API and not the extension API's which
> would replace ESP functionality.
>
> The limitation is on the ESP input/output parameters.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~
> Anil
> http://www.aksaharan.com/
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
- Next message: Vinodh: "The Microsoft Search service cannot be administered under the present user accou"
- Previous message: Anil Saharan: "Re: Implementation of full text"
- In reply to: Anil Saharan: "Re: Implementation of full text"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
