Re: Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
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: [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Mike McCauley [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 09, 2001 7:59 AM
> > To: Le Anh Tuan
> > Cc: [EMAIL PROTECTED]
> > 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: [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
Re: Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
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:
> > > > >
> > > &g
RE: Fwd: RE: (RADIATOR) Connect to MS SQL Server 2000 from Linux
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
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
> >
> > >
