Thank 4 your ans<br><br>Can u tell me mssql support unix date time ????<br><br>but one morething i got this problem sometime not every time i got this problem after 2 and 3 days and my radiusd goes down so is there problem regarding unix datetime ????<br><br><b><i>Cory Robson <cory@cmi.net.au></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceName"> <o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"> <!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:blue; text-decoration:underline;} p {mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; font-size:12.0pt; font-family:"Times New Roman";} span.EmailStyle18 {mso-style-type:personal-reply; color:black;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt;} div.Section1 {page:Section1;} --> </style> </o:SmartTagType></o:SmartTagType></o:SmartTagType><div class="Section1"> <div
class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt; color: black;">You will need to configure your sql server to store dates in unix format, not having worked with mssql2000 for a while I couldn’t tell you how to do it but I’m betting that’s where your problem is.<o:p></o:p></span></font></div> <div class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span style="font-size: 12pt; color: black;"><o:p> </o:p></span></font></div> <div> <div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> <hr tabindex="-1" align="center" size="2" width="100%"> </span></font></div> <div class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org [mailto:freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org] <b><span style="font-weight: bold;">On Behalf Of </span></b>satish patel<br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, 13 March 2007 3:11 PM<br> <b><span style="font-weight: bold;">To:</span></b> freeradius-users<br> <b><span style="font-weight: bold;">Subject:</span></b> Syntax error converting datetime from character string</span></font><o:p></o:p></div> </div> <div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Dear all <br> <br> I have setup freeradius-1.1.0 with Cisco VPDN with MSSQL2000 but i got this error and my radius goes down <br> <br> Tue Mar 13 10:57:44 2007 : Error:
rlm_sql_unixodbc: '22007 [unixODBC][FreeTDS][SQL Server]Syntax error converting datetime from character string.'<br> Tue Mar 13 10:57:44 2007 : Error: rlm_sql (sql): Couldn't insert SQL accounting STOP record - 00000<br> <br> what is this ??? is this any bug or radiusd or mssql200 <br> <br> can anybody explain me for this problem<br> <br> <br> $ cat ~/satish/url.txt<br> <br> System administrator ( <st1:place w:st="on"><st1:PlaceName w:st="on">Data</st1:PlaceName> <st1:PlaceType w:st="on">Center</st1:PlaceType></st1:place> )<br> <br> please visit this site<br> <br> http://linux.tulipit.com <o:p></o:p></span></font></div> <div><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> <o:p></o:p></span></font></div> <div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> <hr align="center" size="1" width="100%"> </span></font></div> <div
class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Here’s a new way to find what you're looking for - <a href="http://us.rd.yahoo.com/mail/in/yanswers/*http:/in.answers.yahoo.com/">Yahoo! Answers</a> <o:p></o:p></span></font></div> </div> - <br>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html</blockquote><br><BR><BR>$ cat ~/satish/url.txt<br><br>System administrator ( Data Center )<br><br>please visit this site<br><br>http://linux.tulipit.com <p>
<hr size=1></hr>
Here’s a new way to find what you're looking for - <a href="http://us.rd.yahoo.com/mail/in/yanswers/*http://in.answers.yahoo.com/">Yahoo! Answers</a>