[WindyCity-pm] installing the same module twice

[Craig A. Berry]

On Feb 13, 2009, at 7:21 PM, Whitney Jackson wrote:

>> Could you say more about what exactly is missing in FreeTDS that is  
>> present in the
>> Sybase Open Client libraries?
>
> From the DBD::Sybase documentation under 'Bulk-Load Functionality':
>
> "NOTE: This feature requires that the libblk.a library be available at
> build time. This is not always the case if the Sybase SDK isn't
> installed. You can test the $dbh->{syb_has_blk} attribute to see if
> the BLK api calls are available in your copy of DBD::Sybase."
>

And it claims to support this by using the CS_BULK_LOGIN attribute.   
If you grep the FreeTDS sources for CS_BULK_LOGIN, you'll definitely  
find something that looks like support.  If some aspect of it doesn't  
work, or if the DBD::Sybase configuration process doesn't detect it  
correctly, please report it to the relevant list.  At first blush it  
really looks like the Makefile.PL for DBD::Sybase is at fault:

http://cpansearch.perl.org/src/MEWP/DBD-Sybase-1.09/Makefile.PL

You'll see that it configures with -DNO_BLK=1 unless it finds a  
library named blk or libblk or sybblk.  I could be wrong and I don't  
have an installation handy to check, but IIRC, FreeTDS just includes  
the bcp API as part of dblib (or libsybdb?) and does not put it in a  
separate library.  If you can confirm that please report it on RT at:

http://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Sybase

> This feature is labelled "Experimental" but I've had pretty good luck
> with it so far.  It pretty much allows you to do the equivalent of a
> bcp without having to create a bcp file and run an external command.


FreeTDS definitely implements the bcp API:

http://www.freetds.org/reference/a00277.html

________________________________________
Craig A. Berry
mailto:craigberry at mac.com

"... getting out of a sonnet is much more
  difficult than getting in."
                  Brad Leithauser