Re^2: Accessing Microsoft SQL Server from Linux using DBD::Sybase

[dragooneye]

Thanks a million briantillman and CleverFox. Couldn't have done this without you guys. After following your steps, I got a script to connect and make queries. This will save me a LOT of time.

I have

• MS SQL Server 2005
• Perl 5.8.5
• libdbi 0.6.5
• RHEL 4 nahant u 5

Needed DBD-Sybase-1.04 as briantillman pointed out (from http://www.peppler.org/freeware/dbd-sybase.html).

For noobs such as myself, needed to use the following to grab my versions:

• cat /etc/redhat-release
• rpm -qa | grep libdbi
• perl -v

Other observations (which could be triggered by my older versions of things): the  export SYBASE=/usr/local/freetds wouldn't work with the latest DBD-Sybase-1.11. I would get

# perl Makefile.PL
Unknown Client Library version - assuming FreeTDS.

Also when doing a make with DBD-Sybase-1.11 and my versions, I would get the following:

/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h: In function `dbixst_bounce_method':
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h:14: error: `my_perl' undeclared (first use in this function)
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h:14: error: (Each undeclared identifier is reported only once
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h:14: error: for each function it appears in.)
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h: In function `dbdxst_bind_params':
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h:54: error: `my_perl' undeclared (first use in this function)
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h: In function `dbdxst_fetchall_arrayref':
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBI/Driv
+er_xst.h:75: error: `my_perl' undeclared (first use in this function)
make: *** [Sybase.o] Error 1

One last note, I am able to connect to MS SQL Server 2005 with tds version = 7.0.