odbc or bdp?

[KaaN]

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.

[Daniel Morgan]

KaaN wrote:
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.
hi,

Why did you think it would be of value to post the same question twice
with two different
subjects?

That asked ... why do you think it is of value to ignore Oracle's native
connection for
something that is slower, less robust, and less secure?

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[tojo]

In article <fe82834e.0310300621.63ef5eeb@posting.google.com>,
kaanoezturk@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.

-- Tom

[J Alex]

"tojo" <Tojo@hotmail.com> wrote kaanoezturk@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?

[Sybrand Bakker]

On Thu, 30 Oct 2003 15:15:00 GMT, "J Alex" <nospam@nospamx.info>
wrote:
"tojo" <Tojo@hotmail.com> wrote kaanoezturk@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