Re: Admin logins from NEW PM3

Dale E. Reed Jr. ( (no email) )
Tue, 28 Apr 1998 16:56:36 -0700

John Lange wrote:
>
> I searched the list archive and could not find any more info on this topic.
> Just to show how SQL illiterate I am, I am not real sure how to do this...
>
> Do you mean add an Emerald sub account called "DEFAULT"?

No. Go into Enterprise manager, and drill down into your
Emerald database (Emerald, Objects, Tables) and find your
Calls table. Double click it.

When the edit table window comes up, the right hand column shows
the DEFAULT values for each field.

> >Add a DEFAULT in your SQL Server for the NASPort column of the Calls
> >table to something like 9999. This is a "feature" of the PM3 with
> >ComOS 3.7 or higher. While you are in there doing that, you should add
> >a default of 0 to the AcctSessionTime and AcctDelayTime fields as well.
> >
> >> ODBC: SQLExecDirect Error 233:
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in
> table

-- 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