Hey,
Im new to sharepoint and I need to create a site for my user sto use but im not sure which template to use in its creation.
Two things that i need are the ability to have a Form Library and a DB library. Any suggestions would be much appreciated. I need the form library because my users will be using infopath templates to create documents.
Not completely sure what you’re asking Alex. All Data stored in SharePoint is in an SQL Database. Our forms have multiple data connections to various sources… most internal SharePoint lists or Get User Profiles. We don’t have any SQL databases other than the various that our SharePoint site is using.
InfoPath does allow you to connect to a variety of external data sources. For connecting to an external SQl data source, you’ll probably want to use Business Connectivity Services.
This link gives some good references for BCS
Hope this helps, Alex.