> 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.
This is a bug :( I'd chat w/ support about getting a patch for this one.
> 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)
Have Fun!
Peter
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart