[Emerald Digest]

emerald-digest-request@iea-software.com
Mon, 17 Aug 1998 00:00:01 -0700

Message 1: error message
from emerald@nls.net

Message 2: Re: error message
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 3: Re: Emerald Admin: Billing Cycles
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: error message
From: emerald@nls.net
Date: Sun, 16 Aug 1998 17:53:39 -0400

Can anyone tell me the cause of the following error message in Radius 2.5?

Sun Aug 16 16:48:23 1998: ODBC Error:07001:0:
[Microsoft][ODBC SQL Server Driver]Wrong number of parameters

Geo.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: error message
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sun, 16 Aug 1998 23:03:10 -0700

emerald@nls.net wrote:
>
> Can anyone tell me the cause of the following error message in Radius 2.5?
>
> Sun Aug 16 16:48:23 1998: ODBC Error:07001:0:
> [Microsoft][ODBC SQL Server Driver]Wrong number of parameters

Typically, this is when RadiusNT is calling a stored proc and using the
wrong number of parameters. Did it show the actual call itself above
the error?

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

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald Admin: Billing CyclesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sun, 16 Aug 1998 23:22:38 -0700

This isn't really a RadiusNT issue is it? This should be on theEmerald Mailing list. Please use it for followups. I really try tokeep Emerald specific issues on the Emerald list, since we haveRadiusNT customers on this list who don't use Emerald.

Glen Harvy wrote:> > By way of background, I charge my customers on the 15th Monthly and have> done so for years. If someone joins up in between dates then I make an> appropriate adjustment to their hours and/or charge.

Do you bill on the 15th for the 15th-15th or on the 15th for the1st-1st? > I thought I had everything properly configured however when I ran call> consolidation, all the call details prior to August 1st was deleted from> the CALLS table.

This sounds like an Emerlad 2.1 issue. If you use Emerald 2.2, theconsolidation will correctly align on the expiration date. > I presume that I didn't setup Emerald properly in that the billing cycle> should have been "anniversary" rather than "monthly" (I got that> information from the Database Schema). On trying to check this, when I try> to click on the tab I get:

Billing cycles are NOT implemented in Emerald 2.2 and lower. Ignore thetab in the Admin. > The problem I now have is that the call data from 15th July to 1st August> has "disappeared"! Is there anyway I can get extract this data?

Not unless you have a backup. > The documentation infers that a users call data is saved in the users own> database. Is this correct? If it is, I could run Call Consolidation daily> and allow my users access to their own database.

I don't follow the above, and if it is in the docs, its wrong. Thereis now users database. There is a CallHistory Table that shows summaryinformation for prior usage.

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