Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Calling WCF windows service from InfoPath form deployed on MOSS 20

4 views
Skip to first unread message

Raul Khanna

unread,
Dec 11, 2009, 1:02:01 AM12/11/09
to
Hello,

I had developed an browser-enabled form in InfoPath 2007.
There is a dropdown control on the form which consumes WCF windows
service(deployed on my local machine) in order to populate records.
This WCF Service uses SQL server running on some another
machine to fetch records
Now, when I click on preview button on Infopath designer Screen,
everything
works fine.That is, my dropdown gets populated.
Again, when I published this form to a SharePoint site as
Administrator-
Approved form template and try to open it on
my local machine in InfoPath client, it's works absolutely fine.
But, when I try to open it in a browser, it throws an error :--

" An error occurred accessing a data source.
An entry has been added to the Windows event log of the server.
Log ID:6932"

In Event log, it states that "Login failed for user
'UK\SharePointDevAdm'.
Reason: Failed to open the explicitly specified database. [CLIENT:
<local
machine>]"

The authentication mode for my SP site is NTLM and the bindings used
in my
WCF windows service is

<!-- Service Endpoints -->
<endpoint address="" binding="basicHttpBinding"
contract="OSC.Service.Business.IEmployeeSearchService" />
<endpoint address="mex" binding="mexHttpBinding"
contract="IMetadataExchange" />


<client>
<endpoint
address="net.tcp://10.160.31.176:9000/EmployeeService/service"
binding="netTcpBinding" bindingConfiguration="NetTcpBinding_IEmployeeService"
contract="IEmployeeService" name="NetTcpBinding_IEmployeeService" />
<endpoint
address="http://ldv-com-158:8084/LoggingService/LoggingService.svc"
binding="basicHttpBinding" contract="ILoggingService" name="HttpEndpoint" />
</client>

where 10.160.31.176 is my local macine IP on which WCF windows service is
installed.

So, Please help me to resolve this issue.


spconsultant

unread,
Dec 14, 2009, 10:41:56 AM12/14/09
to
The process for getting records from an SQL server database using
INFOPATH
is very different when using the Infopath clinet to connect to your
external source
vs. using Forms services. You will need to set up a dataconnection
library and use
the dataconnection to get to the data (or web service). Also the set
up in you code
is also different, as you will ned a different data source definition.

On Dec 11, 1:02 am, Raul Khanna <RaulKha...@discussions.microsoft.com>
wrote:

0 new messages