Re: odbc or bdp?
From: tojo <Tojo_at_hotmail.com>
Date: Thu, 30 Oct 2003 16:03:29 +0100
Message-ID: <MPG.1a0b46a8a253d7bd9896be_at_news.t-online.de>
Date: Thu, 30 Oct 2003 16:03:29 +0100
Message-ID: <MPG.1a0b46a8a253d7bd9896be_at_news.t-online.de>
In article <fe82834e.0310300621.63ef5eeb_at_posting.google.com>,
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.
- Tom