Receive Data from Oracle DB?

[M Enfroy]

Is there any way to create a data connection so I can query an Oracle
database within a form? I'd like to input a known value when filling out the
form, and use that as a key field to grab a few fields from a particular row
in an Oracle table view. I know the documentation says that only access and
SQL Server are supported but wanted to see if anyone knows of a way to do
this.

Thanks.

 

[Perry Faulkner]

Hi M,

Use an xml file data source and specify the url of your
server that will return the xml data. This could be a
static file, or something that serves up the xml data
from a database, as the response.

You can add the lookup key as the query message to the
url request. Within script, you can modify the url, i.e.
tack on any new query parameters, before issuing the
request.

During development of the form, you will need a
functioning connection as IP will need to poll the url to
get the xml data layout when your designing it.

I use the above to dynamically populate drop-downs, do
searches, field validation and take care of the submit.

Perry