ODBC Nightmare - somebody please help

Nick Fuller ( nfuller@b-m-s.co.uk )
Thu, 18 Dec 1997 16:43:48 -0000

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------ =_NextPart_001_01BD0BD4.1F0D9CC0
Content-Type: text/plain

I have downloaded the evaluation copy of RadiusNT

It installed fine, but I have come across an issue in the setup of the
ODBC connection to a SQL Server 6.5 database that I cannot fathom.

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.

Also if I run "Radius -x15" from the command prompt, it reports the
following message:

1) EncryptPasswords: 0
2) IgnoreCase: 0
3) ReqAcctAuth: 1
4) Options: 258
5) Debug: 4
6) ODBCDatasource: radius
7) DataDirectory:
8) AcctDirectory:
9) UsersFile: Users
10) Username: radius
11) Password: radius
12) CompanyName:
13) License:
14) AcctPort: 1646

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'radius'...
Making ODBC Connection...
ODBC Licenses: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Liscenses'.

radius: Invalid Database or Computer Date.

D:\radius>

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

Am I missing the point???

Nick

------ =_NextPart_001_01BD0BD4.1F0D9CC0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

I have downloaded the evaluation copy =of RadiusNT

It installed fine, but I have come =across an issue in the setup of the ODBC connection to a SQL Server 6.5 =database that I cannot fathom.


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.


 Also if I run "Radius =-x15" from the command prompt, it reports the following =message:

1) EncryptPasswords: 0
2) IgnoreCase: 0
3) ReqAcctAuth: 1
4) Options: 258
5) Debug: 4
6) ODBCDatasource: =radius
7) DataDirectory:
8) AcctDirectory:
9) UsersFile: Users
10) Username: radius
11) Password: radius
12) CompanyName:
13) License:
14) AcctPort: 1646

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: ='radius'...
Making ODBC =Connection...
ODBC Licenses: SQLExecDirect =Error:
 [Microsoft][ODBC SQL Server =Driver][SQL Server]Invalid object name 'Liscenses'.

radius: Invalid Database or =Computer Date.

D:\radius>

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


Am I missing the point???

Nick

------ =_NextPart_001_01BD0BD4.1F0D9CC0--