[freetds] RE: Re: (no subject) (Frediano Ziglio)

Damian Marinaccio dxmwml at rit.edu
Thu May 13 08:37:49 EDT 2004


The Snapshot available on the website still seems to be from 5-07?

Damian


-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of
freetds-request at lists.ibiblio.org
Sent: Wednesday, May 12, 2004 12:06 PM
To: freetds at lists.ibiblio.org
Subject: FreeTDS Digest, Vol 16, Issue 12


Send FreeTDS mailing list submissions to
	freetds at lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
	freetds-request at lists.ibiblio.org

You can reach the person managing the list at
	freetds-owner at lists.ibiblio.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of FreeTDS digest..."


Today's Topics:

   1. Re: RPM version different? (Michael Peppler)
   2. RE: RPM version different? (Lowden, James K)
   3. Re: RPM version different? (Pete Prodoehl)
   4. Re: RPM version different? (Greg Fisher)
   5. RE: RPM version different? (Lowden, James K)
   6. Re: (no subject) (Frediano Ziglio)
   7. Re: Another OTL question / problem (Frediano Ziglio)
   8. RE: Another OTL question / problem (Piet De Jong)


----------------------------------------------------------------------

Message: 1
Date: Tue, 11 May 2004 18:23:21 +0200
From: Michael Peppler <mpeppler at peppler.org>
Subject: Re: [freetds] RPM version different?
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <1084292601.2090.31.camel at elanor.peppler.org>
Content-Type: text/plain

On Tue, 2004-05-11 at 17:50, Greg Fisher wrote:
> Hi,
> I have just installed the RPM version (freetds-0.62.1-1.i586.rpm) on 
> my
> Fedora Core 1 server.  Seems to be working fine when I test using
"tsql" 
> utility.  My question is about setting the environment variable 
> "SYBASE".  The documentation and FAQs indicate that the default 
> installation is to /usr/local/freetds, but the RPM install did not 
> create this directory.  Where do I point the SYBASE environment
variable 
> to?  I want to use the CTLIB API.  Have I skipped a step along the
way?  

My guess is that the rpm installs things in /usr/lib /etc/ and
/usr/include. In which case you should probably set SYBASE to /usr.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler at peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html




------------------------------

Message: 2
Date: Tue, 11 May 2004 12:19:02 -0400
From: "Lowden, James K" <LowdenJK at bernstein.com>
Subject: RE: [freetds] RPM version different?
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Message-ID:
	
<3778FAB3D61A7A40833F1CB3B8C173AA02A3F649 at AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain;	charset="iso-8859-1"

