Will Forms 10 be able to handle other types of data sources beyond SQL and Oracle?
Hi there,
Forms 10 doesn't support ODBC connection. Workflow supports ODBC connection, so if user doesn't need dynamic lookup, they can use the Workflow service task to pass the lookup results back.
I just checked and it doesn't look like it.
In fact I'm not sure it even supports Oracle. Help files say:
Database Server
And the new data source dialogue box confirms:
Thanks for your reply, Ege! I found in the Help files for 9.2 (Forms 9.2 Help Files) that support for Oracle was added:
"Note: Forms 9.1 introduced support for using Oracle databases as data sources. In order to do so, Oracle Data Access Components 11.2 or higher must be installed on the Forms Server machine."
But I was curious it if would eventually support any ODBC connection? That would be great for some of our customers!
Hi there,
Forms 10 doesn't support ODBC connection. Workflow supports ODBC connection, so if user doesn't need dynamic lookup, they can use the Workflow service task to pass the lookup results back.
Thanks, Abby. Unfortunately, this customer does need an ODBC connection to perform a dynamic look up. We'll just continue with the workaround of exporting the data and importing into a SQL database for now. Thanks for the information.
Jen, you can also look into writing your own web service for this. It would be more work upfront, but would be a cleaner approach then exporting the data and importing it into a SQL database (which in a lot of cases has to be done regularly).
This is an option that we are looking into. I just wanted to save us the work if there were plans to add additional data sources.
Thanks, Ege!