Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
Mike McCauley
mikem at open.com.au
Sun Nov 11 21:49:30 CST 2001
Hello,
Thanks very much for your note. Our previous tests with freetds were
positive, but some of our customers have reported problems with earlier
versions.
If you are successful, we (and many others) would be very interested to hear
about it.
BTW, did you see the note from someone else on the list about the Merant ODBC
drivers (commercial) (www.merant.com), which are apparently available for
MSSQL 2000.
Please let us know how you get on. Cheers.
Cheers.
On Mon, 12 Nov 2001 13:48, Le Anh Tuan wrote:
> 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
--
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