 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / December 2004Connecting a fully functional infopath form to a MS SQL DB
I am looking to connect a infopath form that has already been create to a MS SQL Database. I understand the process of creating a form based off a Database, however I am faced with the problem of creating a database based off a Form and making the two interact. Can you help me? If you have rich text fields, images, files, etc in your form, you will need to use a Web service as a go-between for the database. Otherwise you'll never these types of fields into the database.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com I am looking to connect a infopath form that has already been create to a MS SQL Database. I understand the process of creating a form based off a Database, however I am faced with the problem of creating a database based off a Form and making the two interact. Can you help me? Greg - There are areas within the form where images and files will need to be transported into the database. Right now i am just using test data that doesnt require any of the sort. Basically you are telling me though, that I have to connect into a web service first and then from the web service into the database. > If you have rich text fields, images, files, etc in your form, you will need to use a Web service as a go-between for the database. Otherwise you'll never these types of fields into the database. > > I am looking to connect a infopath form that has already been create to a MS > SQL Database. I understand the process of creating a form based off a > Database, however I am faced with the problem of creating a database based > off a Form and making the two interact. Can you help me? You will need a Web service that does the database work for you. Your form would no longer touch the database itself, just use the Web service. You cannot use rich text, image, and file fields directly with SQL or Access. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com Greg - There are areas within the form where images and files will need to be transported into the database. Right now i am just using test data that doesnt require any of the sort. Basically you are telling me though, that I have to connect into a web service first and then from the web service into the database. "Greg Collins [InfoPath MVP]" wrote: > If you have rich text fields, images, files, etc in your form, you will need to use a Web service as a go-between for the database. Otherwise you'll never these types of fields into the database. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.