Re: SQL and RadiusNT READ THIS ONE FIRST!
Sam Dibrell, Jr. ( email@example.com )
Fri, 18 Apr 1997 16:21:42 -0500
>If i understand the situation, your ODBC DSN points to and MS Access
>database, that has linked tables to SQL Server? If so, thats the
>Plainly, Jet sucks. I've seen 5-12 SECOND response times on average
>from Access 7.0. Linked tables is only going to make it worse. You
>to use the SQL Server ODBC driver and hit the SQL Server tables directly
>w/out the jet engine to get real performance.
Nope...we're just using the Access97 as a front-end till I can finish the
VB. The upsizing tool was used to create the SQL database. Then we
connected radius to the SQL server via the SQL ODBC driver. We're still
seeing 2000ms response times from the RADIUSNT/SQL configuration, but I
think this was addressed in future posts....:)
Sam Dibrell, Jr.
South Texas Internet Connections, Inc.