Re: TZF - Connecting to an Oracle Database

Thanks for the help ... the problem has
now changed a little.  I am to access the
database with a browser.  I have incorporated
TWebBrowser in the application and am now
able to actually browse the internet.

This particular problem however is one in
which the query will return a very simple
page - such as

LastName:  Watson
FirstName:  Robert
Address:  123 Apple Lane
City: Atlanta

   etc etc

I have to take this text, parse it and put it
in my database.  My problem now is how
to access the text in the browser window
automatically.  If it were a TRichEdit, I could
use    myRichEdit.Lines      ... however, I have
not been able to figure out how to make reference
to this text as of yet.

Any ideas??

Thanks,
Bob Watson




----- Original Message ----- 
From: "B. Evers" <[email protected]>
To: <[email protected]>
Sent: Monday, February 23, 2004 5:10 AM
Subject: Re: TZF - Connecting to an Oracle Database


> Bob,
>
> ----- Original Message ----- 
> From: "Bob Watson" <[email protected]>
> To: <[email protected]>
> Sent: Saturday, February 21, 2004 5:22 AM
> Subject: TZF - Connecting to an Oracle Database
>
>
> >
> > I have a client at a major university who,
> > of course, keeps much of their corporate
> > data on an Oracle database.  The application
> > I am developing needs just a small amount
> > of data from this Oracle database and then
> > this data and much more will be stored in
> > DBF files.
> >
> > I use Delphi 7 Professional ... is there some
> > way I can connect to an Oracle database using
> > ODBC drivers?  Also, is there a way to query
> > the database through some sort of "web object" ...
> > I am totally ignorant on this matter, so any help
> > whatsoever would be greatly appreciated.
>
> I know there are native client libraries for connecting Delphi to Oracle.
>
> http://www.allroundautomations.com/doa.html  Native components
> http://otn.oracle.com/tech/windows/odbc/index.html ODBC
>
> I never used Oracle, but on our Dutch Delphi site there are a lot of
threads
> about using the BDE to connect to Oracle, so you could check that out.
Also
> you could try using DBexpress that is supplied with D7 pro (but I am not
> sure it has an Oracle adapter).
>
> As for the web object, what do you mean by that? If you mean the oracle
> database has a web interface, you could try using Indy (supplied with d7
> pro, but upgrade them first) to rip the data from these pages (I know some
> people are doing it here).
>
> You could also try building some SQL script (or stored procedure) in
oracle,
> that exports the data you need to CSV, or XML or ..................
>
> If you need to query data from Oracle often, you could also try building
an
> interface using a 3-tier framework. I am using kbmMW for this at the
moment.
> It is very powerfull, and has ways to make your app independent of the
> database in the database layer. It has its own SQL dialect between the
> layers, and only in the database layer it is translated to dedicated SQL.
> You can find info on kbmMW on www.components4developers.com  (kbmMW
> http://www.components4programmers.com/products/kbmmw/index.htm ) It is a
> small investment, but the product is great (could use some more docs, they
> are working on that), and support is great. They have a newsgroup with the
> original developer and some cracks on the product, you'll get an answer in
a
> couple of hours normally (day and night, some guys never seem to sleep
:) ).
>
> Good luck with your project.
>
> Benno Evers
>
>
>

--^----------------------------------------------------------------
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
--^----------------------------------------------------------------