Skip to Content.
Sympa Menu

freetds - Re: [freetds] truncated data from query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "robert lazarski" <robertlazarski AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] truncated data from query
  • Date: Wed, 4 Oct 2006 15:45:18 -0300

On 10/4/06, Lowden, James K <james.k.lowden AT alliancebernstein.com> wrote:
> From: robert lazarski
> Sent: Wednesday, October 04, 2006 12:54 PM
>
> On 10/4/06, Lowden, James K <james.k.lowden AT alliancebernstein.com>
> wrote:
> > > From: robert lazarski Sent: Wednesday, October 04, 2006 10:56
> > > AM
> > >
> > > Thanks for the reply Ken. I already had tds as 8.0 . I am not
> > > using PHP, but just the isql shell interface. So at this point
> > > I'm not sure if the problem is freetds, isql or mssql . I didn't
> > > see anything in the php code that sets the max width. All lines
> > > are truncated at exactly 304 char's , which baffles me.
> >
> > If you would, please try my marvelous new shell script src/apps/osql.
>
> jkl - could you please give me a link to your marvelous new shell
> script src/apps/osql´ ;-) ? The freetds-0.65.dev.20060930 with
> unixODBC 2.2.11 I'm using didn't include it or I'm not finding it
> with 'locate' . I tried googling for 'osql' and found lots of info,
> but I'm not sure if that's what you have in mind as it seems
> unrelated - maybe not.

http://freetds.cvs.sourceforge.net/*checkout*/freetds/freetds/src/apps/osql?revision=1.1

Sorry, it's supposed to be in the distribution. I'll try to fix that.

--jkl


Where can I file a bug report ;-) . Maybe its me of course. Here's the output:

/usr/local/etc> ./osql.sh -Snewat3 -Unewatuser3 -Pnewatpassword
newat3 newatuser3 newatpassword
odbc.ini and odbcinst.ini should be in /lib/ld-linux.so.2
using "/root/.odbc.ini"
found this section:
sed: invalid option -- E
Usage: sed [OPTION]... {script-only-if-no-other-script} [input-file]...

Doing an 'strace' on isql, the dir location should be /etc/unixODBC I
believe. The version of sed I got is GNU sed version 4.1.4 . Doing an
echo on SED_CMD I get:

/^\[newat3\]/,/^[[:space:]]*$/ { s/^/ /; p; }

Any ideas?
Robert




Archive powered by MHonArc 2.6.24.

Top of Page