Solved

Infopath Sharepoint Certificate Publish...

Posted on 2010-11-16
10
443 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Viewers will learn the different options available in the Backstage view in Excel 2013.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 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