RE: Syntax error converting datetime from character string

[satish patel <linuxtrap@yahoo.co.in>]

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@cmi.net.au> wrote:

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

-
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