Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Webservice MS SQL authentication(Error 400 may caused by missing authentication)
Webservice MS SQL authentication [message #965803] Wed, 31 October 2012 14:13 Go to next message
mr. burns is currently offline mr. burns
Messages: 402
Registered: July 2009
Senior Member
Hi,

I use latest BIRT inside the Eclipse Juno on a Windows 7 professional.
I use Microsoft Dynamics Nav 2009 RTC, behind there is an MS SQL Server 2008.
I created a BIRT report using a webservice datasource.
I setup the URL of the webservice.
If I run the report within the designer I get following error:

The following items have errors:

Table (id = 33):
+ Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: Server returned HTTP response code: 400 for URL: http://mysrvsql:7051/nav2009/WS/myCompany/Page/Customer
(Element ID:33)


I believe it is an authentication problem.
The webservice runs well inside an IIS website using PHP, there I had to auhtenticate with username and password.

My question now in BIRT how can I authenticate a webservice datasource against the MS SQL server? How I can provice username and password?

Thanks a lot for any help!

[Updated on: Wed, 31 October 2012 14:17]

Report message to a moderator

Re: Webservice MS SQL authentication [message #972492 is a reply to message #965803] Mon, 05 November 2012 17:16 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1595
Registered: July 2009
Senior Member

You're probably going to have to use a custom class to do the authentication. Take a look at this article. It shows how to use a custom connection class, with Web Services.

BIRT-Exchange DevShare: BIRT Web Service ODA Article


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:Tooltips on Tomcat displaced or missing
Next Topic:Use existing Datasource/Dataset for running QueryDefinition
Goto Forum:
  


Current Time: Fri Sep 19 14:11:35 GMT 2014

Powered by FUDForum. Page generated in 0.10620 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software