Re: ServerAccess follow up.
Dale E. Reed Jr. ( (no email) )
Fri, 24 Apr 1998 17:52:08 -0700
hostmaster@interaxs.net wrote:
>
> Below is the debug capyure from an auth attempt while Server Access was on.
> The sql fetch fails. Not certain why...
> Checking for port access.
>
> SQL Statement: Select MaxSessionLength From Servers s, ServerAccess sa
> Where s.ServerID = sa.ServerID AND sa.Port=18 AND
> s.IPAddress = '206.244.181.254' AND sa.AccountType = 'PPP'
>
> LOG: ODBC: SQLFetch Error: (07001)
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
>
> ODBC: SQLFetch Error: (07001)
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
> ODBC: SQLFetch Error: (07001)
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
Typically, this is an issue with your database not being setup correctly
or a field name mis-spelled. Do you have a ServerAccess table? Have
you verified the fields?
I ran this against the radius97.mdb here and it executed fine.
I don't see any problems with it either.
-- 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