Re: [Emerald] ODBC Error

Dale E. Reed Jr. ( (no email) )
Fri, 21 Apr 2000 14:26:12 -0700

NCKCN wrote:
>
> I'm getting the following error in the Authentication log I am running:
>
> ===================
> Acct batch fail: [23000] [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot insert the
>
> value NULL into column 'NASPort', table 'Emerald.dbo.Calls'; column does not
> allow nulls.
>
> INSERT fails. [INSERT INTO
>
> Calls(CallDate,Username,AcctStatusType,AcctSessionID,AcctDelayTime,NASPortTy
> pe,NASIdentif
>
> ier,ServerID)VALUES('20000421
>
> 11:52:9','administrator',1,'administrator212',0,5,'206.253.60.20',9) ]
> ======================
>
> Why is this error showing up? Why is it trying to insert a NULL value in the
> NASPort column?

Edit your Calls Table and add a default value of say (9999) to your
NASPOrt column. TYpically this is a PM that is doing telnet accounting.
It doesn't send a port.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

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