[freetds] truncated data from query
robert lazarski
robertlazarski at gmail.com
Wed Oct 4 14:45:18 EDT 2006
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
More information about the FreeTDS
mailing list