RE: 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 - 0
 
 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 - 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Syntax error converting datetime from character string

[satish patel]

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

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

RE: Syntax error converting datetime from character string

[Cory Robson]

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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 - 0

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 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html