[freetds] FreeTDS - freebcp issues

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Wed Jan 25 09:38:17 EST 2006


> 
> Problem;
> The 'Nightly Snapshot' version of bcp 'in' does not seem to work.  It
> reports no error but does not actually bcp in any rows.  The Stable
> Release version (0.63) works correctly. I am working on a Redhat Linux
> platform connecting to a MS SQL Server.
> 
> Below are the my details of the problem;
> 
> Sample I - Using the latest Nightly Snapshot
> 1029> cat bcpin_script
> #!/bin/csh
> 
> bcp "CGTEST..AKA" in AKA.BCP \
>          -c \
>          -U CGTEST \
>          -P CGTEST \
>          -S CHAOS \
>          -t "~|" \
>          -m 1000 \
>          -e AKA.ERR
> exit
> 1030> cat AKA.BCP
> 100~|C~|C~|100LBCYL~|0~|A~|01/17/2006~|INITIAL_LOAD
> 1031> setenv TDSDUMP BCPTEST
> 
> 1032> source bcpin_script
> 
...
>  
> >From my investigation, the following line seems to be the important
> difference in the log files;
> 
> Nightly Snapshop Version;  bcp.c:1180:_bcp_measure_terminated_field
> returned -1!
> Stable (0.64) Version;     15:14:11.185630 
> _bcp_measure_terminated_field
> returned 3
> 

Opps... there were an error checking fseeko return. I fixed the problem
(both 0.64 and CVS HEAD). However I don't understand why our tests
success....

freddy77


More information about the FreeTDS mailing list