Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

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

Comment on Re: Accessing Microsoft SQL Server from Linux using DBD::ODBC
Download Code

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 perusing the Monastery: (11)
As of 2015-11-30 21:26 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (783 votes), past polls