Radius & ODBC & SQL

Philip Thomas ( phil@saturnnet.com )
Mon, 31 Mar 1997 14:23:08 -0800

You guys will love this error I am getting. I just recently upgrade to
SQL version 6.5, we are running emerald version 2.1 and radius version
1.1. I found after the upgrade no one was able to log on and after
running radius debug (radius -x11) I came up with this error:

radrecv: Request from host d0cb4b05 code=4, id=54, length=115
Acct-Session-Id = "1A000015"
User-Name = "p50"
NAS-Identifier = 208.203.75.5
NAS-Port = 1
NAS-Port-Type = ISDN
Acct-Status-Type = Start
Acct-Authentic = Local
NAS-Port-DNIS = "7028260470"
Caller-Id = "\200\2037028249664"
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.203.78.30
Acct-Delay-Time = 3330
ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object
'Calls'.
Response Time: 15

This is not limited to just ISDN but all incoming call.

P-Pro-180
128 megs
PortMaster 3

Thanks Phil