[WindyCity-pm] installing the same module twice

[Whitney Jackson]

> Is there a FreeTDS module out there you can use for the MSSQL db rather
> than trying to have two different varieties sharing the same namespace?

This is the list of APIs freetds supports:  http://www.freetds.org/software.html

The only thing that looks like a possibility is DBD::ODBC on top of
unixODBC on top of freetds.  I could try using that solution for
everything that needs FreeTDS.  I don't have any experience with
unixODBC but I suppose it might work.

Alternatively, I could create DBD::FreeTDS by copying DBD::Sybase and
renaming everything appropriately.  That seems like a real pain though
and would of course need to be maintained over time.

Whitney

On Fri, Feb 13, 2009 at 3:46 PM, Jeremy Wall <jeremy at marzhillstudios.com> wrote:
> That sounds like a sticky requirement there. Maybe you could hack something
> together with fancy @INC hacking but it sounds like you are trying to make
> DBD::Sybase do something it really shouldn't be used for. Is there a FreeTDS
> module out there you can use for the MSSQL db rather than trying to have two
> different varieties sharing the same namespace?
>
> On Fri, Feb 13, 2009 at 12:36 PM, Whitney Jackson <whjackson at gmail.com>
> wrote:
>>
>> It turns out there are two ways (at least) to build DBD::Sybase:
>>
>> 1) Against FreeTDS Libraries
>> 2) Against Sybase Open Client Libraries
>>
>> When you choose option 1 you can talk to MSSQL as well as Sybase.
>> This works b/c both DBs use the TDS protocol.
>>
>> With option 2 you can only talk to Sybase DBs but you have the ability
>> to use additional features like bulk writes not supported with
>> FreeTDS.
>>
>> My problem is that I need the benefits of both.  When I use DBI to
>> connect to a Sybase DB I want the module built against the Sybase Open
>> Client libraries.  On the other hand, a DBI connect against a MSSQL DB
>> should use the DBD::Sybase built against FreeTDS.
>>
>> Does anyone know a clean way to install DBD::Sybase twice and have the
>> right one to load when I do a DBI connect?
>>
>> Whitney
>> _______________________________________________
>> WindyCity-pm mailing list
>> WindyCity-pm at pm.org
>> http://mail.pm.org/mailman/listinfo/windycity-pm
>
>
>
> --
> Jeremy Wall
> http://jeremy.marzhillstudios.com
> Jeremy at marzhillstudios.com
>