[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 448
  • Last Modified:

Infopath Sharepoint Certificate Publish...

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
kavvis
Asked:
kavvis
  • 7
  • 3
1 Solution
 
clayfoxCommented:
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
 
kavvisAuthor Commented:
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
 
kavvisAuthor Commented:
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
Independent Software Vendors: 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!

 
clayfoxCommented:
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
 
kavvisAuthor Commented:
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
 
kavvisAuthor Commented:
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
 
clayfoxCommented:
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
 
kavvisAuthor Commented:
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
 
kavvisAuthor Commented:
Today I have time to test so If you have anymore input I would be verry glad to here about!
0
 
kavvisAuthor Commented:
The problem was ok fixed!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now