SQL Database Integration

Re: Write code to programmatically open Access

Shyam — Tue, 29 Nov 2005 07:28:38 GMT

Hi Kip,

You would need to make your InfoPath form "Full Trust", to be able to use Access DB from code.(Full Trust is not required if you make the "Access DB" connection into a main data connection).

Have you tried this ? Let me know, i can send you some sample form/code, if you are still having issues.

thanks

Shyam
InfoPath Dev
India

Re: Write code to programmatically open Access

Patrick Halstead — Mon, 28 Nov 2005 22:47:34 GMT

Hi Kip,
Sorry for the long delay. I'll ask our Access experts to answer this post.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Write code to programmatically open Access

kipkaylor — Fri, 18 Nov 2005 14:45:40 GMT

I tried creating a new db on my local drive and a new InfopathProject in the same Visual studio folder. Got the same error. Can't understand why it fails when I try incorporating the Infopath template?

Re: Write code to programmatically open Access

franck — Thu, 17 Nov 2005 23:59:44 GMT

If your DB doesn't have the default security settings, it would. Access security has nothing to do with your permissions on the machine, right? Did you try to create that empty DB on your machine, just to make sure.

Regards,

Franck Dauché
InfoPathDev

Re: Write code to programmatically open Access

kipkaylor — Thu, 17 Nov 2005 22:20:24 GMT

I have admin rights on my machine. Don't understand where it would affect anything???

Re: Write code to programmatically open Access

franck — Thu, 17 Nov 2005 21:50:25 GMT

OK, did you try with a new fresh simple Access 2003 DB (no password).
It looks like the error message changed: Security.SecurityException.
I bet everything is now OK, but your connection string doesn't work because you need to add info to open the GA10605 DB. User may not be Admin, pwd may have been set, etc.

Regards,

Franck Dauché
InfoPathDev

Re: Write code to programmatically open Access

kipkaylor — Thu, 17 Nov 2005 15:15:11 GMT

I tried again with a fresh template and got the same error. It says system.security exception at the top of the error. Could this be a security setting in the options? I am running access 03 as well.

error:
System.Security.SecurityException
Request failed.
at InfoPathProject4.InfoPathProject4.btnOne_OnClick(DocActionEvent e)
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Re: Write code to programmatically open Access

kipkaylor — Thu, 17 Nov 2005 14:56:52 GMT

I thought I did that , but I'll try try again, Thanks for the instruction and confirmation!

Re: Write code to programmatically open Access

franck — Thu, 17 Nov 2005 14:49:21 GMT

Hi Kelly,

You open a new VB.Net project, you add a reference to System.Data. You drop 1 button and the form and write the code that you posted, with the connection string on 1 single line. You run and it works.
If you did that and are still experiencing issues, the only difference between your code and mine would be the database (an Access 2003 DB in my case).

Regards,

Franck Dauché
InfoPathDev

Re: Write code to programmatically open Access

kipkaylor — Thu, 17 Nov 2005 14:18:21 GMT

Let me ask you one question. Do I need to have a main connection thru the Infopath GUI Wizard before attempting to use this code?
Logically , I would say this code would make the connection. Is that correct?
I need to view, submit navagate , and add records . The only way I know how to do that is thru coding command btns in vb.net.
Maybe I'll try a fresh infopath project and see what I can come up with.

Could you send me a high level overview on how you got yours working. General steps. I can fill in the blanks, thanks!

Re: Write code to programmatically open Access

franck — Thu, 17 Nov 2005 07:12:00 GMT

nope, I don't think backslashes are required....I actually tested the code myself on a VB-based project, and it works fine. That's why I think that Kelly may have an issue with the db itself.

Franck

Re: Write code to programmatically open Access

Patrick Halstead — Thu, 17 Nov 2005 07:02:15 GMT

Are escaped backslashes required for database connection strings?

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Write code to programmatically open Access

franck — Thu, 17 Nov 2005 05:13:11 GMT

- You can open your mdb manually, right? It is not corrupted?
- You have your reference to System.Data?

Regards,

Franck Dauché
InfoPathDev

Re: Write code to programmatically open Access

Patrick Halstead — Thu, 17 Nov 2005 02:44:36 GMT

Did you escape the \ character? You probably need to have something like C:\\GA10605.mdb or something like that.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Write code to programmatically open Access

kipkaylor — Wed, 16 Nov 2005 15:11:25 GMT

Still doesn't work. Here's the error:

Request failed.
at InfoPathProject3.InfoPathProject3.Button1_OnClick(DocActionEvent e)
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)