SQL Database Integration

Re: how to submit data into .mdb?

Whitley — Mon, 10 Jul 2006 03:21:08 GMT

hi,

http://blogs.3sharp.com/Blog/davidg/archive/2005/05/05/637.aspx

for this link - third paragraph as shown below
The first step is to create data connections for your table(s). Also, note that the form will need to be fully trusted in order to write to the database. Next, add a reference to the System.Data.dll .NET component and include the using System.Data.OleDb directive in your form code file. After the reference and directive have been added, you can declare member variables for the database connection and each of the update commands that your code requires.

i not really understand for it.
because i can using the method which provided by infopath features.
but now i cannot save the info into .mdb through vb.net code since i already add a reference to the System.Data.dll .NET component into the form.
beside this, i have set the form to "FULL TRUST" in form option already.

hope someone kindly advice or send other example coding to me.
thanks.
:)

Re: how to submit data into .mdb?

K.Ramana Reddy — Fri, 07 Jul 2006 03:58:09 GMT

Hi,

Check out these links,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/ipsdkConnectingToDBInADOForm_HV01031080.asp

http://blogs.3sharp.com/Blog/davidg/archive/2005/05/05/637.aspx

I hope this will help you,

Thanks.

Re: how to submit data into .mdb?

Whitley — Fri, 07 Jul 2006 02:45:57 GMT

hi drgkreddy,

may i know whether you have any sample code / form to me?
thanks in advance.
:)

Re: how to submit data into .mdb?

Whitley — Fri, 07 Jul 2006 02:44:20 GMT

hi drgkreddy,

sorry, i tried it before but unsuccessful.
Now i am looking for how to write code(for example vb.net) to connect to .mdb
thanks.

Re: how to submit data into .mdb?

Kalyan Gaddam — Thu, 06 Jul 2006 17:58:40 GMT

Hello Whitley,

Welcome to Infopathdev Forums

Please read the link below to understand how to Connect/Submit data into Access database
http://office.microsoft.com/en-au/assistance/ha011199501033.aspx

I hope it will help you.

how to submit data into .mdb?

Whitley — Thu, 06 Jul 2006 16:08:25 GMT

hi,

To who may concern, can someone send some sample code/form for "how to submit data into .mdb / access database" to me? Because i am new in this...

thanks.