<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>I’ve found the load balancer is un sticky enough that I do need to use the ODBC plugin to avoid the user entering a redirect loop trying to sign in between /SAML/POST and /secure.<o:p></o:p></p><p class=MsoNormal>It appears that IE kindly opens two connection to the SP website; one of which lands on each server.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve got ODBC basically working with an existing SQL db; however on two occasions it’s got stuck.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQL: SELECT version,expires,CASE version WHEN 0 THEN null ELSE value END FROM texts WHERE context='NameID' AND id='_7e0806061a5c449da3674a8b4cd25f30' AND expires > {ts '2012-09-20 16:09:43'}<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLPrepare succeeded. SQL: INSERT INTO texts VALUES (?,?,{ts '2012-09-20 16:19:16'},1,?)<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLBindParam succeeded (context = NameID)<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLBindParam succeeded (key = _7e0806061a5c449da3674a8b4cd25f30)<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 DEBUG XMLTooling.StorageService [1]: SQLBindParam succeeded (value = <wddxPacket version="1.0" lowercase="no"><header/><data><struct><var name="4037adca1a9852ebcfde22621ca2e95563a3ea8e55868d68f193bcdffcc12cd8"><array length="1"><string>_e89706f8f40a49210a175fbc28bc7512</string></array></var></struct></data></wddxPacket>)<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 ERROR XMLTooling.StorageService [1]: insert record failed (t=texts, c=NameID, k=_7e0806061a5c449da3674a8b4cd25f30)<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 ERROR XMLTooling.StorageService [1]: ODBC Error: 23000:1:2627:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__texts__797849F78C9DE53D'. Cannot insert duplicate key in object 'dbo.texts'. The duplicate key value is (NameID, _7e0806061a5c449da3674a8b4cd25f30).<o:p></o:p></p><p class=MsoNormal>2012-09-20 16:09:43 ERROR XMLTooling.StorageService [1]: ODBC Error: 01000:2:3621:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>It continually reties to insert (and fails) the data then shibd exits on one or both servers.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Are there any known issues with the ODBC plugin and MS SQL using SQL Server Native Client 10.0?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Paul<o:p></o:p></p></div><p style="font-size: 6px; font-family: Verdana, Arial, sans-serif">_________________________________________________________________________________________________________________________________________</p>
<table width="550" border="0" cellspacing="0" cellpadding="0" style="margin-top:12px; margin-bottom:0px">
<tr><td width="127">
<a href="http://www.RMbookshelf.com/?utm_campaign=fy12-emailsignoff&utm_medium=email_signoff&utm_source=cross-sector&utm_content=rmbooks"><img src="http://www.rm.com/_rmvirtual/media/images/RM-Books-email_signoff.png" width="119" height="126" style="margin-right:8px" alt="RM Books" border=0/></a></td>
<td width="423" valign="middle"><p style="font-size: 12px; font-family: Verdana, Arial, sans-serif"><br />RM Books - the first ever ebook system designed specifically for schools. Pre-register for free at <a href="http://www.RMbookshelf.com/?utm_campaign=fy12-emailsignoff&utm_medium=email_signoff&utm_source=cross-sector&utm_content=rmbooks" style="color:#000000; text-decoration:underline;"><strong>www.RMbookshelf.com</strong></span></a></p></p></td></tr></table>
<p style="font-size: 6px; font-family: Verdana, Arial, sans-serif">_________________________________________________________________________________________________________________________________________</p>
<p style="font-size: 12px; font-family: Verdana, Arial, sans-serif; color:#006600; margin-bottom:15px;">P.S. Think Green - don't print this email unless you really need to.</p><table border="0" cellspacing="0" cellpadding="0" width="550">
<tr>
<td width="144" valign="top"><p><img width="127" height="107" src="http://www.rm.com/_RMVirtual/media/images/rm_education_email_signature_logo.gif" /></p></td>
<td width="457" valign="top"><p><font face="Verdana" size="2" color="#999999">This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information only for the intended purpose. Internet communications are not secure and therefore RM Education does not accept legal responsibility for the contents of this message. Any views or opinions presented are only those of the author and not those of RM Education. If this email has come to you in error please delete it and any attachments. Please note that RM Education may intercept incoming and outgoing email communications. <br />
<br />
RM Education plc is a company registered in England and Wales, Company Reg. No: 01148594; Registered Office: New Mill House, 183 Milton Park, Abingdon, OXON OX14 4SE; VAT No: 630 8236 56 </p></td>
</tr>
</table></body></html>