Re: ODBC Nightmare - somebody please help

Dale E. Reed Jr. ( (no email) )
Thu, 18 Dec 1997 09:51:40 -0800

> Nick Fuller wrote:
>
> When using the Administrator program/Security Tab I fill in the radius
> username and password correctly then use the check connection button and I get
> the "Check connection failed" message. I have setup the System DSN as
> instructed, using a nontrusted connection, and within the DSN configuration I
> can successfully connect to the Data Source without any errors.

Did you select the DSN from the general tab? Can you connect to the DSN
using another program like MS Query? Do you have anything in the database
itself?

> ODBC Licenses: SQLExecDirect Error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> 'Liscenses'.
>
> radius: Invalid Database or Computer Date.

This means one of two things. First, that the Liscenses table does
not exist. Secondly that the date on your SQL Database is newer than
the date on your computer or RadiusNT could not determine the date of
your database.

> I am not sure what the system is trying to achieve at this point, there is no
> table in the radius database called "Liscenses", there is not even one with
> the correct spelling of "Licenses".

Is there anything in the database?

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com