Solved

Infopath Sharepoint Certificate Publish...

Posted on 2010-11-16
10
437 Views
Last Modified: 2012-05-10
Hi!
First I would like to say that this is my first Infopath project so a bit new at this!

I have made a Form that collect some data from a database and write som new data to database....
Everything works well when I test the funktion on my "programming" computer.."
with my certifikation added to that one I can read and write from the server..



But I have trouble in wich way I should add the certifikation now when I publish the form..
should I add a domain ceritfication?

I have publish the form on the Sharepoint..
http://blogs.sharepointhosting.com/Lists/Posts/Post.aspx?ID=73
thats how I did it.

I can open the Form on the sharepoint view so I did something right I think!
But I can´t read or write from this view.. but the form opens correct..

I have no Idee what I have made wrong...  I think it´s the certifikat  I have made some wrong at..

It wolud only be in a internal sharepoint so I don´t have to have that mutch security!
Give me some tips or ask me so you can help me because I´m stuck on this!

//Kavvis
0
Comment
Question by:kavvis
  • 7
  • 3
10 Comments
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
The certificate, in InfoPath, if you sign the form only affects the ability to open the form, not the data conenctions.

Typically the issue is that the user does not have credentials or it is not passing through properly to the database.

If this is a browser based form you must create Universal Data Connections and may have some other hurdles.

Otherwise it should not matter if you have published the form to SharePoint or a network share.
0
 

Author Comment

by:kavvis
Comment Utility
Okey thank you for your tips.. ofcourse this gives me follow up questions..

"If this is a browser based form you must create Universal Data Connections and may have some other hurdles"

So If I understand correct..  If I colud open the form on sharepoint then the certificate is correct.
But When I can´t recive from the databse I have to change som settings in my database?

Can you explain the " If this is a browser based form you must create Universal Data Connections and may have some other hurdles" some more because I don´t really understand how I should change the settings!
0
 

Author Comment

by:kavvis
Comment Utility
I wolud like to edit my post but can´t find out how so I just ad some more text here...


Should I change  "Premissions" on my data base
   Database Properties --> Server properties

If this correct how should I change it?
0
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
So just to confirm. Is this a browser based form? Do the form users have the InfoPath client on their local computers?

That affects a lot.

Either way the users must have at least read access to the data you are connecting them to.

You did not specify what type of database it was either is this Access or SQL?
0
 

Author Comment

by:kavvis
Comment Utility
1.So just to confirm. Is this a browser based form? Do the form users have the InfoPath client on their local computers?

It´s like the form I linke to.. Not sure what you mena but theinfopath form only contains on the sharepoint..

2 . Either way the users must have at least read access to the data you are connecting them to.  
On the sharepoint do I have to give every user computer premissen to read write from the database or can I do some other ways? I´m not sure how I should give the acess?

3 It´s MSSQL 2008  sorry I forgotte this...


thanks for your replay..
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:kavvis
Comment Utility
still looking forward to get som input from someone.. I don´t think that is so far away to  have a solution for this!
0
 
LVL 28

Expert Comment

by:clayfox
Comment Utility
I guess my previous response did not save.

Sounds like it is a browser form.  So you have to convert your data connections to UDC, universal data connections, which are saved into a library in Sharepoint.

This is the first place to start.

In SQL you would go to the security folder to add users and give them permissions on your tables.
0
 

Accepted Solution

by:
kavvis earned 0 total points
Comment Utility
1. So you have to convert your data connections to UDC, universal data connections, which are saved into a library in Sharepoint.

I guess I should change this in Infopath..   When I edit my databse I have one checkbox I fan fill..
I have a nother language but will try to translate..
 Save a copy of data i formmall...  (something like this )

2. I think I know how to do shit in the DAtabase (SQL)  I think It´´s okey there already...

0
 

Author Comment

by:kavvis
Comment Utility
Today I have time to test so If you have anymore input I would be verry glad to here about!
0
 

Author Closing Comment

by:kavvis
Comment Utility
The problem was ok fixed!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now