[freetds] truncated data from query

robert lazarski robertlazarski at gmail.com
Wed Oct 4 12:54:14 EDT 2006


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.
> >
> > Any ideas ?
>
> Robert,
>
> If you would, please try my marvelous new shell script src/apps/osql.
> It's meant to parse your configuration files and report what's being
> used.  I'd like to see the output.  I realize you've configured for TDS
> 8.0, but sometimes the software takes its direction from unexpected
> sources, so it's good to check.
>
> If it says you're using TDS 8.0, please post a TDSDUMP of the session.
> That will tell us if the query is being sent to the server (and if it's
> being received by our odbc driver).
>
> I'm sure there's a limit to the size of a query that the server accepts.
> I'm also sure it's more than 304 bytes.
>
> HTH.
>
> --jkl
>

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.

Thanks!
Robert

> -----------------------------------------
> The information contained in this transmission may be privileged and
> confidential 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.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


More information about the FreeTDS mailing list