Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Accessing Microsoft SQL Server from Linux using DBD::ODBC

by imp (Priest)
on Oct 27, 2006 at 16:20 UTC ( #580951=note: print w/replies, xml ) Need Help??

in reply to Accessing Microsoft SQL Server from Linux using DBD::Sybase

Excellent guide.

Another option is to use DBD::ODBC with iodbc and freetds. This gives you the ability to use bound parameters.

Note that freetds has to be compiled for iodbc, and DBD::ODBC does as well. Here is the install sequence I used about a year ago (check for new versions):

# Install libiodbc wget && tar -xzf libiodbc-3.52.3.tar.gz && cd libiodbc-3.52.3 && ./configure && make && make install # Install freetds wget +le.tgz tar -xzf freetds-stable.tgz && cd freetds-0.63 && ./configure -with-iodbc && make && make install # Configure odbc.ini echo "[foo] Database=foo Server= TDS_Version=8.0 Port=1433 Driver=/usr/local/lib/" > /etc/odbc.ini # install DBD::ODBC perl -MCPAN -e'get DBD::ODBC' && cd ~/.cpan/build/DBD-ODBC-1.13 && export ODBCHOME=/usr/local && perl Makefile.PL && make && make install

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://580951]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (10)
As of 2016-10-24 19:03 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (309 votes). Check out past polls.