FreeTDS Development Group

["Berger, Daniel" <djberge AT qwest.com>]

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of 
> Michael Peppler
> Sent: Thursday, June 24, 2004 12:49 AM
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] [comp.lang.perl.misc] Re: DBD::Sybase, 
> FreeTDS problem
> 
> 
> FYI - DBD::Sybase 1.03 and later understand host= and port= 
> attributes in the DSN, but this triggers the use of the 
> CS_SERVERADDR connection property, a new feature of OpenClient 12.5.1.
> 
> If host/port are used and the library doesn't know about 
> CS_SERVERADDR a fatal error is generated.
> 
> Michael
> 
> On Thu, 24 Jun 2004 08:12:41 +0200, Michael Peppler wrote:
> 
> > On Wed, 23 Jun 2004 14:15:34 -0700, Daniel Berger wrote:
> > 
> >> Hi all,
> >> 
> >> Perl 5.8.2
> >> Solaris 9
> >> FreeTDS 0.63 (20040622)
> >> DBI 1.42
> >> DBD::Sybase 1.04
> >> 
> >> I installed FreeTDS 0.63 successfully.  I can definitely connect 
> >> using tsql.  However, when I try this simple script I get an error.
> >> 
> >> use strict;
> >> use warnings;
> >> use DBI;
> >> use DBD::Sybase;
> >> 
> >> my $login  = "user";
> >> my $passwd = "xxxx";
> >> my $server = "SOME-SERVER";
> >> my $host   = "somehost";
> >> my $port   = 1030;
> >> 
> >> $ENV{SYBASE} = "/usr/local";
> >> my $dbh =
> >> 
> DBI->connect("dbi:Sybase:server=$server;host=$host;port=$port",$login
> >> DBI->,
> >> $passwd);
> >> 
> >> $dbh->disconnect();
> >> 
> >> The error is: This version of OpenClient doesn't support 
> >> CS_SERVERADDR at /opt/csw/lib/perl/site_perl/DBD/Sybase.pm line 87.
> > 
> > DBD::Sybase doesn't use the host/port method of connecting to a 
> > database server. Instead it uses a logical server name 
> defined in the 
> > interfaces file (or in the freetds.conf file.)
> > 
> > The only exception is when using Sybase OpenClient 12.5.1 or later, 
> > where the API has the ability to by-pass the interfaces file.
> > 
> > If "SOME-SERVER" is defined in your freetds.conf file you 
> can simply 
> > remove the host/port info from the DSN and it should work correctly.
> > 
> > Michael

Thanks Michael, that worked.

Dan