I have decided to try emerald. Right now I got the NTmail setup,
Soft*Deposit is coming ( I bought it). I wonder where I can find
the document to configure the emerald to work with NTmail and
Soft*Deposit. And how I can transfer the MS Access database file
into Emerald.
I can not use following statements to insert subaccounts, and Masteraccounts
insert into SubAccounts (AccountID, CustomerID, Login, Shell, FirstName,
LastName, PhoneHome, PhoneWork, AccountType, Description, Password,
saExpireDate, Extension, Active, TimeLeft, LoginLimit)
values ('1', '1', 'test', NULL, 'test', 'user', NULL, NULL, 'PPP', NULL,
'testtest', NULL, NULL, '1', '-9999', '5');
insert into MasterAccounts (CustomerID, FirstName, LastName, Company,
Address1, Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax,
CreateDate, StartDate, maExpireDate, Extension, Active, Comments,
LastModifyDate, LastModifyUser)
values ('1', 'test', 'user', NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '1999-01-01 00:00:00', '0', '1', NULL, NULL, NULL);
Can you help me out, so I can insert our data into Emerald.
I appreciate all your help.
Thanks!
L. Sun -:)
Webmaster and System Administrator
----------------------------------------------------------------------------
------
Larkom Your Link to the Rest of the World
Tel: (714)492-2938 Email: sun@larkom.net
FAX: (714)492-2578 URL: http://www.larkom.net