When the CallsOnline table is being updated, an SQL Error is being
generated. The information from th etrace is as follows:
SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIPAddress,
NASPort,NASPortType,AcctStatusType,AcctAuthentic,ConnectInfo,CalledStationId,Cal
lingStationId,ServiceType,FramedProtocol,FramedIPAddress,AcctDelayTime)
VALUES (
GetDate(),'33002C12','bgi1756','196.1.167.150',2,0,1,1,'33600
LAPM/V42BIS','4318
550','2464251430',2,1,'205.214.193.92',63)
SQL Statement: UPDATE CallsOnline Set
Username='bgi1756',AcctStatusType=1, Cal
lDate=GetDate(), FramedAddress='205.214.193.92' WHERE
NASIdentifier='196.1.167.1
50' and NASPort=2 AND (DateAdd(Second, 0-i.AcctDelayTime, i.CallDate)
>= CallD
ate OR CallDate IS NULL)
ODBC Error:37000:107:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'i'
does not m
atch with a table name or alias name used in the query.
Sending Accounting Ack of id 105 to c401a796 (barpm6)