Re: SQL Field Size Problem

Dale E. Reed Jr. ( (no email) )
Fri, 12 Dec 1997 13:28:50 -0800

Jacob Gubits wrote:
> I have RadiusNT takls to Emerald database via SQL
> When my terminal server requesting authentication from Radius
> redius returns following error message
> ODBC: SQLExecDirect Error 8152:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Column AccnSessionID
> 'Emerald.dbo.Calls' cannot accept 15 bytes (10 max).
> when I try with radlogin it works ok
> The problem is only from terminal server.
> It looks like the database field needs to be resized
> I need help and instructions how to do it

The easiest way I know how to do this is:

1. Open ip SQL Enterprise Manager.

2. Connection to your SQL Server, drill down to Emerald,
Objects, tables, calls. Right click over calls and drop
the calls table.

3. Open up the query tool from within SQLEW. Load insttabs.sql
in. Find the "Create Table Calls" line, go a couple down, and
change the AcctSessionID field size varchar(10) to varchar(18)
or whatever you need.

4. Hightlight the lines starting from create table calls down
to the closing ). Click the green arrow (execute).

5. Load in and execute the insttrig.sql and instperm.sql scripts.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |