Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
Mike McCauley
mikem at open.com.au
Fri Nov 9 19:03:00 CST 2001
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