[freetds] truncated data from query
robert lazarski
robertlazarski at gmail.com
Thu Oct 5 09:22:51 EDT 2006
On 10/5/06, ZIGLIO, Frediano, VF-IT <Frediano.Ziglio at vodafone.com> wrote:
>
> I can confirm is a isql problem.
>
> > So could we take a step back for a minute? You're not trying
> > to implement
> > anything in terms of unixODBC's isql; that's just a testing
> > tool, and just
> > maybe it has this limitation. What's the target environment?
> > PHP? Can
> > you use samples/odbctest.php with your query, and see if the
> > same problem
> > manifests itself? Something along those lines?
> >
> > The only direct way to test this is to write and debug a little test
> > application in C that executes your query and prints the
> > result. It would
> > be nice to have our own general-purpose isql-like tool for
> > ODBC; it would
> > help in flushing out bugs (or proving they don't exists).
> > But no one's
> > found the time to do that yet.
> >
Actually isql is my target env ;-) . I'm not using php . Here's what
I'm trying to do:
1) Mimic mysqldump behavior, among others, that generate INSERT
statements from a live db that can be restored - via mssql . I found a
third party stored procedure that can do that.
2) I'm using an ORM tool - java / hibernate but not important here -
that creates a ddl that will drop all tables and fk's, and then create
tables and fk's . At a higher level I use jdbc and the mssql classes
to connect the running program, not freetds.
3) Create the INSERT statements as seen and dump to file, run the ddl,
restore the INSERTs - all via freetds and isql.
So for me, isql / freetds is my batch tool to do mssql admin, without
windows or its tools. I'm not a windows user, my development is
remote, and to access windows tools I'd have to use rdp. Even with the
windows tools I'd still have to bring the file to a shell to
manipulate it a bit. I've already done a lot of mssql admin via isql -
the only problem so far is the truncation issue.
>
> Or you can enable odbc trace.
>
> freddy77
534 lines for those who wish to look at it:
http://www.braziloutsource.com/random/freetds_trace.log
I know C a bit if that is what is needed.
Thanks!
Robert
More information about the FreeTDS
mailing list