Perl to SQL Server connection...???

[goBoating]

hello all,
I have found myself needing to establish a connection with Perl from a Sun Solaris box to an instance of SQL Server (obviously on a Win box).

I have tried using FreeTDS from

http://www.freetds.org.

The install fails it's own test at the 'make test' step. It will not open a connection.

prompt# ./configure --with-tdsver=7.0 <return>

That seems to run just fine. Then,
make <return>

That also seems to work. However, progressing through setting the ENV vars and doing make check results in a failure to connect. Pain in the neck!

The DBD::Sybase docs say it will work if it has access to the CT libraries.
So, I tried using DBD-Sybase with the ctlib stuff from freetds. Again, with no success. I was hoping that the freetds install went well enough to install the ctlib stuff, but, DBD-Sybase does not recognize anything in the freetds installation as being what DBD-Sybase needs, so that fails.

I am trying to avoid going the Proxy server route, just because it adds one more layer.

The SQL Server has a large amount of data that I don't want to duplicate. Otherwise, I would use the PostgreSQL that is running on the Sun and stay in UNIX land.

Has anyone done this trick?
Does anyone know where I can get a copy CT lib to use with DBD-Sybase (other than from freetds.org)? Or, maybe some insight into what I might be doing wrong?
Does anyone know of another module/library combination to try or any other ideas?

Thanks,

It is taking some real effort to resist going on an anti-M$ rant.....*&^@#*%^*&%


keep the rudder amid ship and beware the odd typo

 

[hmerrill]

goBoating, I assume that the 1st part of your note is referring to your trying to use DBD::FreeTDS - the description of DBD::FreeTDS on

http://www.perl.com

says that that is in very early development:

--------------------------------------
This is a sneak peek of a DBD module for Microsoft SQLServer and Sybase. It is in the very early stages of development and many parts of it are not implemented yet. The main advantage of this driver is that it directly speaks the raw TDS protocol and does not need any third party libraries.
--------------------------------------

since you also mention DBD::Sybase, my suggestion is for you to get onto the Sybperl mailing list and post this question. At my last job we used Sybase and I was the first one trying to get Perl connected to Sybase - I posted questions on that list and got very quick answers from Michael Peppler who is the author of Sybperl - he was very helpful, and my guess is he can help you get this going. Good luck.

HTH.
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com