Can I get this matter finalized so we can both get back to work on more
important matters :-) please.
At 10:04 19/11/98 -0800, you wrote:
OK. I did exactly what you asked below and ran the original script. I now
get:
<excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><excerpt><bigger>Msg
207, Level 16, State 2
Invalid column name 'ConnectInfo'.
Msg 207, Level 16, State 2
Invalid column name 'CallerID'.
Msg 213, Level 16, State 4
Insert error: column name or number of supplied values does not match
table definition.
Msg 207, Level 16, State 2
Invalid column name 'CallerID'.
</bigger></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt></excerpt>
Do I have to add these column names to some other table as well?
>Glen Harvy wrote:
>>
>> Dale,
>>
>> I played around with the script a bit and ended up with:
>> I now get the following error:-
>>
>> Msg 213, Level 16, State 4
>> Insert error: column name or number of supplied values does not match
table definition.
>
>What I would recommend is adding the ConnectInfo and CallerID
>fields to your ServerPorts table and using the original script. That
>is what the Emerald 2.5 upgrade will do anyways.
>
>These two commans will add the fields and then the original trigger
>will work for you:
>
>
>ALTER TABLE ServerPorts ADD CallerID varchar (15) NULL
>GO
>
>ALTER TABLE ServerPorts ADD ConnectInfo varchar (32) NULL
>GO
>
>--
>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
>
>
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<<>Fidonet needs
<<>Full ISP services<<>FrontDoor Commercial<<>TransX Internet/FTSC
Mailer
voice(02)9977-3788<<>fax(02)9977-3844<<>bbs(02)9977-2855<<>3:714/930
http://www.aquarius.com.au <<> mailto:sales@aquarius.com.au
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<<>Fidonet needs
<<>Full ISP services<<>FrontDoor Commercial<<>TransX Internet/FTSC Mailer
voice(02)9977-3788<<>fax(02)9977-3844<<>bbs(02)9977-2855<<>3:714/930
http://www.aquarius.com.au <<> mailto:sales@aquarius.com.au