fionbarr has asked for the wisdom of the Perl Monks concerning the following question:

I have been given the following:
DB_URL=jdbc:jtds:sybase://ddd.ddd.ddd.dd:ddddd/xxxxxx DB_USERNAME=user DB_PASSWORD=password
Can anyone suggest how I should format a connect string for DBI?

Replies are listed 'Best First'.
Re: connect string for sybase
by AppleFritter (Vicar) on Jul 25, 2014 at 16:57 UTC

    Just a stab in the dark:

    my $dbh = DBI->connect("dbi:Sybase:host=ddd.ddd.ddd.dd;port=ddddd;data +base=xxxxxx", "user", "password");

    What have you tried?

      I am directed (by CPAN) to install DBD::Sybase. CPAN says (after trying to install):
      Pleae set SYBASE in CONFIG or set the $SYBASE environment variable at +Makefile.PL line 120, <IN> line44

        Usually, $ENV{SYBASE} is set to the directory where your Sybase client libraries are installed. Maybe you can set $ENV{SYBASE} to that directory?

        didn't mention, working on Windows 7
        MEWP/DBD-Sybase-1.15.tar.gz :writemakefile NO 'C\Perl64\bin\perl.exe M +akefile.pl INSTALLDIRS=site' returned status 512
Re: connect string for sybase
by kcott (Archbishop) on Jul 26, 2014 at 04:40 UTC