I'm designing an Infopath form for my office. It uses an OBDC data connection to retrieve data from a SQL Database (MS SQL Express 2008). The problem is that I do not have Sharepoint Enterprise, therefore I'm using Sharepoint Foundations 2010. I can connect to the database fine when I load the form as I had set-up the OBDC connection in Infopath designer; however, my colleagues do not have the designer installed. When they load the published form, it tells them it cannot locate/connection to the data sources. How do I set-up each user to have similar access to the database when opening the published form? I wish I could create a data connection library but I do not have this ability at this time.
Thanks!