SQL Database Integration

Re: InfoPath 2007, Use the GetUserProfileByName SharePoint WebService username to feed another data connection SQL Server Query

EmmaRoberts — Sun, 18 Mar 2012 04:39:51 GMT

can you show some code? I've done this and got similar issues, you have to specify the credentials the web service is going to use.

Re: InfoPath 2007, Use the GetUserProfileByName SharePoint WebService username to feed another data connection SQL Server Query

Hilary Stoupa — Mon, 05 Dec 2011 18:14:04 GMT

Hi -

Sorry to say - but this is not easy.

You will either need to write custom code for this (the general idea is outlined here) and modify your SQL connection in code, use an add-on like qRules which has a command you can use to add a dynamic where clause, or use web services (build your own, or buy one - we have a great web service suite here.)

InfoPath 2007, Use the GetUserProfileByName SharePoint WebService username to feed another data connection SQL Server Query

Randall Hodges — Sat, 03 Dec 2011 04:34:40 GMT

This seems like such a simple thing, but I guess it isn't since I've spent days tracking down "close, but no cigar" scenarios to what I need.

Need:

a) Use a Web Based InfoPath 2007 Form to enable a user to select only 'their' own records from my database for review when form is load, (cannot load all 70,000 records, takes too long).

Have:

a) I have a working Form which is posting the Main Form data to a SharePoint Library on Submit

b) Working Data Connection SharePoint Web Service to grab the username from the GetUserProfileByName

c) Working Data Connection to SQL Server which has a good query (with hard coded WHERE filter to limit results during development)

How can I pass the UserName from the Web Service automatically at form open to my Data Connection SQL Server while keeping this a Web Usable Form? (And remove hard coded value)

Any help would be appreciated.

Randy