[RadiusNT] CallsOnline and Radius 3.X

James B. Hrdy ( (no email) )
Thu, 23 Mar 2000 11:51:45 -0600

Running RadiusNT 3.0.163
I am getting an update error on or with callsonline.
Debug output will be at the bottom of the page.
My question is will this work with an access database ?
The SETUsername statement looks like it may make the ODBC driver choke.
Just wondering if SET username would work better. MSAccess sometimes
gets a little bummed about not using spaces.

TIA

SQL Statement:
UPDATE Servers AS s,
ServerPorts AS sp
SETUserName='jgray',AcctStatusType=1,FramedAddress='63.68.34.153',Call
Date='2000-03-23 12:37:5'
FROM Servers s,
ServerPorts sp
WHERE sp.ServerID = s.ServerID
AND s.IPAddress='208.247.48.22'
and sp.Port=11267 AND (DateAdd('s', 0-0, '2000-03-23 12:37:5') >=
sp.CallDate OR sp.CallDate IS NULL)

ODBC Error [37000]
-3503:[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in
UPDATE statement.
[UPDATE Servers AS s, ServerPorts AS sp
SETUserName='jgray',AcctStatusType=1,FramedAddress='63.68.34.153',Call
Date='2000-03-23 12:37:5'
FROM Servers s, ServerPorts sp
WHERE sp.ServerID = s.ServerID
AND s.IPAddress='208.247.48.22'
and sp.Port=11267
AND (DateAdd('s', 0-0, '2000-03-23 12:37:5') >= sp.CallDate
OR sp.CallDate IS NULL) ]
Sending Accounting Ack of id 40 to d0f73016 (max-tnt)

James B. Hrdy web: http://www.greensoft.com
email: jhrdy@greensoft.com
Voice: 913.317.8083 x206
"The hardest thing in the world to understand is the income tax."
Albert Einstein

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart