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@lists.freeradius.org [mailto:freeradius-users-bounces+cory=cmi.net.au@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! <http://us.rd.yahoo.com/mail/in/yanswers/*http:/in.answers.yahoo.com/> Answers