Re: [Emerald] RadLog Data Type Errors

Dale E. Reed Jr. ( (no email) )
Tue, 09 Feb 1999 09:24:59 -0800

Rick Knospler wrote:
>
> This was pulled from the the radius nt error log file..
> Any idea what this means and how to fix it?
>
> Tue Feb 09 09:39:35 1999: ODBC Error:37000:260:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit
> conversion from datatype 'varchar' to datatype 'int'
> Table: 'Emerald.dbo.RadLogs', Column: 'CallerID'
> Use the CONVERT function to run this query.
> Tue Feb 09 09:39:35 1999: User: 123 Bad Password

The old update script incorrectly set the CallerID field to an
int, when it should have been a varchar. The easiest way to fix it is
to use Enterprise manager to edit your RadLogs table, rename the
current column to CallerIDOLD (and put a default on it like 0), save
the changes, then add a new column of CallerID, type varchar(15) and
save the changes.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html