At 09:39 AM 1/17/98 +1100, you wrote:
>>>>
<excerpt><smaller>I Turned off the USR TC again and now the errors are
back I can't get any calls on line and users are not having there on-line
information logged so they can't be billed. I need to be able to turn off
and on the USR from time to time and still be able to work normally
without having to go through days of fiddling to try and get the USR to
work, can any body suggest a solution.
</smaller>
<smaller> SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,AcctStatusType,NASPortType,UserService,FramedProtocol,FramedAddress,Acc
tDelayTime) VALUES
(GetDate(),'0001000B','test','xxx.xxx.xxx.xxx',2,1,0,2,1,'xxx.xxx.xxx.xxx',0)</smaller>
<smaller>ODBC: SQLExecDirect Error 2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object
'Calls'.Sending Accounting Ack of id 33 to cb230605 (ROMUSR)</smaller>
<smaller>Resp Time: 20 Auth: 1/0 -> 1 Acct: 0/0/2 -> 2
</smaller>
<smaller>David Moore
<<mailto:moored@romtech.com.au>moored@romtech.com.au
</smaller>
</excerpt><<<<<<<<
"The woods are lovely, dark and deep. But I have promises to keep,
And lines to code before I sleep, And lines to code before I sleep."
David Harris
Operations Manager
StarNet OnLine Systems