------=_NextPart_000_001E_01BD99D6.EF9AE9C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Dale, where should this script be located. It doesn't seem to be on either
my local machine or the main radius server.
Richard Sensale
Network Administrator
VisitUs Internet, Inc.
5468 Schaefer Road
Dearborn, MI 48126 USA
(313) 945-5588
(313) 945-0202 fax
http://www.visitus.net
richards@visitus.net
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, June 16, 1998 8:07 PM
Subject: Re: SQL Errors
>Richard Sensale wrote:
>>
>> Hi lately when adding users in Emerald. I have been getting errors like
the
>> following.. These are all SQL errors. adding MBRs.
>
>If you run the below SQL statement in ISQL_W against your Emerald
>database, what error do you get?
>
>> INSERT MasterAccounts(ReferredBy, FirstName, LastName, Company, Address1,
>> Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax, SalesPerson,
>> Region, CreateDate, StartDate, maExpireDate, Extension, Active,
PayPeriod,
>> PayMethod, PayInfo, PaidThru, LastReceived, PONumber, PrePaid,
>> CreditCardNumber, CreditCardExpire, CreditCardAuth, CreditCardAutoBill,
>> Comments, LastModifyDate, LastModifyUser, Balance, OverDue, SendMethod,
>> GroupID) VALUES('','Denyaz', 'Farhat','', '15030 Colson','',
>> 'Dearborn','MI', '48126','(313) 582-3238', '','', '','Dearborn',
>> '6/16/98','6/16/98', '6/30/98',0, 1,'6 Mons Spec', ' Invoice','',
>> '6/16/98','6/16/98', ' ','', '','', '',0, '','6/16/98 1:34:15 PM',
'sa',0,
>> 0, 0, 1)
>
>I don't see any issues from the statement. YOu might want to run the
>checkdb.sql script to see if it reports an ident problem on your
>MasterAccounts 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
------=_NextPart_000_001E_01BD99D6.EF9AE9C0
Content-Type: text/x-vcard;
name="Richard A Sensale.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="Richard A Sensale.vcf"
BEGIN:VCARD
N:Sensale;Richard;A
FN:Richard A Sensale
ORG:VisitUs Internet, Inc.;Engineering, Operations
TITLE:Network Administrator
TEL;WORK;VOICE:(313) 945-5588
TEL;WORK;FAX:(313) 945-0202
ADR;WORK:;;5468 Schaefer Road;Dearborn;MI;48126;USA
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:5468 Schaefer =
Road=3D0D=3D0ADearborn, MI 48126=3D0D=3D0AUSA
URL:http://www3.visitus.net/wolfen
EMAIL;PREF;INTERNET:richards@visitus.net
EMAIL;INTERNET:webmaster@visitus.net
EMAIL;INTERNET:hostmaster@visitus.net
EMAIL;INTERNET:info@visitus.net
EMAIL;INTERNET:postmaster@visitus.net
END:VCARD
------=_NextPart_000_001E_01BD99D6.EF9AE9C0--