Accounting:Calls Table

Accounting ( (no email) )
Sat, 27 Dec 1997 01:35:57 -0600

Ok I am recv Acc packets, however there is one problem. When RadiusNT
tries to insert data into the Calls Table it wont put the NASIdentifier in
to the table and as this is part of the Primary Key and a part (i assume)
of the CallsOnLine Query. Here is the SQL from RadiusNT as you can see
there is no NASIdentifier or even an IPAddress to fill in to the
NASIdentifier field thus the error.

SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASPort,AcctStatusType,Acct
DelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,FramedAddress) VALUES
(Now(
),'vivian',20110,1,18,'251993465',1,1,'209.16.226.104')

ODBC: SQLExecDirect Error -1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain
a Null value.

John Chalker
Cyber South Internet Comm., Inc.
root@cyber-south.com
334-678-8800 Tele
334-678-7766 Fax