Re: odbc or bdp?

On Thu, 30 Oct 2003 15:15:00 GMT, "J Alex" <nospam_at_nospamx.info> wrote:

>
>"tojo" <Tojo_at_hotmail.com> wrote
>> kaanoezturk_at_yahoo.com says...
>> > hi,
>> > i am working on a asp.net project with c# builder.
>> > the application should work with sql server and oracle.
>> > which one should i use for the database connections. odbc or bdp.
>> > odbcconnection class works faster than bdpconnection.
>> >
>> You should use the best possible data layer for Oracle (ODP.NET), and
>> the best possible data layer for SQL-Server (System.Data.SqlClient). Yes
>> this means you'll have to write your SELECTs etc. twice, but a generic
>> solution like odbc will end up killing you.
>>
>Why?
>

Because it is a *generic* solution, and the generic solution defines the *smallest* common denominator. Consequently, any functionality for which no mapping exsists between the odbc driver and the database, has to be executed on the client.
Example: use any visual basic function for which no Oracle equivalent exists, and the ODBC driver will get all the data to the client, and perform the function there.
Consequently, you end up using only a small part of the host platforms power.

--
Sybrand Bakker, Senior Oracle DBA