Datasources and Sharepoint library

[IT girl]

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?

 

[Bob C.]

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.