?
Solved

Infopath Sharepoint Certificate Publish...

Posted on 2010-11-16
10
Medium Priority
?
444 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
10 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 34146666
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
ID: 34154251
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
ID: 34154283
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 28

Expert Comment

by:clayfox
ID: 34154479
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
ID: 34154524
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
 

Author Comment

by:kavvis
ID: 34164297
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
ID: 34164360
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
ID: 34164453
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
ID: 34186049
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
ID: 34281261
The problem was ok fixed!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

765 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