Struggling to get a SQL DataConnector working

Craig Betts Craig.Betts at nottingham.ac.uk
Mon Jun 6 04:07:43 EDT 2016


Hi Rod,

Thanks for the response, I've tried your suggestion. Unfortunately no change. I'm still seeing the same error. 

Thanks
Craig

-----Original Message-----
From: users [mailto:users-bounces at shibboleth.net] On Behalf Of Rod Widdowson
Sent: Thursday, June 2, 2016 1:57 PM
To: 'Shib Users' <users at shibboleth.net>
Subject: RE: Struggling to get a SQL DataConnector working

>             <![CDATA[
>                 SELECT *
> 				FROM dbo.Staging
> 				WHERE username =
> '${requestContext.principalName}'
>             ]]>

I'm pretty sure you don't want the braces.  Also this is V2 legacy syntax, you might be better with 

SELECT * FROM dbo.Staging WHERE username='$resolutionContext.principal'

Rod

--
To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net




This message and any attachment are intended solely for the addressee
and may contain confidential information. If you have received this
message in error, please send it back to me, and immediately delete it. 

Please do not use, copy or disclose the information contained in this
message or in any attachment.  Any views or opinions expressed by the
author of this email do not necessarily reflect the views of the
University of Nottingham.

This message has been checked for viruses but the contents of an
attachment may still contain software viruses which could damage your
computer system, you are advised to perform your own checks. Email
communications with the University of Nottingham may be monitored as
permitted by UK legislation.



More information about the users mailing list