How to install DBI::Sybase if Sybase is not installed locally?

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

The subject basically says it all...

I have a RH7 box with a remote host running Sybase. I need to connect to my remote host (Solaris Box) and query it. However, whenever I try to install the DBI::Sybase module it fails because it's looking for my local install of Sybase.

I get the following error and the make and install fail.

Can't find any Sybase libraries under /lib.
Please set the SYBASE environment correctly, or edit CONFIG and set SYBASE

Checking the Readme I'm told that this variable should be set by default in Unix and Linux, but that if it's not, to edit my CONFIG and set the locations of my SYBASE install.

Any help much appreciated!

Thanks, Alatar

Comment on How to install DBI::Sybase if Sybase is not installed locally?

Replies are listed 'Best First'.
Re: How to install DBI::Sybase if Sybase is not installed locally? (boo) by boo_radley (Parson) on Nov 16, 2001 at 19:53 UTC
It really does require Sybase or FreeTDS.	[reply]
Re: How to install DBI::Sybase if Sybase is not installed locally? by Biker (Priest) on Nov 16, 2001 at 20:13 UTC
Alatar, the DBI::Sybase will require you to have a 'Sybase Open Client' (or eq) installed on the same computer. f--k the world!!!! /dev/world has reached maximal mount count, check forced.	[reply]
Re: How to install DBI::Sybase if Sybase is not installed locally? by drewcifer (Novice) on Nov 16, 2001 at 21:30 UTC
You will need to install The Sybase Open Client Libraries. You can get an RPM from Sybase for free and install it. This will let you install DBD::Sybase. Don't forget to read the Readme file and configure the database config file so the make test phase will pass or you can force it. Good luck. Please feel free to ask me any questions.	[reply]
Re: How to install DBI::Sybase if Sybase is not installed locally? by mpeppler (Vicar) on Nov 16, 2001 at 22:20 UTC
You need to install the Sybase OpenClient libraries. You can download a free version of OpenClient from Sybase, or depending on the licence you have for the Solaris version you can get the more recent 11.1.1 or 12.5 libraries (which aren't free, but can still be downloaded for free trials.) For the 11.1.1 or 12.5 version you need the "common" and the "openclient" rpms. For the free 11.0.3.3 version you'll need to download both rpms (server and client). Remember to create a correct interfaces file on the linux side - the default Solaris TLI format will not work on linux, so the easiest thing to do is to use "sybinit" (in the 11.0.3.3 release) or "dsedit" (for the more recent versions) to create the appropriate interfaces file entries. Good luck! Michael	[reply]
Re: How to install DBI::Sybase if Sybase is not installed locally? by hans_moleman (Beadle) on Nov 16, 2001 at 21:48 UTC
Alatar, Are you connecting to a remote Microsoft SQL Server or a remote Sybase server? If you are connecting to a Sybase server, then the advice you received above about installing Open Client is probably best. If you are trying to connect to MS SQL, FreeTDS is your best route. I have used the Mandrake FreeTDS RPM on Red Hat 7.1 and 7.2 and it works, although YMMV with 7.0. Take a peek in /etc/freetds.conf after installing the RPM and edit it to suit your environment. Good luck! update11/23/2001: Obviously this doesn't answer the question he asked, since there is no Solaris version of Microsoft SQL ;) Oh well, maybe it'll help someone else	[reply]