RE: Why is ODBC so difficult?

Beverly Wise ( (no email) )
Thu, 26 Feb 1998 14:42:15 -0500

I sent the following message before the one you replied to. Take a look, it
may give you what you need. I do believe that I had manual call update
checked when this was done.

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. [mailto:daler@iea-software.com]
..Sent: Thursday, February 26, 1998 2:21 PM
..To: RadiusNT@iea-software.com
..Subject: Re: Why is ODBC so difficult?
..
..
..Beverly Wise wrote:
..>
..> >Whats options do you have enabled in the RadiusNT admin and what kind of
..> >database are you using?
..>
..> Sorry, one more thing. The only option I am running is Concurrency
control.
..
..You still left out a more important piece of information: what kind of
..database are you using? if its MS Access, you need the manual calls
..update for concurrency control to work.
..
..--
..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
..