DB connection - ODBC question! - Article 12 - go-pugleaf

Article View: comp.lang.pascal.delphi.databases

Article #12

Back to comp.lang.pascal.delphi.databases Previous Next

DB connection - ODBC question!

#12

From: Fabio
Date: Fri, 26 Jul 2002 09:48

21 lines
1835 bytes

Hi folks,
I am writing an application to perform a search and replace on the
field values of a table; it is useful when a simple sql command would
not be able to perform it: for example, if all the department codes
'D%' have to be changed to 'DEP%', sql doesn't do that.

My idea is to make the software able to connect to all the databases
(maybe not all, but al least few!), so I thought to connect to
different dbs through an odbc object; I tried with ADO components,
they are ok for Access, dBase, but I am not able to connect to
Interbase (I don't know about other dbs, I haven't tried yet!). In
addiction I don't want to connect to the dbs using BDE, because you need
to have/buy it to use the program.

What I am looking for are suggestions on how to connect to different
dbs without relying on BDE or other Non-free tools.

Thanks in advance,
Fabio

PS: the search and replace utility is free!

Technical Details

Message-ID: <770d546d.0207260148.413cb2d1@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,789ea0e90de35c48,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,789ea0e90de35c48,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2002-07-26 02:48:06 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: f.valeri@angelfire.com (Fabio)
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database
Subject: DB connection - ODBC question!
Date: 26 Jul 2002 02:48:05 -0700
Organization: http://groups.google.com/
Lines: 21
Message-ID: <770d546d.0207260148.413cb2d1@posting.google.com>
NNTP-Posting-Host: 194.125.56.146
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1027676885 8535 127.0.0.1 (26 Jul 2002 09:48:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 26 Jul 2002 09:48:05 GMT