Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
Le Anh Tuan
latuan at netnam.vn
Sun Nov 11 20:48:45 CST 2001
Hi Mike and Hugh,
We have successfully connected to MS SQL 2000 with FreeTDS 0.52 and
DBD:Sybase 0.91 (none of other versions work!), but we have not tested
with real system. I wonder if FreeTDS is reliable enough to work with
SQL Server?
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: Friday, November 09, 2001 7:59 AM
> To: Le Anh Tuan
> Cc: hugh at open.com.au
> Subject: Re: Fwd: RE: (RADIATOR) Connect to MS SQL Server
> 2000 from Linux
>
>
> Hello again,
>
>
> On Thu, 8 Nov 2001 20:28, Mike McCauley wrote:
> > Hello,
> >
> > 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
> >
> > Oh, sorrry, my mistake.
> > We have also tested here with MS SQL version 2000 on Windows 2000.
>
> I apologise. In fact that information is not quite correct.
> We have not
> successfully tested DBD-Sybase on Unix to MS-SQL 2000 here.
> We are now
> working on finding a suitable way to connect to MSSQL 2000 from Unix.
>
> I hope to be able to send you something later today Friday.
>
> Cheers.
>
>
> >
> > > 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