Thread View: comp.lang.pascal.delphi.databases
2 messages
2 total messages
Started by Fabio
Fri, 26 Jul 2002 09:48
DB connection - ODBC question!
Author: Fabio
Date: Fri, 26 Jul 2002 09:48
Date: Fri, 26 Jul 2002 09:48
21 lines
1835 bytes
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!
Re: DB connection - ODBC question!
Author: 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!
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads