Datasources and Sharepoint library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IT girl - 03 May 2006 09:05 GMT

Hello
I want to publish an Infopath form in a harepoint form library
In this form I need combo boxes getting their data from SQL server tables.
I create secondary Data sources but then INFOPATH asks me to create or use a
.ODC file
Where should I put this ODC in order to have all users opening these
infopath forms
able to get the SQL data?
Some of my users are out of the company even though they have infopath and I
cannot put them on their local drive or on a network drive. Can I store it
somewhere in a sharepoint document library? what is the proper way to do it?

Reply to this Message

Bob C. - 04 May 2006 19:53 GMT

1) Make sure you're on Infopath sp1 or sp2.

2) You say some users are "out of the company". Is the Sharepoint site
exposed to the web?

3) If all users (internal/external) are able to access Sharepoint, you can:
- Create a Sharepoint read only list that is linked to your SQL Server
via Excel
4) If WSS is not exposed to the internet:
- Create a webservice that delivers the data.

> Hello
> I want to publish an Infopath form in a harepoint form library
[quoted text clipped - 7 lines]
> cannot put them on their local drive or on a network drive. Can I store it
> somewhere in a sharepoint document library? what is the proper way to do it?

Reply to this Message