Re: [Emerald] ODBC error

Dale E. Reed Jr. ( (no email) )
Sat, 17 Jul 1999 09:13:03 -0700

"Michael Vincent K. Pozon - CompE" wrote:
> guys ,
> i found out why some users are not listed in the online windows
> becoz of this error :
> ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY K
> int 'pk_RadLogs': Attempt to insert duplicate key in object 'RadLogs'.
> Question :
> how do i fix this error ?

What kind of terminal server are you using? This means that
RadiusNT things it already received the accounting record. However,
some terminals servers (notably USR) reuse Acct-Session-IDs to
quickly, which can cause the above problem.

The only way to help prevent this is to add the username to the
Primary Key in the Calls table.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: