Getting Access Denied error while preview infopath form

[Nipendra Garg]

Hello Everyone,

This is the first time I am using Infopath and I got stuck with "Access Denied" error. I created a data connection (to receive data from SQL Server) and then I simply took one drop down

and bind the dropdown value from external data source column value. When I click on the preview button, I am getting three button :

1. Work Offline 2. Try to Connect (When I clicked ion this button, I got one popup saying that, Infopath connected to data source but failed to receive data)

3. Show Details -> when I clicked on this button it shows :

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


Can anyone please help me as I dont know why I am getting this Access Denied error. Any help would be appreciated......Thanks

[Nipendra Garg]

is anyone there to help me on this regard.............

[opaper]

You may check security level of the form in info path. May be this is the reason for error access is denied in infopath. You can also check from following method : Design a new blank form template in infopath and save the template as a test123.xsn to a network share that you should write access to. Then go to the file menu and click on that form then fill out that form task pane and select test. click save on the file menu as a c:\test123form.xml and close infopath. Then start a notepad and then write a script on that :

objIP = new ActiveXObject("InfoPath.ExternalApplication")
objIP.Open ("C:\\test123form.xml")

and save the file name Test123.js. Then double click on that java script file. May be this will help you.

[Nipendra Garg]

Yar, I din't get the sol. Can you please explain in easy way..........
That will be really helpful............
Thanks in advance....

[MindSpace]

Are you able to connect to the server? When you create the data connection, are you using Windows Authentication? Or SQL? If you are using SQL, are you saving the connection string? You are this error possibly because your template.xml file does not match your form schema. Look at your template.xml file and compare it with your schema and checout if you are missing anything in it.