Re: SQL question

Mourad Dahoumane ( mdahoumane@interway.lu )
Sat, 03 May 1997 11:23:15 +0200

Dale,

I'm geting this error on radius. it tries to insert a start record for the
NAS.
If I reboot the NAs it goes back to normal for a short time then it start
again.
where should I look to correct this.

odbc: SQLExecDirect Error: : the column NASPort in table calls may not be
null.

sql statement: insert into calls
(calldate,acctsessionIs,NASIdentifier,acctstatustype,acctdelayTime) VALUES
(getdate(),'00000000','195.61.225.3',1,33882)

Mourad Dahoumane

>Yes. You can use a trigger to roll-back the transaction and erorr the
>insert. I used one a while back to stop RadiusNT from inserting
>Start records into the calls table.
>
>--
>Dale E. Reed Jr. (daler@iea.com)