Browse by Tags

Connecting to SQL Database - Data Source will not connect

Hi, I have a form that connects to a backend SQL database via a ODC connection configured on a windows 2003 server. The connection works when the form is opened on the server. However, when connecting to the form via a VPN connection on a client machine that is not a member of the domain, the connection...

Posted to Database Integration (Forum) by bladah29 on 11-10-2008
Receive data from SQL to browser enabled form

Hi I created one browser enabled IPF, it contains 5 textfields (Name,Class,Subject,ID,Date). I created one database in my sql server. How can i receive sql data from my IPF using webservice. If anyone knows the solution give me some examples.

Posted to Database Integration (Forum) by jeeva on 11-03-2008
Filter Data Received from SQL Data Connection

I have been working with InfoPath for a while now, but have yet to run into this situation. I have a user directory form that will connect to an SQL database and return the results of a table which contains user names. I want to return that list of user names to my form, however I need to incorporate...

Posted to Data Connections (Forum) by WSU54 on 09-11-2008
SQL Server 2000 Trigger doesn't work

I am appending records to an SQL Server 2000 database using InfoPath 2007. I made a trigger on the table the form is based on but when I append a new record the trigger never fires. The trigger works fine if I append a new record using Query Analyzer. I first assumed it just would not work due to some...

Posted to Database Integration (Forum) by cduwel on 08-14-2008
Can not submit data from InfoPath form to SQL Database

Hello I was wondering if someone could possibly help me. I am currently running sharepoint2007 server along with ms sql2005. I have created a form that goes out and queries data fine however I am trying to make a page where I submit data to my sql database. I have been doing research on this and have...

Posted to Data Connections (Forum) by mock24 on 07-24-2008
Retruning all rather than matching query

Hello, I am new to InfoPath (using the 2003 version) and I have been trying to create master/detail pages from an existing SQL server DB. In trying to learn how to do this I have been using the wonderful example posted by Matt Faus posted at location http://www.infopathdev.com/blogs/matt/archive/2006...

Posted to Database Integration (Forum) by bmcclue on 07-03-2008
Three Tables

Hi, I am new Infopath 2007 fan, but I found a problem that is hard to solve for me. I have a SQL 2005 database with three tables: Student, Contact and StudentContact. StudentContact is the one that is used for the relationship between student and contact. One student can have many contacts. I want to...

Posted to Data Connections (Forum) by PreemPalver on 03-31-2008
Re: InfoPath form created from a SQL Database Datasource

The error appears when I add a new field to the SQL table and redo my data source to pick it up. I start getting errors on form before I even attempt to add the new field to the form.

Posted to Data Connections (Forum) by m181354 on 03-18-2008
Re: InfoPath form created from a SQL Database Datasource

I am getting red dashed errors on fields that worked fine before I added a new column on the SQL table and re-did my Data Source. The new field shows up fine under my Data Source but I get red dash errors on the form in different places. Is it true that it is difficult to add new fields or make updates...

Posted to Data Connections (Forum) by m181354 on 03-12-2008
InfoPath form created from a SQL Database Datasource

I have an InfoPath form created from a SQL Database Data source. I need to make some updates/changes to the SQL tables but when I do I get an error on the form. I re-do my data connection but I still get an error. I know I could use a Web Service or your Database Accelerator but I wanted to know if there...

Posted to Data Connections (Forum) by m181354 on 03-10-2008

Page 1 of 2 (11 items) 1 2 Next >