Data Connections

Re: Retrieve data from sql DB

isupportyou — Mon, 23 Mar 2009 20:26:01 GMT

Thank you for the response. I've given it a try and I couldn't figure out how to get it to upload the UDC. I create a new UDC and say upload all changed, it switches the status to "new", and if I go to the data connections library nothing is there. I look through the user manual and it doesn't give any more steps...

Re: Retrieve data from sql DB

Mel Clemente — Mon, 23 Mar 2009 18:00:05 GMT

Hello and welcome to the forum!

You might wanna try our UDC Editor Tool. It lets you create a data connection file where you can specify your web service info. It also works in browser-enabled forms. Please let me know if you run into issues and I'll be glad to assist you further.

Cheers!

Retrieve data from sql DB

isupportyou — Mon, 23 Mar 2009 16:23:25 GMT

Our goal is to pull data from our DB into an infopath web form on MOSS

Here is the setup:

-Infopath 2007

-MOSS 2007

-SQL 2005

In SQL we created a web service to send/receive data from our DB. In infopath we created a data connection than converted it to a UDC and uploaded it to MOSS. Using this service we can write to the DB from a web form no problems. Pulling data from the DB works only if we don't use a web form (i.e. if I open the form in infopath it pulls the data fine.) If we attempt to pull data from the DB in a web form nothing shows up, the field is blank. No error messages, nothing, it's just blank. I've tried throttling the logs but still nothing.

In MOSS I created the data connection file manually and wrote the query directly into the data connection file like this article demostrates: Click here

This allowed the web form to pull the data just fine, but we want to use our web service.

I hope that all makes sense, any help would be appreciated.