FreeTDS Development Group

[Chris Bartram <chrisrbartram AT yahoo.com>]

Thanks! Took care of the Perl .so loading issues...

/usr/local/bin/tsql connection now working; I can connect and query data that 
way.
 
Perl dbi:ODBC fails with following error codes:
 
DBI connect('SQLServer','user',...) failed: [unixODBC][FreeTDS][SQL 
Server]Unable to connect to data source (SQL-08001) [state was 08001 now 
01000]
[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed (SQL-01000)
[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server (SQL-01000) at 
./testscom.pl line 9
 
Source looks like this:
 
$dbh = DBI->connect("dbi:ODBC:SQLServer","user",$userpass);

(also tried the DRIVER={};Server= format; same errors.)
 
Target server is a SQL 2005 cluster; default instance – not a named 
instance.Calling from perl on a RHEL system.

 
Any suggestions?

-Chris Bartram
 "The purpose of life is not to be happy. It is to be useful, to be 
honorable, 
to be compassionate, to have it make some difference that you have lived and 
lived well". (Ralph Waldo Emerson)




________________________________
From: James K. Lowden <jklowden AT freetds.org>
To: freetds AT lists.ibiblio.org
Sent: Wed, May 18, 2011 11:04:43 PM
Subject: Re: [freetds] what am I missing?

On Tue, 17 May 2011 19:30:17 -0700 (PDT)
Chris Bartram <chrisrbartram AT yahoo.com> wrote:

> When I try the ODBC connection in a Perl program I get 
> errors that the .so is not found; yet an ls shows the file(s) right
> where it's supposed to be looking. tsql looks like it might be
> working? 

http://www.freetds.org/91/userguide/linker.how.htm

If Perl says it can't find the .so, it's telling the truth.  Because
Perl::DBI is using dlopen(3), nothing in the Perl executable nor the
DBI library affects where the runtime linker looks.  You have to tell
it.  LD_LIBRARY_PATH is your friend, but you may have to resort to
LD_PRELOAD.  

HTH.  

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

>From randy AT rcs-comp.com  Tue May 24 00:11:42 2011
Return-Path: <randy AT rcs-comp.com>
X-Original-To: freetds AT lists.ibiblio.org
Delivered-To: freetds AT lists.ibiblio.org
Received: by lists.ibiblio.org (Postfix, from userid 20217)
        id 1C625E9407; Tue, 24 May 2011 00:11:42 -0400 (EDT)
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on 
mailman1.ibiblio.org
X-Spam-Level:
X-Spam-Status: No, score=-2.5 required=5.0 tests=AWL,BAYES_00,
        RCVD_IN_DNSWL_LOW autolearn=ham version=3.2.5
Received: from mail-iy0-f177.google.com (mail-iy0-f177.google.com
        [209.85.210.177])
        by lists.ibiblio.org (Postfix) with ESMTP id 78C5CE93ED
        for <freetds AT lists.ibiblio.org>; Tue, 24 May 2011 00:11:41 -0400 (EDT)
Received: by iyb39 with SMTP id 39so6015011iyb.36
        for <freetds AT lists.ibiblio.org>; Mon, 23 May 2011 21:11:41 -0700 (PDT)
Received: by 10.42.149.70 with SMTP id u6mr10333520icv.416.1306210300493;
        Mon, 23 May 2011 21:11:40 -0700 (PDT)
Received: from [192.168.200.22] (74-128-244-206.dhcp.insightbb.com
        [74.128.244.206])
        by mx.google.com with ESMTPS id y20sm3090635ibm.40.2011.05.23.21.11.38
        (version=SSLv3 cipher=OTHER); Mon, 23 May 2011 21:11:39 -0700 (PDT)
Sender: Randy Syring <randy AT rcs-comp.com>
Message-ID: <4DDB2FAC.9040207 AT inteli-com.com>
Date: Tue, 24 May 2011 00:10:20 -0400
From: Randy Syring <rsyring AT inteli-com.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
        rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10
MIME-Version: 1.0
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
References: <461427.10452.qm AT web126006.mail.ne1.yahoo.com>      
<20110518230443.6a25577e.jklowden AT freetds.org>
        <692515.29129.qm AT web126012.mail.ne1.yahoo.com>
In-Reply-To: <692515.29129.qm AT web126012.mail.ne1.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [freetds] what am I missing?
X-BeenThere: freetds AT lists.ibiblio.org
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
List-Id: FreeTDS Development Group <freetds.lists.ibiblio.org>
List-Unsubscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
        <mailto:freetds-request AT lists.ibiblio.org?subject=unsubscribe>
List-Archive: <https://lists.ibiblio.org/sympa/arc/freetds>
List-Post: <mailto:freetds AT lists.ibiblio.org>
List-Help: <mailto:sympa AT lists.ibiblio.org?subject=HELP>
List-Subscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
        <mailto:freetds-request AT lists.ibiblio.org?subject=subscribe>
X-List-Received-Date: Tue, 24 May 2011 04:11:42 -0000

Try TDSDUMPCONFIG to see all the connection params that TDS is using.

http://www.freetds.org/userguide/logging.htm

I don't see a server name or IP address, might that be the issue?

--------------------------------------
Randy Syring
Intelicom
Direct: 502-276-0459
Office: 502-212-9913

For the wages of sin is death, but the
free gift of God is eternal life in
Christ Jesus our Lord (Rom 6:23)


On 05/23/2011 11:51 PM, Chris Bartram wrote:
> Thanks! Took care of the Perl .so loading issues...
>
> /usr/local/bin/tsql connection now working; I can connect and query data 
> that
> way.
>
> Perl dbi:ODBC fails with following error codes:
>
> DBI connect('SQLServer','user',...) failed: [unixODBC][FreeTDS][SQL
> Server]Unable to connect to data source (SQL-08001) [state was 08001 now 
> 01000]
> [unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed (SQL-01000)
> [unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server (SQL-01000) at
> ./testscom.pl line 9
>
> Source looks like this:
>
> $dbh = DBI->connect("dbi:ODBC:SQLServer","user",$userpass);
>
> (also tried the DRIVER={};Server= format; same errors.)
>
> Target server is a SQL 2005 cluster; default instance – not a named
> instance.Calling from perl on a RHEL system.
>
>
> Any suggestions?
>
> -Chris Bartram
>   "The purpose of life is not to be happy. It is to be useful, to be 
> honorable,
> to be compassionate, to have it make some difference that you have lived and
> lived well". (Ralph Waldo Emerson)
>
>
>
>
> ________________________________
> From: James K. Lowden<jklowden AT freetds.org>
> To: freetds AT lists.ibiblio.org
> Sent: Wed, May 18, 2011 11:04:43 PM
> Subject: Re: [freetds] what am I missing?
>
> On Tue, 17 May 2011 19:30:17 -0700 (PDT)
> Chris Bartram<chrisrbartram AT yahoo.com>  wrote:
>
>> When I try the ODBC connection in a Perl program I get
>> errors that the .so is not found; yet an ls shows the file(s) right
>> where it's supposed to be looking. tsql looks like it might be
>> working?
> http://www.freetds.org/91/userguide/linker.how.htm
>
> If Perl says it can't find the .so, it's telling the truth.  Because
> Perl::DBI is using dlopen(3), nothing in the Perl executable nor the
> DBI library affects where the runtime linker looks.  You have to tell
> it.  LD_LIBRARY_PATH is your friend, but you may have to resort to
> LD_PRELOAD.
>
> HTH.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds