Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
Chris Given
term at velocitus.net
Fri Nov 9 19:30:23 CST 2001
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.
===
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