(RADIATOR) SQL Server Connection Handling

[Hugh Irvine]

Hello Dan, Hello Everyone -

I can see that many people struggle with MSSQL connectivity, so I just 
thought I would mention an alternative approach that is *much* simpler 
to implement, which is to install an instance of Radiator on the MSSQL 
box. This Radiator instance would receive proxied radius requests from 
your main installation and simply do a local ODBC connection to the 
database.

As a general rule, proxying radius requests is very much easier than 
trying to set up inter-platform SQL connectivity.

This may not work for everyone, but keep it in mind.

regards

Hugh


On Friday, September 6, 2002, at 03:19 AM, 'Dan Melomedman' wrote:

> Patrick Muldoon(NOC) wrote:
>> We use DBD::Sybase with FreeTDS to connect to MSSQL Server 2000 from
>> FreeBSD, and it works great, have never had any trouble.
>>
>> What version of FreeTDS are you using?
>>
>> You can also do some debugging with FreeTDS to see if it is the one
>> hanging.
>> http://www.freetds.org/userguide/x1873.htm#AEN1877
>>
>> Hope this helps,
>>
>> -Patrick
>
> I am happy for you. We are using MSSQL 7.0, with service pack 2. We also
> use FreeTDS with PHP, and had some minor problems, but nothing major.
> There are/were many really screwy problems with FreeTDS like memory 
> leaks
> and segfaults, and part of the problem is the reverse engineering, but
> it's a good suspect.
>
> We're always using the latest version of FreeTDS, and AFAIK it's been
> 0.53 for quite a while. This server hang problem is very irritating, and
> ambiguity of it really sucks. Where to look? DBD:Sybase? FreeTDS? MSSQL?
> So many layers.
>
> Does anyone on this list use MSSQL with Sybase client libraries by any
> chance? UnixODBC or iODBC with a commercial ODBC driver? What are your
> results? I've used Sybase client libraries with MSSQL 6.5 in the past
> with good results. Had more problems with 7.0. BTW, FreeTDS have a
> very early version of an ODBC driver. They're willing to finish it
> if you sponsor them. If FreeTDS makes you a profit, may as well
> support the developers :)
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.