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! Answers