Date sent: Fri, 24 Mar 2000 09:22:44 -0800 (Pacific Standard Time)
From: Peter Deacon <peterd@iea-software.com>
To: radiusnt@iea-software.com
Subject: Re: [RadiusNT] CallsOnline and Radius 3.X
Send reply to: radiusnt@iea-software.com
> On Thu, 23 Mar 2000, James B. Hrdy wrote:
>
> > 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart