Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux

Mike McCauley mikem at open.com.au
Fri Nov 9 22:04:52 CST 2001


Hi Chris,

thanks for the tip.

Presume you use DBD-ODBC and a driver manager like iODBC?

Cheers.

On Sat, 10 Nov 2001 12:30, Chris Given wrote:
> A good solution for this is the Merant drivers (Which allow a direct ODBC
> connection from most Unixes to Microsoft SQL Server 2000).
>
> We are running all our radius servers on Linux with this driver directly
> connected to SQL server with no problems.
>
> Keep in mind, the drivers are not free (Except JDBC).
>
> -----Original Message-----
> From: Mike McCauley [mailto:mikem at open.com.au]
> Sent: Friday, November 09, 2001 6:03 PM
> To: Le Anh Tuan
> Cc: radiator at open.com.au
> Subject: Re: Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from
> Linux
>
>
> Hello,
>
> after some investigation, I have confirmed that DBD-Sybase and the Syabase
> client libraries do not interoperate with MS-SQL 2000. Microsoft have
> abandoned Sybase compatibility in MS-SQL. Therfore, the only way I know
> right
> now to get to MS-SQL 2000 from Unix is via DBD-Proxy.
>
> Thanks for raising this with us.
>
> Cheers.
>
> On Thu, 8 Nov 2001 20:02, you wrote:
> > Hi Mike and Hugh,
> > What I mentioned here is MS SQL version 2000 (8.0), not 7.0
> >
> > Le Anh Tuan
> > R&D Department
> > Netnam Corporation
> > Institute of Information Technology
> > Email: latuan at netnam.vn
> >
> > > -----Original Message-----
> > > From: Mike McCauley [mailto:mikem at open.com.au]
> > > Sent: Thursday, November 08, 2001 3:49 PM
> > > To: Le.Anh.Tuan
> > > Cc: hugh at open.com.au
> > > Subject: Re: Fwd: RE: (RADIATOR) Connect to MS SQL Server
> > > 2000 from Linux
> > >
> > >
> > > Hello,
> > >
> > > On Wed, 7 Nov 2001 23:04, Hugh Irvine wrote:
> > > > Hugh
> > > >
> > > > >	by server1.open.com.au (8.11.0/8.11.0) with ESMTP id
> > >
> > > fA71Fn331202
> > >
> > > > >	for <hugh at open.com.au>; Tue, 6 Nov 2001 19:15:50 -0600
> > > >
> > > > From: "Le Anh Tuan" <latuan at netnam.vn>
> > > >
> > > > >To: "'Hugh Irvine'" <hugh at open.com.au>
> > > > >Subject: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
> > > > >Date: Wed, 7 Nov 2001 10:00:01 +0700
> > > > >X-Priority: 3 (Normal)
> > > > >Importance: Normal
> > > > >
> > > > >Hi Hugh,
> > > > >I'm using Sybase-OpenClient 11.1.1-3, DBD-Sybase 0.93 on
> > >
> > > RedHat 7.1.
> > >
> > > > >My interfaces file like this:
> > > > >   radius
> > > > >         master tcp ether 203.160.0.11 1433
> > > > >         query tcp ether 203.160.0.11 1433
> > > > >
> > > > >In which: 203.160.0.11 is my database server running MSSQL
> > >
> > > 2000 on W2K
> > >
> > > > >Advance.
> > > > >
> > > > >Then I tried to connect to MSSQL with my test script :
> > > > >       use DBI;
> > >
> > > $dbh=DBI->connect("dbi:Sybase:server=radius","myacct,"mypass");
> > >
> > > > >      $sth=$dbh->prepare("select username from users");
> > > > >     $sth->execute();
> > > > >     while (@row=$sth->fetchrow_array)
> > > > >    {
> > > > >      print "@row\n";
> > > > >     }
> > > > >
> > > > >But script failed and generated a error:
> > > > >"   DBI->connect(server=radius) failed: OpenClient
> > >
> > > message: LAYER = (5)
> > >
> > > > >ORIGIN = (3) SEVERITY = (5) NUMBER = (6)
> > > > >Message String: ct_connect(): network packet layer:
> > >
> > > internal net library
> > >
> > > > >error: Net-Library operation terminated due to disconnect"
> > > > >
> > > > >I looked add SQL error log and see it said that:
> > >
> > > "Connection opened but
> > >
> > > > >invalid login packet(s) sent.  Connection closed. "
> > > > >I searched on Microsoft website and found this bug on article
> > > >
> > > >http://support.microsoft.com/support/kb/articles/q239/8/83.as
> > >
> > > p, I quote
> > >
> > > > >some of their saying:
> > > > >
> > > > >"Therefore, a change has been introduced in SQL 7.0 that
> > >
> > > allows SYBASE
> > >
> > > > >TDS 5.0 clients to connect. However, this does not mean the
> > > > >configuration is officially supported by Microsoft. TDS
> > >
> > > 4.2 is the only
> > >
> > > > >level of compatibility that is supported for SYBASE TDS
> > >
> > > based clients.
> > >
> > > > >TDS 5.0 is a SYBASE specification and it is not supported
> > >
> > > by Microsoft.
> > >
> > > > >NOTE: Microsoft will not include these changes in future
> > >
> > > versions of
> > >
> > > > >Microsoft SQL Server. These changes will remain during the
> > >
> > > lifetime of
> > >
> > > > >the SQL 7.0 product, including service packs. Limited
> > >
> > > testing has been
> > >
> > > > >performed by Microsoft regarding the functionality of
> > >
> > > SYBASE TDS 5.0
> > >
> > > > >clients with this change. Only basic connectivity is ensured."
> > > > >
> > > > >That's why I suggest that Microsoft does not support
> > >
> > > Sybase client and
> > >
> > > > >TDS liked softwares such as FreeTDS with SQL 2000. If you
> > >
> > > can do that,
> > >
> > > > >please let me know how? And I think many people on this
> > >
> > > list will have
> > >
> > > > >the same problem like me.
> > >
> > > We have tested MS-SQL 7.0 with DBD-Sybase and it works fine,
> > > but you _must_
> > > have the latest MS-SQL service pack installed (I think it was
> > > MS-SQL SP2 that
> > > fixed Sybase conpatibility, but check the MS web site). It
> > > sounds very much
> > > like you dont have that SP installed.
> > >
> > > Cheers.
> > >
> > > > >Thank you very much.
> > > > >
> > > > >
> > > > >Le Anh Tuan
> > > > >R&D Department
> > > > >Netnam Corporation
> > > > >Institute of Information Technology
> > > > >Email: latuan at netnam.vn
> > > > >
> > > > >>  -----Original Message-----
> > > > >>  From: owner-radiator at open.com.au
> > > > >>  [mailto:owner-radiator at open.com.au] On Behalf Of Hugh Irvine
> > > > >>  Sent: Tuesday, November 06, 2001 4:40 PM
> > > > >>  To: Le Anh Tuan; radiator at open.com.au
> > > > >>  Subject: Re: (RADIATOR) Connect to MS SQL Server 2000 from Linux
> > > > >>
> > > > >>
> > > > >>
> > > > >>  Hello Le Anh Tuan -
> > > > >>
> > > > >>  At 11:59 +0700 01/11/6, Le Anh Tuan wrote:
> > > > >>  >Hi All,
> > > > >>  >Does anyone successfully connect to MS SQL Server 2000
> > >
> > > from RedHat
> > >
> > > > >>  >Linux? I tried Sybase client and FreeTDS but none of
> > >
> > > these methods
> > >
> > > > >>  >work. I prefer running Radiator on Linux and storing
> > >
> > > user database
> > >
> > > > >>  >on W2K+SQL 2000, but I can not configure them to work together.
> > > > >>
> > > > >>  I have configured both of the solutions you mention
> > >
> > > myself and both
> > >
> > > > >>  work - although the Sybase client is by far the
> > >
> > > prefered way to go.
> > >
> > > > >>  What sort of problems are you having?
> > > > >>
> > > > >>  regards
> > > > >>
> > > > >>  Hugh
> > > > >>
> > > > >>
> > > > >>  --
> > > > >>
> > > > >>  NB: I am travelling this week, so there may be delays in our
> > > > >>  correspondence.
> > > > >>
> > > > >>  Radiator: the most portable, flexible and configurable
> > >
> > > RADIUS server
> > >
> > > > >>  anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password,
> > >
> > > NT, Emerald,
> > >
> > > > >>  Platypus, Freeside, Interbiller, TACACS+, PAM,
> > >
> > > external, etc, etc.
> > >
> > > > >>  Available on Unix, Linux, FreeBSD, Windows 95/98/2000,
> > >
> > > NT, MacOS X.
> > >
> > > > >>  ===
> > > > >>  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.
> > >
> > > --
> > > Mike McCauley                               mikem at open.com.au
> > > Open System Consultants Pty. Ltd            Unix, Perl,
> > > Motif, C++, WWW
> > > 24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
> > > Phone +61 3 9598-0985                       Fax   +61 3 9598-0955
> > >
> > > Radiator: the most portable, flexible and configurable RADIUS server
> > > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > > Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
> > > on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
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.


More information about the radiator mailing list