DBD-ODBC-1.41-1.el6 cannot talk to SQL Server

Solution Unverified - Updated -

Issue

Some of our DBI/DBD code is unable to connect to a SQL server when running in RHEL 6.3. The same code with identical ODBC and TDS configurations works fine on RHEL5.x (tested 5.6 and 5.8).

osql and tsql connections work fine, so I don't think it's the unixODBC or freetds part of the stack. DBD-Mysql works fine as well.

RHEL 5:

root@lx-chaos01 12:51:11 /root# /auto/survey/bin/sqltest
    DBI 1.52-ithread default trace level set to 0x0/1 (pid 15408)
DSN=dbi:ODBC:DRIVER={AMPROD};Server=amdb;database=amprod
DBUSER=acserveradmin
    -> DBI->connect(dbi:ODBC:DRIVER={AMPROD};Server=amdb;database=amprod, acserveradmin, ****)
    -> DBI->install_driver(ODBC) for linux perl=5.008008 pid=15408 ruid=0 euid=0
       install_driver: DBD::ODBC version 1.16 loaded from /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBD/ODBC.pm
    <- install_driver= DBI::dr=HASH(0xb168b90)
    <- connect('DRIVER={AMPROD};Server=amdb;database=amprod' 'acserveradmin' ...)= DBI::db=HASH(0xb5ef950) at DBI.pm line 625
    <- STORE('PrintError' 1)= 1 at DBI.pm line 672
    <- STORE('AutoCommit' 1)= 1 at DBI.pm line 672
    <- STORE('Username' 'acserveradmin')= 1 at DBI.pm line 675
    <> FETCH('Username')= 'acserveradmin' ('Username' from cache) at DBI.pm line 675
    <- connect= DBI::db=HASH(0xb5ef950)
    <- STORE('dbi_connect_closure' CODE(0xb5f5c00))= 1 at DBI.pm line 691
    <- prepare('Select * from CIG_CostCenters_vw')= DBI::st=HASH(0xb5f5e00) at sqltest line 25
    <- execute= -1 at sqltest line 26
    <- fetchrow_hashref= HASH(0xb5f5ff0)6keys row1 at sqltest line 29
    <- fetchrow_hashref= undef row1167 at sqltest line 30
Got 1167 rows
    <- DESTROY(DBI::st=HASH(b5ef3f0))= undef
    <- DESTROY(DBI::db=HASH(b5f5790))= undef
    <- disconnect_all= '' at DBI.pm line 700
!   <- DESTROY(DBI::dr=HASH(b168b90))= undef during global destruction

RHEL 6:

[root@lx-chaos02 ~]# /auto/survey/bin/sqltest
    DBI 1.609-ithread default trace level set to 0x0/1 (pid 17885) at sqltest line 20
DSN=dbi:ODBC:DRIVER={AMPROD};Server=amdb;database=amprod
DBUSER=acserveradmin
    -> DBI->connect(dbi:ODBC:DRIVER={AMPROD};Server=amdb;database=amprod, acserveradmin, ****)
    -> DBI->install_driver(ODBC) for linux perl=5.010001 pid=17885 ruid=0 euid=0
       install_driver: DBD::ODBC version 1.41 loaded from /usr/lib64/perl5/vendor_perl/DBD/ODBC.pm
    <- install_driver= DBI::dr=HASH(0xa04268)
    !! warn: 0 CLEARED by call to connect method
    !! ERROR: 1 '[unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)' (err#0)
    <- connect('DRIVER={AMPROD};Server=amdb;database=amprod', 'acserveradmin', ...)= undef at DBI.pm line 654
    <- $DBI::errstr= '[unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)'
       DBI connect('DRIVER={AMPROD};Server=amdb;database=amprod','acserveradmin',...) failed: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
DBI connect('DRIVER={AMPROD};Server=amdb;database=amprod','acserveradmin',...) failed: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001) at /auto/survey/bin/sqltest line 23
    <- $DBI::errstr= '[unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)'
Can't connect to amprod: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
    !! ERROR: 1 CLEARED by call to disconnect_all method
    <- disconnect_all= '' at DBI.pm line 732
!   <- DESTROY(DBI::dr=HASH(a04268))= undef during global destruction

Environment

Red Hat Enterprise Linux
6.3

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.