FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

All, 

I just applied fixes to bcp.c and dblib.c that address two segment fault
conditions that were due to insufficient buffer sizes.  I just used freebcp
to load 23 different tables, some of which have 180 columns.  

Although it could do a better job of detecting mismatches between the data
file and the table layout, on the whole freebcp is approaching the vendors'
utilities in terms of quality.  

I might mention that FreeTDS is better in my particluar situtation than
anything else.  Some years ago, I discovered that Sybase's pre-System 10
dblib could not load very wide tables.  I never looked into it, but it's
almost certainly a 4.2 protocol limitation.   To work around the problem, we
split the data vertically into three narrower ones, and loaded them.  Why
were we using Sybase's old libraries?  That was the only db-lib available on
a Unix platform that would connect to a Microsoft data server.  

With FreeTDS, we're now able to load the tables in their native form, no
matter how wide.  Such are the joys.  Have a good weekend.  

--jkl


The information contained in this transmission may contain privileged and
confidential information 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.