Skip to Content.
Sympa Menu

freetds - RE: [freetds] [comp.lang.perl.misc] Re: DBD::Sybase, FreeTDS problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Berger, Daniel" <djberge AT qwest.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] [comp.lang.perl.misc] Re: DBD::Sybase, FreeTDS problem
  • Date: Thu, 24 Jun 2004 10:41:18 -0500



> -----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





Archive powered by MHonArc 2.6.24.

Top of Page