I have employee Table in SqlServer 2005 in my moss 2007 environment.
I 'm using an infopath 2007 form, to get the data from this employee table.
In disign form I have choosen --> Database and did all the necessary configurations.
when I click preview and enter the field in query area and click on run query I endup with an error
Infopath cannot connect to a data source.
and in show details i can see
The query cannot be run for the following dataobject: Get Data from DB
infopath cannot run the specified query
Infopath cannot connect to the data source
Access is denied
Access is denied.
Ram.