Thanks
At 04:01 PM 3/24/00, you wrote:
>Is it simply a MSAccess should not be used for radiusnt 3.0 or do you think
>there might be a fix for it.??
>
>
>
>
>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
Tom Long
Communications Supervisor 1025 Roosevelt Avenue
City of Detroit Lakes Detroit Lakes, MN 56501
tlong@lakesnet.net Telephone: 218-846-7142
www.detroitlakes.org Fax: 708-810-3445
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart