FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> -----Original Message-----
> From: Andrew Shuttlewood [mailto:andrew.shuttlewood AT futureroute.co.uk]
> Sent: martedì 25 febbraio 2003 12.18
> To: FreeTDS Development Group
> Subject: RE: [freetds] ODBC Username?
> 
> 
> On Tue, 2003-02-25 at 11:07, ZIGLIO Frediano wrote:
> <snip>
> > 
> > UID and PWD are not parsed from odbc.ini.
> > This is clearly (I hope) state in
> > http://www.freetds.org/userguide/x1848.htm.
> > odbc.ini is world readable so is not good to store such 
> information on it...
> 
> Ahhh, I didn't quite understand the DSNless connection stuff 
> (as UID is
> listed in the table, I just read it as okay)
> 
> I understand that it's a bit of a gross hack having the DB password in
> there, but we're pulling data internally only, and in fact, mostly to
> migrate it to a different database. 
> 
> second question - is select top x * from .... not supported in freetds
> or a limitation of the underlying database? (kinda muddling my way
> through this I'm afraid!)
> 

>From port you send (4100) you are using Sybase, this query is portable in
both db (ms and sybase ones)
"SET ROWCOUNT xx SELECT * FROM tablename SET ROWCOUNT 0"

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================