[RadiusNT] ServerPorts problem with Rowguid Column

Graeme Slogrove ( Graeme@na.co.za )
Thu, 14 Sep 2000 09:59:20 +0200

Hi there,

We are using replication on our tables and therefore the ROWGUID column.
This is giving Radius a problem -

-----

SQL Statement: UPDATE ServerPorts SET
AcctSessionId='7C001BEE',UserName='savp',AcctStatusType=1,ConnectInfo='34000
LAPM/V42BIS',CallerId='0113460069',FramedAddress='196.22.188.95',CallDate='2
0000912 7:18:20',CostPerMinute=NULL,rowguid=NULL,MaxSessionTime=NULL FROM
Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND
COALESCE(sp.IPAddress,s.IPAddress)='196.22.160.103' AND sp.Port=0 AND
('20000912 7:18:20' >= sp.CallDate OR sp.CallDate IS NULL)

ODBC Error [37000] 20062:[Microsoft][ODBC SQL Server Driver][SQL
Server]Update of columns with the rowguidcol property is not allowed.
[UPDATE ServerPorts SET
AcctSessionId='7C001BEE',UserName='savp',AcctStatusType=1,ConnectInfo='34000
LAPM/V42BIS',CallerId='0113460069',FramedAddress='196.22.188.95',CallDate='2
0000912 7:18:20',CostPerMinute=NULL,rowguid=NULL,MaxSessionTime=NULL FROM
Servers s, ServerPorts sp WHERE sp.ServerID = s.ServerID AND
COALESCE(sp.IPAddress,s.IPAddress)='196.22.160.103' AND sp.Port=0 AND
('20000912 7:18:20' >= sp.CallDate OR sp.CallDate IS NULL)]

-----

Radius is trying to set the rowguid to NULL, something that is not allowed.

Regards,
Graeme

---Graeme Slogrove, BSc (Eng) Elec (Wits)Chief Information Officer, NetActive InternetTel: 011-719-0333    Fax: 011-719-0444Support: 011-719-0300

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