Re: Why is ODBC so difficult?

Beverly Wise ( (no email) )
Wed, 25 Feb 1998 22:14:47 -0500

I am using MS Access 97, the database I am using is the one that came with
the program instead of making my own. I have tried using the date of
12/31/2099 in the maExpire field, and 1 in the extension field, but it still
gives the message of Account Expired. Below is the messages I am receiving
while this is true.

rad_authenticate_OCBC()
Password = "\023\233\274x\377\344\277s\307\340"
SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d',
ma.extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where
(sa.Login='bev' or sa.Shell='bev') AND ma.CustomerID=sa.CustomerID and
sa.Active()0 and ma.Active()0
Decrypted Password: harsin
Database Password: harsin
Sending Reject of id 2 to d10c7209 (fcns.fallscity.net)
LOG: Your Account is Expired
Your Account is Expired.
SQL Statement: INSTERT INTO RadLogs(RadLogsMsgID, LogDate, UserName, Data)
VALUES (12, Now, 'bev', '2100-01-01 00:00:00')
ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find output table
'RadLogs'.
resp Time: 150 Auth: 0/2 -> Acct: 0/0/0 -> 0

If anyone can help, I would appreciate it.

Bev Wise
Falls City Net Services

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Wednesday, February 25, 1998 5:38 PM
Subject: Re: Why is ODBC so difficult?

>Beverly Wise wrote:
>>
>> To all the members... I have been trying to use ODBC mode with Radius NT
for
>> a week now. I can get it to work as long as I don't use my regular
radius
>> users file in the directories tab, as long as I do have an expire field
>> value ( which the instructions say that this field can be NULL and it
won't
>> expire) MaExpire that is. I can't make the maExpire field past 12/31/99
or
>
>RadiusNT 2.2 doesn't support a NULL maExpireDate field, although the docs
>says it does. Sorry about the confusion.
>
>> it says 00 if I try 2000. Now, I have asked for help, and I have gotten
>
>2/2/00 is Feb 2, 2000. Just like 12/31/99 is really Dec 32, 1999.
>
>> some. We run great in Text mode, but in ODBC, nothing but problems, and
if
>> I do get it to run, when I come in the next day, it has performed an
error
>> and shut down. I want some peoples opinion on if using ODBC is really
worth
>> the trouble?
>
>Whats options do you have enabled in the RadiusNT admin and what kind of
>database are you using?
>
>--
>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
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>