Re: Concurrent usage both Sybase and FreeTDS

I have a DBD::Freetds that I built 18 months ago (or maybe even 2 years
ago) that you should be able to use. I'll upload it to my web site later
today, or tomorrow if I don't have the time today (there's a DBD::FreeTDS
0.10 on my website already, but it's not really adequate).

Note that I haven't worked on this code in a long time, but it should be
good enough to handle your problems and to allow you to use both FreeTDS
and Sybase libs in the same perl script.

Michael




Internet
[email protected]@peppler.org - 07/07/2005 13:11


Sent by:    [email protected]

To:    sybperl-l

cc:


Subject:    Concurrent usage both Sybase and FreeTDS


Hi,

I have to a project that will move data between Microsoft SQL server
(2003) and Sybase server. The only way to access the SQL server is with
FreeTDS (I'm using 0.63), tested with SQSH. The Sybase servers must be
used using Sybase clients libraries (company rule).

Does anyone has experience on how to work with both databasesin the same
perl program. I was hoping to duplicate "DBD::Sybase" into
"DBD::FreeTDS" that will be linked against the FreeTDS libraries, and
then I can use 'dbi::Sybase' to access the Sybase server, and
'dbi::FreeTDS' to access the SQL server.

My major concern is how to keep the 'libct.so' separate. I'm not sure if
this is possible, and if there is a problem here.

Any advice will be appreciated.

Thanks
Yair Lenga




This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.