Hey,

I've made some progress on this error and wanted to share what I've found out.

I'm not sure why this is but the database connection info in the .xsn file
is different than the connection info in the .odc file that InfoPath creates.
My problem I believe is related to the Open Mode. In the .xsn file teh Open
Mode = ReadWrite and in the .odc file the Open Mode = Share Deny None.

This is the scenario I have so if anyone can give me advice on the security
or open mode settings I should be using that would be great.

1. I have database that is connected to my InfoPath form and is located in a
different folder than the InfoPath form. The users have Read and Read &
Execute permissions (file security settings) to both the database and
InfoPath form.

2. I went into the .xsn file and changed the open mode settings to Share
Deny None. Same settings as the .odc files.

My goal is to allow the users to use my InfoPath form to query the database
and have the appropriate data returned but to not allow them direct access to
the database. The purpose of the form is to get the data not to make any
changes to it.

Also - is it normal for the open mode settings to be different in the .xsn
and .odc files. I thought this was odd.

Thanks!