| Re: IDL interface to Oracle [message #15632] |
Thu, 03 June 1999 00:00 |
Dick Jackson
Messages: 347
Registered: August 1998
|
Senior Member |
|
|
David Fanning wrote:
>
> Mark Rehbein (mrehbein@aims.gov.au) writes:
>
>> has anyone been able to use IDL to query an oracle database? Is it
>> possible?
>
> Dick has been working on a very interesting application for one
> of our clients that involves accessing an Oracle database. We
> use the IDL DataMiner and have been pleased with the results.
> For the same project we have accessed Microsoft Access databases
> as well, with similar good results.
>
> The bottom line for us is that we have been successful without
> being much in the way of database experts. :-)
I guess David won't be printing new business cards for me with "DB Expert"
on them yet. :-)
But he's right, it's been pretty painless. You have to get an IDL DataMiner
license, then if you're using Windows NT, just use the ODBC Control Panel to
set up an ODBC System Dataset (on other platforms it should be easy enough
as well). Then you should be able to walk through the examples in the Online
Help DataMiner Guide -- Using the IDL DataMiner section to get an idea of
how it works.
You can send any SQL query to Oracle, and it returns a RecordSet object from
which you get records and fields. One point that may not be clear from the
documentation: if the query failed due to an SQL or other DB error, you get
a null object -- watch for error messages.
Cheers,
--
-Dick
Dick Jackson Fanning Software Consulting, Canadian Office
djackson@dfanning.com Calgary, Alberta Voice/Fax: (403) 242-7398
Coyote's Guide to IDL Programming: http://www.dfanning.com/
|
|
|
|
| Re: IDL interface to Oracle [message #15634 is a reply to message #15632] |
Thu, 03 June 1999 00:00  |
davidf
Messages: 2866
Registered: September 1996
|
Senior Member |
|
|
Mark Rehbein (mrehbein@aims.gov.au) writes:
> has anyone been able to use IDL to query an oracle database? Is it
> possible?
Dick has been working on a very interesting application for one
of our clients that involves accessing an Oracle database. We
use the IDL DataMiner and have been pleased with the results.
For the same project we have accessed Microsoft Access databases
as well, with similar good results.
The bottom line for us is that we have been successful without
being much in the way of database experts. :-)
Cheers,
David
--
David Fanning, Ph.D.
Fanning Software Consulting
Phone: 970-221-0438 E-Mail: davidf@dfanning.com
Coyote's Guide to IDL Programming: http://www.dfanning.com/
Toll-Free IDL Book Orders: 1-888-461-0155
|
|
|
|
| Re: IDL interface to Oracle [message #15642 is a reply to message #15632] |
Thu, 03 June 1999 00:00 |
davidf
Messages: 2866
Registered: September 1996
|
Senior Member |
|
|
Mark Rehbein (mrehbein@aims.gov.au) writes:
> has anyone been able to use IDL to query an oracle database? Is it
> possible?
Dick has been working on a very interesting application for one
of our clients that involves accessing an Oracle database. We
use the IDL DataMiner and have been pleased with the results.
For the same project we have accessed Microsoft Access databases
as well, with similar good results.
The bottom line for us is that we have been successful without
being much in the way of database experts. :-)
Cheers,
David
--
David Fanning, Ph.D.
Fanning Software Consulting
Phone: 970-221-0438 E-Mail: davidf@dfanning.com
Coyote's Guide to IDL Programming: http://www.dfanning.com/
Toll-Free IDL Book Orders: 1-888-461-0155
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
