[Emerald] ODBC ERROR

rdudek ( (no email) )
Sat, 19 Jun 1999 12:31:52 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0126_01BEBA4F.B5E55180
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

HI Dale !
I have a problem with Emerald on SQL 7.0 it does not clear the on =
line users with the following error.=20
=20
Thank you.
Rdudek@thenew.net
=20
=20
SQL Statement: INSERT INTO Calls =
(CallDate,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctD=
elayTime,AcctSessionId,AcctSessionTime,AcctInputOctets,AcctOutputOctets,N=
ASPortDNIS,FramedAddress) VALUES =
(GetDate(),'rst1marg','209.112.15.3',20104,0,2,0,'289202448',729,86636,60=
4852,'0301','209.112.15.141')
ODBC Error:23000:2627:

a.. [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY =
KEY constra

int 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.

Sending Accounting Ack of id 118 to d1700f03 (as2-cam.thenew.net)

Resp Time: 20 Auth: 33/0 -> 33 Acct: 47/0/12 -> 59

------=_NextPart_000_0126_01BEBA4F.B5E55180
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

HI  Dale !
I have a problem with Emerald on SQL 7.0 it does not clear the =on line=20 users with the following error.
 
Thank you.
Rdudek@thenew.net
 
 
SQL Statement: INSERT INTO Calls=20 =(CallDate,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctD=elayTime,AcctSessionId,AcctSessionTime,AcctInputOctets,AcctOutputOctets,N=ASPortDNIS,FramedAddress)=20 VALUES=20 =(GetDate(),'rst1marg','209.112.15.3',20104,0,2,0,'289202448',729,86636,60=4852,'0301','209.112.15.141')

ODBC Error:23000:2627:

  • [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of =PRIMARY=20KEY constra

    int 'pk_Calls'. Cannot insert duplicate key in object=20'Calls'.

    Sending Accounting Ack of id 118 to d1700f03=20(as2-cam.thenew.net)

    Resp Time: 20 Auth: 33/0 -> 33 Acct: 47/0/12 ->=2059

    • ------=_NextPart_000_0126_01BEBA4F.B5E55180--