FAQ
Hello,

I am trying to use freetds (0.63) as the library for DBD::Sybase (1.07) to
communicate with MS SQL 2000 servers. After the build, it does not appear
that DBD::Sybase reconizes the freetds config file
(/usr/local/freetds/freetds.conf), in particular for defining which
host+port make up the Server. I even tried it in the local `pwd`. Most
importantly, 'make test' fails and will not complete the install.

Also, the "connect" method complains about accepting host+port arguments,
and seems to want a "Server", only. The manpage says it accepts host+port.

I am operating in a HPUX 11.11 environment, and have the DBD::Sybase
statically linked using the freetds libs. Without passing the 'make test'
target, DBD::Sybase does not fully install (complains about not found in
@INC). I am using Perl 5.8.7, and DBI-1.48. The "make test" appears to
fail because it tries to use a non-existent (standard) Sybase server and
connect params.

Any help would be greatly appreciated.
Thanks, in advance.

Rick

-----------------------------
Rick Frink, Senior Consultant
The Occam Group of Professional Computers Services Organization
1919 Birchwood Dr
Troy, MI 48083

614.554.7405 (Cell)
248.528.3770 (Office)
248.528.3573 (Fax)

Search Discussions

  • Michael Peppler at Dec 22, 2005 at 4:51 pm

    On Wed, 2005-12-21 at 11:34 -0500, Rick Frink wrote:
    Hello,

    I am trying to use freetds (0.63) as the library for DBD::Sybase (1.07) to
    communicate with MS SQL 2000 servers. After the build, it does not appear
    that DBD::Sybase reconizes the freetds config file
    (/usr/local/freetds/freetds.conf), in particular for defining which
    host+port make up the Server. I even tried it in the local `pwd`. Most
    importantly, 'make test' fails and will not complete the install.

    Also, the "connect" method complains about accepting host+port arguments,
    and seems to want a "Server", only. The manpage says it accepts host+port.
    If you read the man page completely you'll notice that the host+port
    connect() argument are only supported when using *Sybase* openclient
    12.5.1 or later. It is not supported with FreeTDS.

    I am operating in a HPUX 11.11 environment, and have the DBD::Sybase
    statically linked using the freetds libs. Without passing the 'make test'
    target, DBD::Sybase does not fully install (complains about not found in
    @INC). I am using Perl 5.8.7, and DBI-1.48. The "make test" appears to
    fail because it tries to use a non-existent (standard) Sybase server and
    connect params.
    Did you give it a valid server name during the configuration phase of
    the build?
    Is that server correctly defined in the freetds.conf file?
    Is the SYBASE env. variable set correctly to point at the FreeTDS
    installation?

    Michael
    --
    Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
    Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
    Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
  • Rick Frink at Dec 27, 2005 at 8:39 pm
    Michael,

    Thanks for the reply.

    I guess I assumed that since TDS supports the host+port that the Sybase
    DBD would also.

    After your reply, I tried the 'make test' again, with each ENV variable
    set that I could think of, and correct values in PWD. Still, it was not
    referencing the proper info. Next, I hardcoded the correct values into each
    script in the "t" directory, and got it to complete, then installed it.

    At this point, since many tests failed, I am wondering if I have a useful
    Sybase-DBD module ? I am attaching the output of the last 'make test'.

    Thanks again for your assistance.

    Rick


    -----Original Message-----
    From: Michael Peppler
    Sent: Thursday, December 22, 2005 11:51 AM
    To: rfrink@theoccamgroup.com
    Cc: dbi-users@perl.org
    Subject: Re: DBD-Sybase 1.07, FreeTDS 0.63, HPUX 11.11: Build problem
    (maketest)
    On Wed, 2005-12-21 at 11:34 -0500, Rick Frink wrote:
    Hello,

    I am trying to use freetds (0.63) as the library for DBD::Sybase
    (1.07) to communicate with MS SQL 2000 servers. After the build, it
    does not appear that DBD::Sybase reconizes the freetds config file
    (/usr/local/freetds/freetds.conf), in particular for defining which
    host+port make up the Server. I even tried it in the local `pwd`.
    host+Most
    importantly, 'make test' fails and will not complete the install.

    Also, the "connect" method complains about accepting host+port
    arguments, and seems to want a "Server", only. The manpage says it
    accepts host+port.

    If you read the man page completely you'll notice that the host+port
    connect() argument are only supported when using *Sybase* openclient
    12.5.1 or later. It is not supported with FreeTDS.

    I am operating in a HPUX 11.11 environment, and have the DBD::Sybase
    statically linked using the freetds libs. Without passing the 'make test'
    target, DBD::Sybase does not fully install (complains about not found
    in @INC). I am using Perl 5.8.7, and DBI-1.48. The "make test"
    appears to fail because it tries to use a non-existent (standard)
    Sybase server and connect params.
    Did you give it a valid server name during the configuration phase of the
    build?
    Is that server correctly defined in the freetds.conf file?
    Is the SYBASE env. variable set correctly to point at the FreeTDS
    installation?

    Michael
    --
    Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/ Sybase
    DBA/Developer - TeamSybase: http://www.teamsybase.com/ Sybase on Linux FAQ:
    http://www.peppler.org/FAQ/linux.html

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedDec 21, '05 at 4:37p
activeDec 27, '05 at 8:39p
posts3
users2
websitedbi.perl.org

2 users in discussion

Rick Frink: 2 posts Michael Peppler: 1 post

People

Translate

site design / logo © 2022 Grokbase