🚀 go-pugleaf

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
> >
> >
> >
> >
> >
> >
>
>
>
>