SQL Database Integration

Re: SQL- Submit data in more than one table

msatish84 — Wed, 18 Apr 2007 06:02:46 GMT

I am using infopath 2007, using that i connected to msaccess through(tools---dataconnections----add---create a new connection ---receive data---ms sql server--select database---- connect to new data source ---odbcdsn----msaccess database---(from there i select the table name which i created ) and double click on it and i find the table name and finally finish ) i got the error connec tonly to sqlserver. so please help me out

Re: SQL- Submit data in more than one table

msatish84 — Tue, 17 Apr 2007 06:28:26 GMT

EMPLOYEE NO: text box

EMPLOYEENAME: text box

CD NAME: text box

ISSUE DATE: datapicker

ISSUED BY:

submit reset

I designed this kind of form in infopath 2007 after entering the data in text box field i have create connection to access ..my question is .. when i enter the data in fields and click submit the data should store in access so please help to store data using rules or code ....please help me

Re: SQL- Submit data in more than one table

msatish84 — Mon, 16 Apr 2007 10:08:34 GMT

connection to db through sql ...

Re: SQL- Submit data in more than one table

msatish84 — Mon, 16 Apr 2007 09:55:12 GMT

Thank u for your reply. my question is,, i have designed a form in infopath and that form is connected to sql database .i have entered value in the text box field when i click sumbit the values has to enter to database and also to reterive that value from database .so please give the code for tthat i have installed .net in my system.

conncetion to db through sqlserver

Re: SQL- Submit data in more than one table

Navid — Sat, 14 Apr 2007 19:21:57 GMT

Hi msatish !
Would u tell more about your connections ?
How does your form connect to db ?
do u use any web service or u gonna to connect directly to your db ?

Re: SQL- Submit data in more than one table

msatish84 — Sat, 14 Apr 2007 09:41:08 GMT

I have created a form in infopath Now I have to Enter the value in the form so that it should store in access database....please tell the procedure because just now i started to use infopath.

Re: SQL- Submit data in more than one table

Kalyan Gaddam — Mon, 05 Mar 2007 05:31:31 GMT

Hello Navid,

Please read the link below
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=3285

Hope it helps you

SQL- Submit data in more than one table

Navid — Sun, 04 Mar 2007 16:36:30 GMT

Hi. I have a problem when I want to Submit my data fields through a Web service in 2 ( or more ) Tables.
I don't have any problem with one table.
but when I want to sumbit my data fields in 2 tables,InfoPath gives the below error :
Dynamic SQL generation is not supported against multiple base tables.

(I'm using InfoPath 2003 and SQL server 2005 and a WebService that is coded with VS2005)