SharePoint Developer Center >
SharePoint Products and Technologies Forums
>
SharePoint - InfoPath Forms Services
>
How to set a Data SQL connection with InfoPath 2007 on SharePoint
How to set a Data SQL connection with InfoPath 2007 on SharePoint
Hi all,
we are currently trying to implement a InfoPath 2007 formula that reads some data from a custom SQL database.
I have tried to set a data connection and use the fields for the DropDownList.When I publish the formula as InfoPath document I’m able to use it on my SharePoint site but when I publish the same (unchanged) formula as web based, I receive just an error about the database connection.
Is there any way, to use a SQL Query in InfoPath to receive Data in a web based formula without programming?
Thanks
Carsten- Moved byMike Walsh MVPMVP, ModeratorFriday, November 06, 2009 3:05 PMand why post this InfoPath question to the ECM forum ? (From:SharePoint - Enterprise Content Management)
Answers
- With a browser-enabled form, you cannot connect directly to SQL. You must use a web service, and there are many security steps that you must go through in order to make the authentication and double-hop steps work. It definitely can be done. It doesn't require programming in the form, but you must create the web service with code.
SharePoint Architect || My Blog- Marked As Answer byLambert QinMSFT, ModeratorFriday, November 13, 2009 5:30 AM
All Replies
- With a browser-enabled form, you cannot connect directly to SQL. You must use a web service, and there are many security steps that you must go through in order to make the authentication and double-hop steps work. It definitely can be done. It doesn't require programming in the form, but you must create the web service with code.
SharePoint Architect || My Blog- Marked As Answer byLambert QinMSFT, ModeratorFriday, November 13, 2009 5:30 AM
