InfoPath Dev

hiiiiii

I am working on InfoPath Project, and i want connected it with sql server 2008 by wizard connection on InfoPath form, I choosed DB connection and table.

when I click on review button and click on retrive Run query not return any data, also in submit command.

and dislpay this

' InfoPath cannot connect to the data source.

Access is denied

Access is denied '

Please I search of solution.

Hello,

The error may mean you don't have the necessary permissions to the SQL database. To accomplish connection, you must have the permissions to query and submit to your database.

Hope that helps!

Thanks Miss. Mel.

I will trying that.

Best Regards

Miss. Mel you can give me method that permissions to the SQL database?

Regards,

Hi Anas,

There are a lot of documentation available on the web. Here's a good article that talks about managing SQL server permissions.

Hope that helps!

Thanks Miss. Mel Balsamo