Syntax error converting datetime from character string

[satish patel]

Thank 4 your ans

Can u tell me mssql support unix date time ????

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 ????

Cory Robson <cory at cmi.net.au> wrote:        v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}       st1\:*{behavior:url(#default#ieooui) }           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.
   
      
---------------------------------
  
  From: freeradius-users-bounces+cory=cmi.net.au at lists.freeradius.org [mailto:freeradius-users-bounces+cory=cmi.net.au at lists.freeradius.org] On Behalf Of satish patel
 Sent: Tuesday, 13 March 2007 3:11 PM
 To: freeradius-users
 Subject: Syntax error converting datetime from character string
  
   
  Dear all 
 
              I have setup freeradius-1.1.0 with Cisco VPDN with MSSQL2000 but i got this error and my radius goes down 
 
 Tue Mar 13 10:57:44 2007 : Error: rlm_sql_unixodbc: '22007 [unixODBC][FreeTDS][SQL Server]Syntax error converting datetime from character string.'
 Tue Mar 13 10:57:44 2007 : Error: rlm_sql (sql): Couldn't insert SQL accounting STOP record - 00000
 
 what is this ???  is this any bug or radiusd or mssql200 
 
 can anybody explain me for this problem
 
 
 $ cat ~/satish/url.txt
 
 System administrator ( Data  Center )
 
 please visit this site
 
 http://linux.tulipit.com   
    
    
---------------------------------
  
  Here’s a new way to find what you're looking for - Yahoo! Answers 
  
  - 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


$ cat ~/satish/url.txt

System administrator ( Data Center )

please visit this site

http://linux.tulipit.com   
 				
---------------------------------
 Here’s a new way to find what you're looking for - Yahoo! Answers 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070313/f16d5eba/attachment.html>