> From: freetds-bounces at lists.ibiblio.org 
> [mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of Greg Fisher
>
> I have just installed the RPM version
> (freetds-0.62.1-1.i586.rpm) on my 
> Fedora Core 1 server.  Seems to be working fine when I test 
> using "tsql" 
> utility.  My question is about setting the environment variable 
> "SYBASE".  The documentation and FAQs indicate that the default 
> installation is to /usr/local/freetds, but the RPM install did not 
> create this directory.  Where do I point the SYBASE 
> environment variable 
> to?  I want to use the CTLIB API.  

Welcome, Greg.  

Probably you don't need a SYBASE variable.  FreeTDS doesn't use it
except to find the 'interfaces' file (which you'd know if you needed).
Some applications use a SYBASE variable to locate the shared libraries.
sqsh uses it at build time iirc.  

The right value for SYBASE (if it's needed) is FreeTDS's installation
prefix.  That is, if tsql is in /usr/local/bin, and sybdb.h is in
/usr/local/include, then FreeTDS's installation prefix was /usr/local,
and you should "export SYBASE=/usr/local".  

I'll have to review the docs on this score.  There shouldn't be any
references to "/usr/local/freetds" anymore.  FreeTDS's default prefix
was changed to /usr/local back with 0.60 as I recall.  

--jkl

















-----------------------------------------
The information contained in this transmission may contain privileged
and confidential information and is intended only for the use of the
person(s) named above. If you are not the intended recipient, or an
employee or agent responsible for delivering this message to the
intended recipient, any review, dissemination, distribution or
duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender immediately by reply
e-mail and destroy all copies of the original message. Please note that
we do not accept account orders and/or instructions by e-mail, and
therefore will not be responsible for carrying out such orders and/or
instructions. If you, as the intended recipient of this message, the
purpose of which is to inform and update our clients, prospects and
consultants of developments relating to our services and products, would
not like to receive further e-mail correspondence from the sender,
please "reply" to the sender indicating your wishes.  In the U.S.: 1345
Avenue of the Americas, New York, NY 10105.




------------------------------

Message: 3
Date: Tue, 11 May 2004 12:29:36 -0500
From: Pete Prodoehl <pete.prodoehl at cygnusinteractive.com>
Subject: Re: [freetds] RPM version different?
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <40A10D80.7010705 at cygnusinteractive.com>
Content-Type: text/plain; charset=us-ascii; format=flowed

Lowden, James K wrote:
> Probably you don't need a SYBASE variable.  FreeTDS doesn't use it 
> except to find the 'interfaces' file (which you'd know if you needed).
Some applications use a SYBASE variable to locate the shared libraries.
sqsh uses it at build time iirc.
> 
> The right value for SYBASE (if it's needed) is FreeTDS's installation 
> prefix.  That is, if tsql is in /usr/local/bin, and sybdb.h is in
/usr/local/include, then FreeTDS's installation prefix was /usr/local,
and you should "export SYBASE=/usr/local".
> 
> I'll have to review the docs on this score.  There shouldn't be any 
> references to "/usr/local/freetds" anymore.  FreeTDS's default prefix
was changed to /usr/local back with 0.60 as I recall.
> 
> --jkl
> 


I'm a bit of a FreeTDS newbie. I'm using Perl and the DBD::Sybase 
module, and I had read in somewhere that I should put:

   BEGIN
   {
       $ENV{SYBASE} = "/usr/local/freetds";
   }

near the top of the script. Is this not needed then?

I commenting it out and running my code it seems to work fine, so I'm 
inclined to delete if it is not needed.

Are there cases where this would be needed?


Pete




------------------------------

Message: 4
Date: Tue, 11 May 2004 13:49:31 -0400
From: Greg Fisher <fisherg at musc.edu>
Subject: Re: [freetds] RPM version different?
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <40A1122B.5070008 at musc.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Thanks for the fast response.  That *does* seem to be the case.

Greg


Michael Peppler wrote:

>On Tue, 2004-05-11 at 17:50, Greg Fisher wrote:
>  
>
>>Hi,
>>I have just installed the RPM version (freetds-0.62.1-1.i586.rpm) on 
>>my
>>Fedora Core 1 server.  Seems to be working fine when I test using
"tsql" 
>>utility.  My question is about setting the environment variable 
>>"SYBASE".  The documentation and FAQs indicate that the default 
>>installation is to /usr/local/freetds, but the RPM install did not 
>>create this directory.  Where do I point the SYBASE environment
variable 
>>to?  I want to use the CTLIB API.  Have I skipped a step along the
way?  
>>    
>>
>
>My guess is that the rpm installs things in /usr/lib /etc/ and 
>/usr/include. In which case you should probably set SYBASE to /usr.
>
>Michael
>  
>


------------------------------

Message: 5
Date: Tue, 11 May 2004 14:39:08 -0400
From: "Lowden, James K" <LowdenJK at bernstein.com>
Subject: RE: [freetds] RPM version different?
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Message-ID:
	
<3778FAB3D61A7A40833F1CB3B8C173AA02A3F64C at AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain;	charset="iso-8859-1"

> From: freetds-bounces at lists.ibiblio.org 
> [mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of Pete Prodoehl
> Sent: May 11, 2004 1:30 PM
> 
> I'm a bit of a FreeTDS newbie. I'm using Perl and the DBD::Sybase
> module, and I had read in somewhere that I should put:
> 
>    BEGIN
>    {
>        $ENV{SYBASE} = "/usr/local/freetds";
>    }
> 
> near the top of the script. Is this not needed then?

It's not needed by FreeTDS if you're using freetds.conf to describe your
servers.  

Real live ct-lib from Sybase uses the SYBASE variable to locate its
interfaces file.  FreeTDS's equivalent, freetds.conf, has its location
established at build time.  

Cf. "perldoc DBD::Sybase" for more information.  DBI does not use
$SYBASE, and I'm pretty sure DBD::SYBASE doesn't, either.  

--jkl










-----------------------------------------
The information contained in this transmission may contain privileged
and confidential information and is intended only for the use of the
person(s) named above. If you are not the intended recipient, or an
employee or agent responsible for delivering this message to the
intended recipient, any review, dissemination, distribution or
duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender immediately by reply
e-mail and destroy all copies of the original message. Please note that
we do not accept account orders and/or instructions by e-mail, and
therefore will not be responsible for carrying out such orders and/or
instructions. If you, as the intended recipient of this message, the
purpose of which is to inform and update our clients, prospects and
consultants of developments relating to our services and products, would
not like to receive further e-mail correspondence from the sender,
please "reply" to the sender indicating your wishes.  In the U.S.: 1345
Avenue of the Americas, New York, NY 10105.




------------------------------

Message: 6
Date: Tue, 11 May 2004 21:23:04 +0200
From: Frediano Ziglio <freddyz77 at tin.it>
Subject: Re: [freetds] (no subject)
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <1084303384.4780.5.camel at freddy>
Content-Type: text/plain

Il mar, 2004-05-11 alle 16:17, Damian Marinaccio ha scritto:
> Hello. Still trying to get this installed on Solaris. I am using the 
> snapshot from 5/07/04. Make is failing now. I upgraded libtool & 
> autoconf based on some findings in the mailing list but I am now 
> getting a new error. See below:
> 

Try tomorrow snapshot. I limited export and asprintf was not exported
from dblib...

> 
> if gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include 
> -D_FREETDS_LIBRARY_SOURCE -DMSDBLIB -D_REENTRANT -D_THREAD_SAFE -DD\
>   -c -o bsqldb.o `test -f 'bsqldb.c' || echo './'`bsqldb.c; \ then mv 
> ".deps/bsqldb.Tpo" ".deps/bsqldb.Po"; \ else rm -f ".deps/bsqldb.Tpo";

> exit 1; \ fi
> bsqldb.c: In function `print_results':
> bsqldb.c:464: warning: implicit declaration of function `asprintf'

I'll try to remove this warning...

bye
  freddy77




------------------------------

Message: 7
Date: Tue, 11 May 2004 21:52:35 +0200
From: Frediano Ziglio <freddyz77 at tin.it>
Subject: Re: [freetds] Another OTL question / problem
To: FreeTDS Development Group <freetds at lists.ibiblio.org>
Message-ID: <1084305155.4780.23.camel at freddy>
Content-Type: text/plain

Il lun, 2004-05-10 alle 19:54, Piet De Jong ha scritto:
> Hi All,
> Attached I have a very simple select statement which is supposed to 
> return a single column. However when I run the program I do not get 
> any data returned.
>  
> I use the latest version of OTL ( 4.0.84 )
>  
> I am not sure if I had asked this question before, I could not find it

> on the list.
>  
> The platform with the problem:
> Slackware 9.1.0
> using iodbc 3.51.1
> gcc version: 3.2.3
>  
> When I compile and run the attached example on Windows I dont have any

> problems, the correct values ( 1  and RPC = 1 ) are returned.
>  
> Many thanks
> PIet
>  

>From log (unixODBC)

[ODBC][21603][SQLPrepare.c][173]
                Entry:
                        Statement = 0x91ce160
                        SQL = [select revision from revisiontable where
version = 1][length = 52 (SQL_NTS)] [ODBC][21603][SQLPrepare.c][374]
                Exit:[SQL_SUCCESS]
[ODBC][21603][SQLNumResultCols.c][142]
                Entry:
                        Statement = 0x91ce160
                        Column Count = 0xbfeea3ac
[ODBC][21603][SQLNumResultCols.c][233]
                Exit:[SQL_SUCCESS]
                        Count = 0xbfeea3ac -> 0
[ODBC][21603][SQLSetStmtAttr.c][217]
                Entry:
                        Statement = 0x91ce160
                        Attribute = SQL_ATTR_ROW_ARRAY_SIZE
                        Value = 0x1
                        StrLen = -3 [ODBC][21603][SQLSetStmtAttr.c][666]
                Exit:[SQL_SUCCESS] [ODBC][21603][SQLSetStmtAttr.c][217]
                Entry:
                        Statement = 0x91ce160
                        Attribute = SQL_ATTR_ROWS_FETCHED_PTR
                        Value = 0x91ce01c
                        StrLen = -3 [ODBC][21603][SQLSetStmtAttr.c][666]
                Exit:[SQL_SUCCESS] [ODBC][21603][SQLExecute.c][186]
                Entry:
                        Statement = 0x91ce160
[ODBC][21603][SQLExecute.c][341]
                Exit:[SQL_SUCCESS] [ODBC][21603][SQLFetchScroll.c][145]
                Entry:
                        Statement = 0x91ce160
                        Fetch Orentation = 1
                        Fetch Offset = 1
[ODBC][21603][SQLFetchScroll.c][346]
                Exit:[SQL_SUCCESS] [ODBC][21603][SQLFetchScroll.c][145]
                Entry:
                        Statement = 0x91ce160
                        Fetch Orentation = 1
                        Fetch Offset = 1
[ODBC][21603][SQLFetchScroll.c][346]
                Exit:[SQL_NO_DATA] [ODBC][21603][SQLFreeStmt.c][133]
                Entry:
                        Statement = 0x91ce160
                        Option = 0 [ODBC][21603][SQLFreeStmt.c][246]
                Exit:[SQL_SUCCESS] [ODBC][21603][SQLFreeStmt.c][133]
                Entry:
                        Statement = 0x91ce160
                        Option = 1 [ODBC][21603][SQLFreeHandle.c][353]
                Entry:
                        Handle Type = 3
                        Input Handle = 0x91ce160
[ODBC][21603][SQLFreeHandle.c][454]
                Exit:[SQL_SUCCESS] [ODBC][21603][SQLEndTran.c][315]
                Entry:
                        Connection = 0x91a7dd0
                        Completion Type = 0

The key it's always (like Oracle connector) SQLNumResultCols after
SQLPrepare... trying with --enable-developing you will get what you
expect:

$ rm /tmp/sql.log && g++ test_select.cpp -lodbc && ./a.out
test_select.cpp:78 - Rev [1] test_select.cpp:79 - RPC: 1

Current implementation it's no so instable however performance are not
that fine...

More deeply from code comments:

 /* try to prepare query */
 /* TODO try to prepare only getting informations (faster and
optimizable) for mssql2k */

This can wait however mssql2k can prepare and execute using a single
round-trip (a single store procedure call). Not stopping (for 0.63)

 /* TODO support getting info for RPC */

I don't even know if this is possible...

 /*
  * TODO this should be done if all parameters are bounded or using TDS5
  * binary_test for example do not work for this problem (post bind on
image)
  */

binary_test now works using Sybase, not a stop-over, however this
optimization IMO should be implemented in 0.63!

 /* TODO use current parameter informations */  stmt->need_reprepare =
1;

quite bad... for every prepare it prepare statement 2 times... just
cause it need to pass types...


This just to explain that this way of getting result it's not that
good!!! IMHO library should change their code to a more optimized way!!!

freddy77




------------------------------

Message: 8
Date: Wed, 12 May 2004 13:18:05 +0200
From: "Piet De Jong" <piet at ahead-tech.net>
Subject: RE: [freetds] Another OTL question / problem
To: "'FreeTDS Development Group'" <freetds at lists.ibiblio.org>
Message-ID: <001801c43812$d2e6e2d0$5000a8c0 at laptoppiet>
Content-Type: text/plain;	charset="us-ascii"

> 
> The key it's always (like Oracle connector) SQLNumResultCols
> after SQLPrepare... trying with --enable-developing you will 
> get what you
> expect:
> 

Thanks that works on the daily build.
Can I use daily build in staging ( not develop, not live ) ?

Many thanks
Piet




------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 16, Issue 12
***************************************



More information about the FreeTDS mailing list