Re: DBD::ODBC, unixODBC, FreeTDS, MS-SQL, lazy DL, dbd_db_login/SQLSetConnectOption err=-2

From: Cosimo Streppone (cstreppone_at_team2k.net)
Date: 01/05/05

  • Next message: Michael Peppler: "Re: DBD::ODBC, unixODBC, FreeTDS, MS-SQL, lazy DL, dbd_db_login/SQLSetConnectOption err=-2" 
    Date: Wed, 05 Jan 2005 08:55:26 +0100
To: Honza Pazdziora <adelton@fi.muni.cz>

    Honza Pazdziora wrote:

    > I have succesfully installed
    >
    > freetds-0.62.3-1.1.fc3.rf from Dag Wieers's rpm repository
    > unixODBC-2.2.9-42
    > unixODBC-devel-2.2.9-42 from Fedora Core 3's rpm repository
    > DBD::ODBC 1.13 from sources from CPAN
    >
    > on top of
    >
    > perl, v5.8.3 built for i386-linux-thread-multi
    > from FC3's perl-5.8.3-5 rpm
    >
    > Accessing the remote MS-SQL from Linux box is my goal.
    >
    > [...]
    >
    > Or, does anyone use the combination of software mentioned
    > above (or similar) to work successfully with MS-SQL from Linux?

    I have successfully used this combination:

    - DBI :-)
    - DBD::Sybase 1.04, compiled with $ENV{SYBASE}='/your/freetds/install'
    - freetds 0.6x

    to connect to MS-SQL 7 and 2000.
    Some random drawbacks:
    - No placeholders (I don't know if this is possible with ODBC)
    - No proper transaction handling (again, don't know if it is a
       freetds problem or my-application problem)

    I recall there was a thread started by Matt Sergeant on some
    dbi list, probably more than a year ago... 

    -- 
Cosimo
  • Next message: Michael Peppler: "Re: DBD::ODBC, unixODBC, FreeTDS, MS-SQL, lazy DL, dbd_db_login/SQLSetConnectOption err=-2"

    Relevant Pages