Article View: comp.lang.pascal.delphi.databases
Article #13Re: DB connection - ODBC question!
From: PeteK
Date: Fri, 27 Sep 2002 15:29
Date: Fri, 27 Sep 2002 15:29
28 lines
2662 bytes
2662 bytes
ADO will give you access to a number of databases and other data sources via OLE DB, including SQL Server. It can also access any database that you have (or can beg, borrow or steal) drivers for. Pete K "Fabio" <f.valeri@angelfire.com> wrote in message news:770d546d.0207260148.413cb2d1@posting.google.com... > 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:
<an1tha$pmf$1@paris.btinternet.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.stueberl.de!newsr1.ipcore.viaginterkom.de!btnet-peer1!btnet-feed5!btnet!news.btopenworld.com!not-for-mailReferences:
<770d546d.0207260148.413cb2d1@posting.google.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ffff5,789ea0e90de35c48 X-Google-Attributes: gidffff5,public X-Google-Thread: 115d96,789ea0e90de35c48 X-Google-Attributes: gid115d96,public X-Google-ArrivalTime: 2002-09-27 08:30:02 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.stueberl.de!newsr1.ipcore.viaginterkom.de!btnet-peer1!btnet-feed5!btnet!news.btopenworld.com!not-for-mail From: "PeteK" <peter.kane88_RemoveThisBit_@btinternet.com> Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database Subject: Re: DB connection - ODBC question! Date: Fri, 27 Sep 2002 15:29:46 +0000 (UTC) Organization: BT Openworld Lines: 30 Message-ID: <an1tha$pmf$1@paris.btinternet.com> References: <770d546d.0207260148.413cb2d1@posting.google.com> NNTP-Posting-Host: host217-39-142-123.in-addr.btopenworld.com X-Trace: paris.btinternet.com 1033140586 26319 217.39.142.123 (27 Sep 2002 15:29:46 GMT) X-Complaints-To: news-complaints@lists.btinternet.com NNTP-Posting-Date: Fri, 27 Sep 2002 15:29:46 +0000 (UTC) X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MSMail-Priority: Normal X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000