🚀 go-pugleaf

If you just execute one-two stored procedures and most of works happens on
the server then you, may be, can gain some milliseconds using different db
access component, but in this case is better to use components that you are
familiar with and that are convernient for you. Programming will be much
easer, you will not make errors that goes from programming with technologies
you are not familiar with, and your users will see no difference anyway.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"K Y Iyer" <iyer@ndtv.com> �������/�������� � �������� ���������:
news:3c4d28a9_2@dnews...
> Thanks for your insights.  I know I can use ODBC - in fact I am using ODBC
> to connect to my SQL Server 2000.  My application requires about 17
threads
> which run one stored procedure each on the SQL Server.
>
> My great fear is the additional overhead imposed by ODBC when I am running
> rather heavy database operations from the client.  I must point out that
> there is no network traffic generated as all the work happens on the
server
> only.
>
> I was hoping that ADO/OLEDB may give me better performance in the long
> rung - though I can't see any degradation in performance using ODBC.
>
> Regards
>
> Iyer
> "Vassiliev V.V." <vv_vas@iname.com> wrote in message
> news:3c4aa883_1@dnews...
> > You can access MS SQL Server through about any db access components
> > including ODBC, BDE, ADO etc. You can look for db access components on
> > internet. What you should choose greatly depends on what you need. Do
you
> > need high speed access, or you want write a db application with few
lines
> of
> > code, are you restricted to use exact db access technology. ADO Express
is
> > widely used and you can ask your question about it on most ADO-related
and
> > Delphi-related newsgroup. May be the best option for you is use
> > ADO/ODBC/OLEDB etc. directly
> > (ADO/ODBC/OLEDB headers are in Include directory). You can also try
OLEDB
> > Direct
> > components at http://www.oledbdirect.com that use OLEDB without ADO.
> >
> > Regards,
> > Vassiliev V.V.
> > http://www.oledbdirect.com
> >
> >
> > "K Y Iyer" <iyer@ndtv.com> �������/�������� � �������� ���������:
> > news:3c497b20_1@dnews...
> > > Hi
> > >
> > > I've just purchased BCPP 5.0 Professional.  Do I need ADOExpress to
> access
> > > SQL Server ?
> > >
> > > If I do not have ADOExpress, is ODBC the only other alternative ?  If
> yes,
> > > can I create a ODBC connection programatically from my application ?
> > >
> > > Anyway - thanks very much.
> > >
> > > Regards
> > >
> > > Iyer
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>