Obsolete technology - dblibrary

Hello!
In my application I need to use extended stored procedures.
Developing these extended stored procedures I use the "dblibrary APIs" to
access MS SQL Server 2000.
As far as I understand /reading articles in MSDN/, Microsoft declares its
intention not to support dblibrary in future.
Which is the recommended method to access MS SQL Server?
Thank you!In order, the preferences are:
ADO.Net (but you have to be writing in VB.Net or C#)
ADO
OLE-DB
ODBC
SQL-DMO for controlling the server instead of manipulating the data.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"ggeshev" <ggeshev@.tonegan.bg> wrote in message
news:OdH$50COEHA.2336@.TK2MSFTNGP09.phx.gbl...
> Hello!
> In my application I need to use extended stored procedures.
> Developing these extended stored procedures I use the "dblibrary APIs" to
> access MS SQL Server 2000.
> As far as I understand /reading articles in MSDN/, Microsoft declares its
> intention not to support dblibrary in future.
> Which is the recommended method to access MS SQL Server?
> Thank you!
>|||I'd just tack on SQLXML/IIS onto the end of Geoff's list (in that order) as
well as this is a data access method which is growing in popularity and
might suit your development strategy, especially if you're in the web area\
or working with something like Biztalk.
Regards,
Greg Linwood
SQL Server MVP
"ggeshev" <ggeshev@.tonegan.bg> wrote in message
news:OdH$50COEHA.2336@.TK2MSFTNGP09.phx.gbl...
> Hello!
> In my application I need to use extended stored procedures.
> Developing these extended stored procedures I use the "dblibrary APIs" to
> access MS SQL Server 2000.
> As far as I understand /reading articles in MSDN/, Microsoft declares its
> intention not to support dblibrary in future.
> Which is the recommended method to access MS SQL Server?
> Thank you!
>|||Just in case the other posters missed that you are developing extended proc's:
Forget about ADO.NET, as it is not supported to have SQL Server execute CLR code.
For this type of low-level programming, I have a feeling that ODBC or OLEDB is the best choice. www.sqldev.net
might have some comments about this...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"ggeshev" <ggeshev@.tonegan.bg> wrote in message news:OdH$50COEHA.2336@.TK2MSFTNGP09.phx.gbl...
> Hello!
> In my application I need to use extended stored procedures.
> Developing these extended stored procedures I use the "dblibrary APIs" to
> access MS SQL Server 2000.
> As far as I understand /reading articles in MSDN/, Microsoft declares its
> intention not to support dblibrary in future.
> Which is the recommended method to access MS SQL Server?
> Thank you!
>