Re: [RadiusNT] Just upsized to MS SQL 6.5

Dale E. Reed Jr. ( (no email) )
Mon, 16 Aug 1999 12:11:18 -0700

Danny Sinang wrote:
>
> Hi Dale,
>
> I just upsized my RadiusNT 2.5 Access 97 database to MS SQL Server 6.5 .
>
> Now the Access database has remote links to the new SQL Server tables.
>
> RadiusNT 2.5 still uses the old MS Acess 97 ODBC DSN.
>
> Questions :
>
> 1. Should I still keep the "Manual Calls Update" and "Manual SVC Update" ?

You will until you add the trigger onto your Calls table. YOu can
get it from the radiusnt.sql script on our FTP site.

> 2. Will things be a lot faster if I changed the ODBC DSN to point to the SQL
> Server ?

I definately would. No need to introduce middle points.

> 3. Do I need to create some new triggers on the SQL Server ( aside from what
> the Upsizing Wizard created ) ?

Yes. The upsizing wizard didn't create any.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart