[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