<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006>I'm using freeradius
with freetds and unixodbc. I am having an issue using a procedure call to
insert to a Microsoft SQL Server. When I try to use the procedure call
'exec', I see the following errors:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006>radius_xlat:
'exec ***<BR>rlm_sql (sql): Reserving sql socket id: 8<BR>query: exec
***</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006>rlm_sql_unixodbc:
'00000 ' <BR>rlm_sql (sql): Couldn't update SQL accounting ALIVE record -
00000</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006>But if I don't use
a procedure call and use an insert command in its place, it works just
find. </DIV>
<DIV><BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006>radius_xlat:
'INSERT ****<BR>rlm_sql (sql): Reserving sql socket id: 3<BR>rlm_sql (sql):
Released sql socket id: 3<BR> modcall[accounting]: module "sql" returns ok
for request 6</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006>My question is why
can't I use a procedure call 'exec'?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006>Thanks!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=530223906-06062006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=530223906-06062006> </DIV>
<DIV><BR> </SPAN></FONT></DIV></BODY></HTML>