Re: ODBC-ing my app



Hi,

Craig Leidy wrote:

> I have a perspective customer who will buy my product
> if I ODBC it. He's very DataBase savvy but wants to use
> his own DB... not my Advantage DB.

I'm not sure if this is possible with Advantage DB, but i would suggest
not to use ODBC but ADO directly if you can. ODBC is already
deprecated. If you *really* need to use it you can do it through ADO,
but that will add an extra-layer which will slow it down. It depends on
your speed needs.

try to convince your possible client...

>
> I'm running D5... I don't even see the ADO component tab.
>
> Is this a big job?

Again, it depends on your needs, but it shouldn't be


> Is D5 ADO usable by today's DBs?

ADO is a Microsoft technology, included in MDAC, which is present in
all the newer Windows versions. If your client has older OS versions,
you still can download it from
http://msdn.microsoft.com/data/default.aspx, although i think it
doesn't work for W95. The ADO components provided by Borland are
nothing more than wrappers around Microsoft's ADO. If they're not
present in your D5, you could either upgrade or get a 3rd party ADO
component, like TBetterADO. Check Google for them

To use ADO with Advantage DB you'll need one of 2 things:

- An OLE DB provider: natural way to use ADO. Most databases have one,
usually downloadable from Internet

- An ODBC driver: not the best election, but still usable if no OLE DB
provider present.

>
> Are there any questions I've forgotten?
>

why did the chicken cross the street?

--
Best regards :)

Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.



Relevant Pages

  • Re: TADO vs. TQuery
    ... >> I have an application that uses ODBC to connect to MS SQL ... >> this benefit greatly if I changed to ADO? ... It will take a while to 'tune up' ADO objects to get BDE speed. ... Eventually we started using DOA (Direct ...
    (borland.public.delphi.database.ado)
  • Re: ADODB.Connection object not returning correct ConnectonString prop
    ... Opens the connection (successfully) ... I'm not positive but a guess is that ADO is using the MSDASQL Provider to ... provide OLE DB support for ODBC. ... ODBC Driver. ...
    (microsoft.public.data.ado)
  • Re: Problem updating a record containing a negative Value
    ... If it is the same in ADO or ADO.NET then this is definitely a bug in ODBC ... driver from the vendor. ...
    (microsoft.public.data.ado)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... ODBC, whatever the back end. ... to a jet backend to open a ado recordset. ... customers want/need sql server and another wants to use MySql. ...
    (comp.databases.ms-access)
  • RE: :ODBC vs. DBD::ADO
    ... Subject: ODBC vs. DBD::ADO ... I've never found anything that ADO could do that ODBC couldn't. ... figure out its quirks but for Perl ODBC works perfectly. ... Marble Bar Asset Management LLP is regulated and authorised by the FSA. ...
    (perl.dbi.users)