ADO Security Warning

[MS]

Hi Folks,

I created an infopath form using schema generated by Biztalk. I defined the
min occours to 0 for some fileds of type string and some of type integer.

Then I converted the textbox to dropdown list box in Infopath. I bound this
drop down to a datasource to get values form SQL Database.

I then Published my form on Sharepoint form Library.

When I go to fill out my form from sharepoint I get ADO Security Warning
displaying:

Website uses a data provider that may be unsafe, If you trust this site
click OK
when I click Ok I get:

Website is using your Identity to access data source, If you trust this site
click OK.

When I click OK I can see my form with all the required data.

What do I need to do so I don't get this warning?

The other thing I noticed that fields of type string for which I set min
occour to 0. Is not a required field. How can I make this field mandatory.

When I go to properties of this fields in Infopath Cannot be blak option is
greyed out.

Can any one please suggest what I missed and how to do it?

Thanks In Advance

MS

 

[sosan]

You have to change the IE security options on the client.
You have to set the allow access to data source al domain level and a
your site in the trusted site list

*Hi Folks,

I created an infopath form using schema generated by Biztalk.
defined the
min occours to 0 for some fileds of type string and some of typ
integer.

Then I converted the textbox to dropdown list box in Infopath.
bound this
drop down to a datasource to get values form SQL Database.

I then Published my form on Sharepoint form Library.

When I go to fill out my form from sharepoint I get ADO Securit
Warning
displaying:

Website uses a data provider that may be unsafe, If you trust thi
site
click OK
when I click Ok I get:

Website is using your Identity to access data source, If you trus
this site
click OK.

When I click OK I can see my form with all the required data.

What do I need to do so I don't get this warning?

The other thing I noticed that fields of type string for which I se
min
occour to 0. Is not a required field. How can I make this fiel
mandatory.

When I go to properties of this fields in Infopath Cannot be bla
option is
greyed out.

Can any one please suggest what I missed and how to do it?

Thanks In Advance

MS

-
sosa