Infopath cannot to a data source

[jgb23]

Hello,

I am new to infopath development and created a really basic form just to see
how it works. I am using a SQL Server 2008 database on the backend. I
created my data source and put the fields into the form. I ran the preview
option in infopath and got the following error:

The query cannot be run for the following DataObject: Main connection
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.

I changed the trust to full trust under form options and security and trust.
The data connection is set to windows authentication and as the
administrator, have total access to all.

Can somebody please help me with this...very very frustrating!

 

[Shiva (GGK Tech)]

Hello,

Are you connecting to local machine database or any other machine database
which is available in the network? Do you have permissions for your log in
user to access that database?
After adding the full trust of the form you have to add the signature (Sign
of this template) to that form.

 

[Ben Walters]

Hey jgb23,

A Couple of quick questions

1: do you have more than one connection in the form? select Tools>Data
Connections to see this
2: Has the connection been created correctly? again select Tools>Data
connections select your database connection and click the Modify button to
review the connection settings.

Failing that I'd be happy to have a quick look at your form offline from the
newsgroup if you are comfortable emailing it through

Cheers
Ben Walters

 

[Pradeep Yamujala]

Hi,

I too had the same problem. I over came the the problem like
this, select the small arrow on the preview button of the page and open
preview settings. There will be a new windows showing all the settings. In
that go to securty and uncheck the "Automatically determine the security
level" and select "Full trust". Now save every things and run the preview.

Using this i am able to connect to the data base and save teh
data too.