Can I query from one DB and submit to another?

  • Thread starter FrazzledBeyondRecognition
  • Start date
F

FrazzledBeyondRecognition

I am trying to build an order form with Infopath. My main goal is to allow
users to query a database of items and stores and then submit that order to a
database of orders which will interact with BizTalk and drop directly into
our ERP. Everything I've read so far leads me to believe that retrieval and
submission of data can only occur within the same DB - any suggestions?
 
C

Clay Fox

Be frazzled no longer!

You need to use webservices to accomplish this.

With web services you can have multiple queries and submits within the same
form.

I would recommend you check out the Database Accelerator. It is a suite of
prepackaged, installable web services which can be used without code to get
AD information, query any SQL tables and both store your form in SQL and
extract any data from your form into SQL for either integration or reporting.
http://www.qdabra.com

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Submit using code to data connections 0
Submit to DB, Open New with current values 0
Submitting Form Data to Access Database 1
Blank fields become disabled after database query and submit to SP 0
The Form does not contain any new data to submit to the data source 2
How do I submit data of web-enabled form via webservice to sql 0
Convert Infopath form to submit through Data Connection to SQL DB 2
allow infopath to submit duplicate records 3

Top