I'm trying to mak the move from access to SQL as smoothly as possible. I'm
using a slightly modified version of the original access database; I added
some fields for my purposes. I'm still using radius 1.16.60. I'm planning
to use a newer version as I was told that this version is not Y2K
compliant. But right now, I would like to migrate my present setup.
I used Microsoft upsizing tool to migrate my database and it worked very
well. I migrated all my Colf Fusion application to the SQL ODBC datasource
and they worked right out of the box with almost no changes.
I still have a problem having radius NT connecting to that same ODBC
datasource. Maybe I'm not reading enough documentation but I don't have it
working. The datasource works since Cold Fusion is using it.
It always comes back with: "SQLConnect Error: [Microsoft][ODBC SQL Server
Driver][SQL Server] Login failed"
I read the radinstall.txt but it seems so far away from my setup that I
fail to see the link between the two. I have a good experience with SQL,
with access and with ODBC but not with SQL server security.
Would a newer version of Radius NT work better? I'm planning on purchasing
it because of the Y2K thing but it is still a very expensive piece of
software and If I can delay that a little, I will.
I'm using SQL server 6.5 with the latest service pack. Radius is NOT run
as a service. The session is opened as "administrator" and there's an
administrator account in SQL server an I gave it all the permissions I
could find. This is probably the worse way to do it so thanks in advance
for any help.
JF.
Thanks for any help.
------------------------------------------------------------
INTERNET - BBSI Inc. + 141 Regnault
Jean-Francois Laplante + Sept-Iles (Qu=E9bec)
jeff@bbsi.net + G4R 4M4
=0Ahttp://www.bbsi.net + 418-968-4433 voix/voice
+ 418-968-5634 fax=20
Internet Service Provider + Fournisseur de Service Internet
------------------------------------------------------------
For more information about this list, including removal, please
see this URL: http://www.iea-software.com/maillist.html