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:[EMAIL PROTECTED]] > Sent: Friday, November 09, 2001 6:03 PM > To: Le Anh Tuan > Cc: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > > > > -----Original Message----- > > > From: Mike McCauley [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, November 08, 2001 3:49 PM > > > To: Le.Anh.Tuan > > > Cc: [EMAIL PROTECTED] > > > 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 <[EMAIL PROTECTED]>; Tue, 6 Nov 2001 19:15:50 -0600 > > > > > > > > From: "Le Anh Tuan" <[EMAIL PROTECTED]> > > > > > > > > >To: "'Hugh Irvine'" <[EMAIL PROTECTED]> > > > > >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: [EMAIL PROTECTED] > > > > > > > > > >> -----Original Message----- > > > > >> From: [EMAIL PROTECTED] > > > > >> [mailto:[EMAIL PROTECTED]] On Behalf Of Hugh Irvine > > > > >> Sent: Tuesday, November 06, 2001 4:40 PM > > > > >> To: Le Anh Tuan; [EMAIL PROTECTED] > > > > >> 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 [EMAIL PROTECTED] > > > > >> To unsubscribe, email '[EMAIL PROTECTED]' with > > > > >> > > > > > > 'unsubscribe radiator' in the body of the message. > > > > > > -- > > > Mike McCauley [EMAIL PROTECTED] > > > 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.